I am getting DBSS - Worker Thread alarm for a SQLServer instance
The percentage of Worker Threads used (100.00%) is greater than the defined threshold 95.00%.
I can't find an explanation for the alarm. What does it mean?
SQL Server uses the native thread services of the Windows operating systems so that one or more threads support each network that SQL Server supports simultaneously, another thread handles database checkpoints, and a pool of threads handles all users.
Thread pooling helps optimize performance when large numbers of clients are connected to the server. Usually, a separate operating system thread is created for each query request. However, with hundreds of connections to the server, using one thread per query request can consume large amounts of system resources. The max worker threads option enables SQL Server to create a pool of worker threads to service a larger number of query request, which improves performance.
The DBSS (SQL Server) Worker Thread rule fires an alarm upon detecting that the percentage of Worker Threads used exceeds a predefined threshold.
The unit of measurement being used would be in percents with the Used Percent for five minutes over 80 percent firing a Warning alarm, and a Used Percent for five minutes over 95 percent firing a Warning alarm.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Nutzungsbedingungen Datenschutz Cookie Preference Center