Worker Threads

Hi,

I'm having performance issues on my SQL2000 box.

We currently have a clustered Windows 2000 Microsoft SQL 2000 server. The
node contains 8 processors and 8GB RAM. I have limited the SQL server to use
7.6Gb but is only currently using 2.7Gb.

Current connections to the SQL box is between 1100 and 1200 and may decrease
but not necessarily increase.

The worker threads are still at the default of 255. I want to change it to
1000 but the articles from Microsoft do not give me much confidence.

Has anybody else done any changes like this before and if so, what were the
effects of this change.

Any help would be greatly appreciated so that I don't make preformance worse
than it already is.

Cheers

Shane
.

Relevant Pages

  • Re: SQL-SERVER 2005 SP2 und Microsoft Dynamics 5.0 (ehem. Navision
    ... Wert ist immer zwischen 84,7 -99,8 akt. ... es geht darum wieviel % der Daten, die der SQL Server wollte bereits in seinem Workspace waren. ... 16 GB 2 GB RAM ...
    (microsoft.public.de.sqlserver)
  • Re: WSUS
    ... Les Connor [SBS MVP] ... Is your server exhibiting significant performance problems, and if so, how ... SQL Server: ... >No wonder SBS brings servers with 4GB of RAM to their knees. ...
    (microsoft.public.windows.server.sbs)
  • Re: Seems like only 1GB RAM being used even when higher MAX RAM is
    ... It is Sql 200 enterprise, ... Both machines are equipped with 8gb of RAM. ... you said your SQL Server 2000 instance is ... If your SQL Server 2000 is Enterprise Edition and your Windows Server 2003 ...
    (microsoft.public.sqlserver.setup)
  • Re: Hardware Recommendations
    ... Well you are right in SQL being CPU/RAM intensive, but also is very IO intensive, as is Exchange. ... IIS, load up on RAM and get some good CPUS, for disk, the faster the reading the better. ... Your Domain Controllers should have good cpus, and a good amount of RAM, disks...just make sure you mirror them. ... I am asking in general what the most important components are for say an IIS server. ...
    (microsoft.public.windows.server.general)
  • Re: Von Visio nach MSSQL
    ... bei dieser die Verwendung des microsoft SQL Server-Treibers befehlen.. ... öffnet sich ein Fenster "Datenbanktreiber", ... INFORMIX OnLine/SE Server ...
    (microsoft.public.de.german.visio)