• Management Pack:  SQL Server 2005
  • MP Version:  6.1
  • Released:  8/5/2010
  • Publisher:  Microsoft

SQL User Connections Performance Monitor

  • ID:  Microsoft.SQLServer.2005.DBEngine.UserConnectionsBaselineMonitor
  • Description:  This monitor analysis the user connections to the SQL database engine over time and calculates a baseline over the initial learning period.
  • Target:  SQL Server 2005 DB Engine
  • Enabled:  No

Operational States

Name State Description
User Connections Normal Success  
User Connections Above Normal Warning  

Overridable Parameters

Parameter Name Default Value Description Override
Outer Sensitivity   Outer Sensitivity Value for the baseline envelope
Inner Sensitivity   Inner Sensitivity Value for the baseline envelope

Alert Details

Monitor State Message Priority Severity Auto Resolution
User Connections Above Normal (Warning) SQL User Connections Abnormal Medium Match Monitor Health Yes

Run As Profiles

Name
Default

Monitor Knowledgebase

Summary

This monitor analysis the user connections to the SQL database engine over time and calculates a baseline over the initial learning period. A warning or error alert will be raised if the user connections figure moves outside the baseline that has been captured.

Causes

An increase or decrease in the normal connections to the server could indicate a problem with SQL or some network infrastructure.

Resolutions

Check for other alerts from SQL Server or specific databases on the server:

SQL Alerts

Look at the key performance metrics for SQL that have been collected:

SQL Performance

External References
This monitor does not contain any external references.

See Also for SQL Server 2005 Management Pack


Downloads for SQL Server 2005 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