Why the “Toilet” Analogy for SQL might be bad
- by Jonathan Kehayias
Robert Davis(blog/twitter) recently blogged The Toilet Analogy … or Why I Never Recommend Increasing Worker Threads , in which he uses an analogy for why increasing the value for the ‘max worker threads’ sp_configure option can be bad inside of SQL Server. While I can’t make an argument against Robert’s assertion that increasing worker…