Solved

Do I need use Windows NT Fibers for performance ?

Posted on 2003-11-22
3
2,092 Views
Last Modified: 2012-05-04
Dear friends,
I use a DELL Server with 4 processors (1.9 MHZ), 8 GB RAM and a EMC CX200 (2T) Storage. This my main corporate (24x7) server. In general I have 1400 user conections. My SQLServer configuration uses 6GB RAM and 4GB of pagefile (maximum).  It´s dedicate SQLServer machine.

Other configurations :

Windows Advanced Server (SP 4)
SQL Server Enterprise (SP 3a)

Maximum worker Threads : 500
Boost SQL Server : No
Use Windows NT Fibers : No

Is the current values above using the best configuration ? Should I use the Windows NT Fibers ? If I have 1400 user conection is it a good idea I modify the Maximum Worker Threads parameter (maybe half : 700) ?
 

 
0
Comment
Question by:jsp_unico
  • 2
3 Comments
 
LVL 34

Expert Comment

by:arbert
ID: 9804214
For the most part, Microsoft doesn't recommend you change these options.  In fact, if you ever log a support call, the first thing they have you do is reset the values to default.

Don't ever change the "Boost SQL Server" priority setting (especially if you're on a cluster) you'll end up locking your server up because SQL Server won't yield any time to Windows.

I never could figure out why Microsoft leaves these settings available when they really don't want you to change them.  But, the options are still available in the next version as well.

Brett
0
 
LVL 34

Expert Comment

by:arbert
ID: 9804267
One other thing I forgot about, if you have NT Fiber Mode enabled, you may even find that some operations no longer work and will give cryptic failure messages (Distributed Transaction Coordinator is one function).....
0
 
LVL 9

Accepted Solution

by:
miron earned 500 total points
ID: 9807262
well, no. Unless you have poorly performing queries SQL Server concurrency will be the last thing to worry about.

--cheers.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Database ERD 4 28
backup and restore 21 29
Solar Winds can't see SQL Server Express 17 32
Problems "swapping" SQL Server DBs 2 18
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question