• Management Pack:  SQL Server 2008
  • MP Version:  7.0.4.0
  • Released:  4/18/2018
  • Publisher:  Microsoft

Thread Count Monitor

  • ID:  Microsoft.SQLServer.2008.DBEngine.ThreadCountMonitor
  • Description:  Thread Count for 2008 DB Engine
  • Target:  SQL Server 2008 DB Engine
  • Enabled:  Yes

Operational States

Name State Description
DB Engine Thread Count is ok Success DB Engine Thread Count is ok
DB Engine Thread Count is too high Error DB Engine Thread Count is too high

Overridable Parameters

Parameter Name Default Value Description Override
Interval (seconds) 300 The recurring interval of time in seconds in which to run the workflow.
Timeout (seconds) 200 Specifies the time the workflow is allowed to run before being closed and marked as failed.
Minimum Free Threads Count 10 Data Source determine a threshold and thread count for each DB Engine process, alert will be generated if threshold minus current thread count is less or equal than free thread count
Number of samples 6 Number of samples to average before compare it with threshold
Synchronization Time   The synchronization time specified by using a 24-hour format. May be omitted.
Cache Expiration Time 43200 Specifies the maximum age of information from cache the workflow can use. May be omitted.

Alert Details

Monitor State Message Priority Severity Auto Resolution
DB Engine Thread Count is too high (Error) SQL DB 2008 Engine Thread Count is too high Medium Critical Yes

Run As Profiles

Name
Default

Monitor Knowledgebase

Summary

Usually SQL Server opens system thread for each query request, but if amount of threads exceeds specified max worker threads value, SQL Server pools the worker threads. When all worker threads are active with long running queries, SQL Server may appear unresponsive until a worker thread completes and becomes available. Though not a defect, this can sometimes be undesirable. The monitor analyzes amount of free threads and notifies if the amount is low.

Causes

An increase in the amount of work causing an increase in utilized threads, this could indicate that SQL Server is working under significant load or an excessive number of queries running in parallel.

Resolutions

Adjusting max worker threads is an advanced option and should be changed only by an experienced database administrator or certified SQL Server technician.

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 requests, which improves performance.

Max worker threads Option

http://go.microsoft.com/fwlink/?LinkId=789164

External References
This monitor does not contain any external references.

See Also for SQL Server 2008 Management Pack


Downloads for SQL Server 2008 Management Pack

AZURE OPTIMIZATION ASSESSMENT GET STARTED
MIGRATION TO AZURE GET STARTED
SYSTEM CENTER MIGRATION TO AZURE GET STARTED
MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED