• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 376
  • Last Modified:

Processor settings for SQL Server 2000

I'm trying to figure out if htere are any tricks or best practices to make SQL 2000 use multiple processors in the most efficient manner? I'm looking on the Processor tab of the properties dialog box for the SQL server. The settings look straight forward enough but am wondering about, for example, what the "maximum worker threads" should be set to and why. Thanks.
0
WineGeek
Asked:
WineGeek
2 Solutions
 
adammet04Commented:
see here for some info

http://www.lazydba.com/sql/1__6791.html

and here from the horses mouth :)

http://msdn2.microsoft.com/en-us/library/ms187024.aspx

I have never had a need to change this setting but ive never had an implementation of SQL server which had a large number or concurrent connections

HTH
Ads
0
 
Hemantgiri S. GoswamiModerator - MSDN ForumsCommented:
Hi,

Refer below excerpt from BOL:

Thread pooling helps optimize performance when large numbers of clients are connected to the server. Usually, a separate operating system thread is created for each query request. However, with hundreds of connections to the server, using one thread per query request can consume large amounts of system resources. The max worker threads option enables SQL Server to create a pool of worker threads to service a larger number of query request, which improves performance.

HTH

Hemantgiri S. Goswami
MS SQL Server MVP

0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now