SQL Server Performance

If MAX WORKER THREADS increased from 255 to 500 what will be the usage or availability of system resources on the server?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Nov 15, 2007.

  1. Anonymous New Member

    Continuing on the MAX WORKER THREADS topic from ThisBlog I have been asked about method of calculating the amount of system resources that will be used when the setting is increased to 500 from 255 (default). Well, as one of the best practices you must test the implications and usage in hiking such a value that will affect the whole server system, not specific to SQL Server though. Practically I wouldn't see much issues if the SQL Server is a dedicated server in this case, if not you should perform...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2007/11/15/2716.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=2716" width="1" height="1">

Share This Page