I am helping troubleshoot some problems on a SQL Server box. An application that used to run without problem is now failing with connection pool errors, and no changes have been made to the application that could cause this new problem.
In investigating possible causes of the connection pool error, I came across this post, which gave the "max worker thread" setting as a possible cause. I checked the production server, and this setting was 54 (it was 89 in dev and 79 in QA).
- Is there any way of seeing a log/history of when this setting was changed?
- Is there any reason to have the setting this low (this MSDN article recommends a minimum setting of 256 for 32-bit processors, 512 for 64-bit)?
- Does the low setting generally seem odd, since someone would have had to consciously set it?