Gail,
I see that you said that the default 0 for worker threads should be good. What is the impact of having a process spin up several thousand worker threads? Today I was looking at the Activity Monitor and saw that there were two different processes that each had about 3,000 worker threads. This is a new system for me and I was thinking that might be bad.
We are using SQL Server 2008 R2 SP1, Enterprise 64-bit, 4 processors , 146 GB RAM
All opinions are welcomed.
Thank you.