Search

Thursday, July 28, 2011

check worker threads

To see what you are using at the moment you can run:

dbcc sqlperf(umsstats)

This will answer that question. If you reach max value ( the default value is 250) this will be logged in the application.

No comments:

Post a Comment