SQL Server Performance Forum – Threads Archive

SQL Server performance practices: Max Worker Threads, don’t touch it #sql #sqlperf

When you are dealing with multi-instances and multiple databases then handling server resources is essential. By default every instance of SQL Server runs as a seperate system process, in terms of memory. In such cases each instance will need to handle concurrent requests from the applications and that instance need to start a thread on operating system is created which is then allocated to specific CPU. The distribution of threads and CPUs is managed automatically by the operating system and SQL…(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2011/05/10/10089.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=10089" width="1" height="1">

---

]]>