Do I need use Windows NT Fibers for performance ?

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) ?
 

 
jsp_unicoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

arbertCommented:
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
arbertCommented:
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
mironCommented:
well, no. Unless you have poorly performing queries SQL Server concurrency will be the last thing to worry about.

--cheers.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.