SQL CODE BANK
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment