How to setup Multiple tempdbs?

Hi,
We have got a huge SQL server 2000 box and we want to setup Multiple
tempdbs for a multiprocessor machine, but do not know how.
Anyone that can help please?
Thanks"Jnadile" <Jnadile@.discussions.microsoft.com> wrote in message
news:9E5C5454-8C17-4CC5-B00B-4FD7FCD08A35@.microsoft.com...
> Hi,
> We have got a huge SQL server 2000 box and we want to setup Multiple
> tempdbs for a multiprocessor machine, but do not know how.
>
You can not set up multiple tempdbs.
You can however add FILES to the existing one.
Check out the alter database command.
> Anyone that can help please?
> Thanks
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Hi
"Jnadile" wrote:
> Hi,
> We have got a huge SQL server 2000 box and we want to setup Multiple
> tempdbs for a multiprocessor machine, but do not know how.
> Anyone that can help please?
> Thanks
You can only have one tempdb per instance, but it is beneficial to have
multiple files for the tempdb that match the number of (logical) processes,
as this will help to reduce contention. For SQL 2000 you will also need to
set the trace flag 1118 and implement hotfix 702 see
http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx
To increase the number of files use the ALTER DATABASE command
http://msdn2.microsoft.com/en-us/library/aa275464(SQL.80).aspx
HTH
John|||"John Bell" wrote:
> Hi
> "Jnadile" wrote:
> > Hi,
> >
> > We have got a huge SQL server 2000 box and we want to setup Multiple
> > tempdbs for a multiprocessor machine, but do not know how.
> >
> > Anyone that can help please?
> >
> > Thanks
> You can only have one tempdb per instance, but it is beneficial to have
> multiple files for the tempdb that match the number of (logical) processes,
Typo processes should be processors ie. CPUs!
It is also advised that if you have detected blocking on tempdb, then to
increase the number of files gradually up to the recommended number and stop
at the minumum number where it does not block.
Johnsql

How to setup Multiple tempdbs?

Hi,
We have got a huge SQL server 2000 box and we want to setup Multiple
tempdbs for a multiprocessor machine, but do not know how.
Anyone that can help please?
Thanks
"Jnadile" <Jnadile@.discussions.microsoft.com> wrote in message
news:9E5C5454-8C17-4CC5-B00B-4FD7FCD08A35@.microsoft.com...
> Hi,
> We have got a huge SQL server 2000 box and we want to setup Multiple
> tempdbs for a multiprocessor machine, but do not know how.
>
You can not set up multiple tempdbs.
You can however add FILES to the existing one.
Check out the alter database command.

> Anyone that can help please?
> Thanks
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html
|||Hi
"Jnadile" wrote:

> Hi,
> We have got a huge SQL server 2000 box and we want to setup Multiple
> tempdbs for a multiprocessor machine, but do not know how.
> Anyone that can help please?
> Thanks
You can only have one tempdb per instance, but it is beneficial to have
multiple files for the tempdb that match the number of (logical) processes,
as this will help to reduce contention. For SQL 2000 you will also need to
set the trace flag 1118 and implement hotfix 702 see
http://www.sqlsecurity.com/Tools/FreeTools/tabid/65/Default.aspx
To increase the number of files use the ALTER DATABASE command
http://msdn2.microsoft.com/en-us/library/aa275464(SQL.80).aspx
HTH
John
|||"John Bell" wrote:

> Hi
> "Jnadile" wrote:
>
> You can only have one tempdb per instance, but it is beneficial to have
> multiple files for the tempdb that match the number of (logical) processes,
Typo processes should be processors ie. CPUs!
It is also advised that if you have detected blocking on tempdb, then to
increase the number of files gradually up to the recommended number and stop
at the minumum number where it does not block.
John

How to setup Multiple tempdbs?

Hi,
We have got a huge SQL server 2000 box and we want to setup Multiple
tempdbs for a multiprocessor machine, but do not know how.
Anyone that can help please?
Thanks"Jnadile" <Jnadile@.discussions.microsoft.com> wrote in message
news:9E5C5454-8C17-4CC5-B00B-4FD7FCD08A35@.microsoft.com...
> Hi,
> We have got a huge SQL server 2000 box and we want to setup Multiple
> tempdbs for a multiprocessor machine, but do not know how.
>
You can not set up multiple tempdbs.
You can however add FILES to the existing one.
Check out the alter database command.

> Anyone that can help please?
> Thanks
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Hi
"Jnadile" wrote:

> Hi,
> We have got a huge SQL server 2000 box and we want to setup Multiple
> tempdbs for a multiprocessor machine, but do not know how.
> Anyone that can help please?
> Thanks
You can only have one tempdb per instance, but it is beneficial to have
multiple files for the tempdb that match the number of (logical) processes,
as this will help to reduce contention. For SQL 2000 you will also need to
set the trace flag 1118 and implement hotfix 702 see
http://www.sqlsecurity.com/Tools/Fr...65/Default.aspx
To increase the number of files use the ALTER DATABASE command
http://msdn2.microsoft.com/en-us/library/aa275464(SQL.80).aspx
HTH
John|||"John Bell" wrote:
[vbcol=seagreen]
> Hi
> "Jnadile" wrote:
>
> You can only have one tempdb per instance, but it is beneficial to have
> multiple files for the tempdb that match the number of (logical) processes,[/vbcol
]
Typo processes should be processors ie. CPUs!
It is also advised that if you have detected blocking on tempdb, then to
increase the number of files gradually up to the recommended number and stop
at the minumum number where it does not block.
John

How to setup front-end IIS and back-end SQL server?

Hi,

I need some help in setting up a front end IIS box and back end SQL 2005 box. I will be using merge replication.

Front end server will be a 32 bit.

How exactly do you do this? Anyone have any links to articles that walks through the setup?

Thanks,

p

Hi Pintu, see this link:

http://www.databasejournal.com/features/mssql/article.php/1438231

How to set the width on the multi-select drop down (not the simple select)?

Hi,

How can I set the width on the multi-select parameter box? I checked the post about setting the SELECT, but that affects the single parameter box, not the multi-select.

I know there is an HtmlViewer.css file and have changed the rsReportServer.config file to use it, but I don't know what the tag is to set the width on the drop down parameter list box in the htmlViewer.css file. Or is it in another file?

Any ideas?

Thanks.

pl

The width of the MVP parameter box is not configurable sorry to say.

|||

Thank you for your response.

Is there any chance that the ability to set the width for the multi-select parameter box might be included in RS 2005 SP1?

Also, I read somewhere that the solution Report Manager is a project that is available as a download for Visual Studio 2005. If I were to download the project, could I set this feature up myself?

Thanks.

|||Has this bug been addressed in SP1. Users are gobsmacked when they hear that the size of the multi box cannot be set to the width of the widest entry.|||

This behavior will not changed in SP1. From our customers we have seen this as a good recommendation for the next release and it is on the list (with many other suggestions) as a possible feature improvement.

How to set memory on server

I have SQL 2000 server with two instances installed on the
box. The server has 4 GB RAM.
(1)How can I choose SQL server memory settings to obtain
better performance for both instances?
(2)Should I choose "Dynamic" setting or "Fixed memory"
setting?
Thanks in advance.
DonActually, there is no direct answer for this. It depends
on how much memory is required for SQL Server and
applications using this sql server.
It also depends on any other applications running on the
same box.
In General, You have to allocate for OS,SQLServer and
then for other applications.
Please read this to get some idea on how SQL Server memory
works. http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adminsql/ad_config_9zfy.asp
Also , read "memory architecture" from BOL.
SQLVarad (MCDBA-1999,MCSE-1999)
>--Original Message--
>I have SQL 2000 server with two instances installed on
the
>box. The server has 4 GB RAM.
>(1)How can I choose SQL server memory settings to obtain
>better performance for both instances?
>(2)Should I choose "Dynamic" setting or "Fixed memory"
>setting?
>Thanks in advance.
>Don
>.
>|||Thanks for your good recommendation.
-Don
>--Original Message--
>Actually, there is no direct answer for this. It depends
> on how much memory is required for SQL Server and
>applications using this sql server.
>It also depends on any other applications running on the
> same box.
> In General, You have to allocate for OS,SQLServer and
>then for other applications.
> Please read this to get some idea on how SQL Server
memory
> works. http://msdn.microsoft.com/library/default.asp?
> url=/library/en-us/adminsql/ad_config_9zfy.asp
> Also , read "memory architecture" from BOL.
> SQLVarad (MCDBA-1999,MCSE-1999)
>>--Original Message--
>>I have SQL 2000 server with two instances installed on
>the
>>box. The server has 4 GB RAM.
>>(1)How can I choose SQL server memory settings to obtain
>>better performance for both instances?
>>(2)Should I choose "Dynamic" setting or "Fixed memory"
>>setting?
>>Thanks in advance.
>>Don
>>.
>.
>|||Don,
What edition of sql server are you running? If it's std edition then you
can only use 2GB (actually 1.7) per instance anyway. Unless you know for
sure that one instance always needs more than the other or you have other
apps that always require a specific amount you are probably best to leave it
dynamic. That way the two instances can give and take as needed.
--
Andrew J. Kelly
SQL Server MVP
"Don Walter" <dw_msg@.yahoo.com> wrote in message
news:078501c3a409$fa4199d0$a301280a@.phx.gbl...
> I have SQL 2000 server with two instances installed on the
> box. The server has 4 GB RAM.
> (1)How can I choose SQL server memory settings to obtain
> better performance for both instances?
> (2)Should I choose "Dynamic" setting or "Fixed memory"
> setting?
> Thanks in advance.
> Don