Browse by Tags

• best practice
• performance
• server
• setting
• sql server
• worker threads

SQL Server Max Worker Threads - What is the best value to setup?
09 November 07 06:55 AM | SQL Master | 3 Comments   

We have been going through a load-performance exercise for an application that will have more than 5000 concurrent connections at one time. Going by books and expeirence by default the Max Worker Threads setting is 255, which means that up to 255 worker Read More...

Filed under: performance, sql server, server, best practice, setting, max, worker threads