SQL Server

The Management Pack for SQL Server provides the capabilities for Operations Manager to discover SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017+. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents.
Read More...

Important Prerequisite Notes:

Feature Summary:

New features and fixes:

New dashboards (instance level and database level) for both SQL 2008 and SQL 2012.
Integration with Microsoft SQL Server Presentation Management Pack, the folder and views structure has been updated.
Support of localized performance counters (CPU and Disk metrics) has been added.
Monitors have been updated to use consecutive samples instead of average sample value.
Removed SQL Default Action Run AS from Write Actions.
None-Default port is supported
New property - Server Role Type
Performance collection rules have been updated to use none-optimized performance collection to improve the accuracy of daily and hourly-aggregated data.
AllwaysOn Read-Intent error fixed, Read-Intent Monitoring is not supported.
Performance counter object name changed for a number of rules.
Discoveries have been disabled for Analysis Services and Reporting Services.
Icons updated for a number of classes.

Features:

Monitors and Rules – only for SQL 2008 and SQL 2012

Collect DB Active Connections count
Collect DB Active Requests count
Collect DB Active Sessions count
Collect DB Active Transactions count
Collect DB Engine Thread count
Thread Count monitor
Transaction Log Free Space (%) monitor
Transaction Log Free Space (%) collection
Collect DB Engine CPU Utilization (%)
CPU Utilization (%) monitor for DB engine
Buffer Cache Hit Ratio monitor
Collect DB Engine Page Life Expectancy (s)
Page Life Expectancy monitor
Collect DB Disk Read Latency (ms)
Collect DB Disk Write Latency (ms)
Disk Read Latency monitor
Disk Write Latency monitor
Collect DB Transactions per second count
Collect DB Engine Average Wait Time (ms)
Average Wait Time monitor
Collect DB Engine Stolen Server Memory (MB)
Stolen Server Memory monitor
Collect DB Allocated Free Space (MB)
Collect DB Used Space (MB)
Collect DB Disk Free Space (MB)
SQL Re-Compilation monitor

Run As configuration changes to support Low privilege for SQL Server 2012 Cluster
AlwaysOn Monitoring

Automatically discover and monitor availability groups, availability replicas, and availability databases for hundreds of computers.
Health roll-up from availability database to availability replicas.
Detailed knowledge with every critical health state to enable faster resolution to a problem.

Seamless integration with Policy based management (PBM)

Auto-discover custom PBM polices targeting AlwaysOn and database components.
Rollup of health of policy execution within the SQL monitoring pack under extended health.

Support for Mirroring and Replication Monitoring (only applicable to SQL Server 2008 and 2008 R2 version of management pack)

Discover mirroring databases, witness, and mirroring group.
Monitor database mirror state, database mirror witness state, and mirroring partners’ state.
Custom diagram view to visually represent the primary and the mirrored databases.
Approximately twenty rules to detect replication events.

Improved Freespace monitoring with mount point support
Support for Enterprise, Standard and Express editions of SQL Server 2005, 2008, 2008 R2, and 2012 and 32bit, 64bit and ia64 architectures.
Support for both simple and complex SQL Server configurations such as clustered installations, multiple instances and 32bit roles running on a 64bit OS. For full details on supported configurations refer to the guide included with the management pack.
Discovery and monitoring of SQL Server roles such as DB Engine, Reporting Services, Analysis Services, Integrations Services.
Discovery of SQL Server components such as databases, the SQL Agent and SQL jobs.
Views covering areas such as database free space, SQL Server related performance, SQL Server related alerts, and lists of the various SQL Server roles and components which are discovered and their related state.
Discovery and basic monitoring for SQL Server Reporting Services and Integration Services.
Reports for longer-term analysis of common problem areas related to SQL Server such as SQL Server lock analysis and top deadlocked databases, SQL Server service pack levels across discovered roles, user connection activity. Likewise the generic reports from the Microsoft Generic Report Library can be used against the roles and components discovered by the SQL MPs to review availability and performance across many systems and over longer periods of time.
Role and component specific tasks which provide access to common tools, triage information, or corrective actions without needing to leave the Operations Console in most cases.
Monitoring of databases covers database status, database free space, log shipping monitoring for both the source and destination, and transaction log free space.
Monitoring of key SQL Server related services.
Monitoring for persistent SPID blocking.
Monitoring of numerous SQL Server events and performance data points. Alerts bring the issue to your attention and provide knowledge on the impact and possible resolutions.
A low-privilege configuration for discovery and monitoring that eliminates the need for SQL Server sysadmin, dbo, db_owner, and box admin privileges

Management Packs

Management Pack	Version
Microsoft.SQLServer.2000.Discovery	6.0.6648.0
Microsoft.SQLServer.2000.Monitoring	6.0.6648.0
Microsoft.SQLServer.2005.Discovery	6.7.2.0
Microsoft.SQLServer.2005.Monitoring	6.7.2.0
Microsoft.SQLServer.2008.Discovery	7.0.15.0
Microsoft.SQLServer.2008.Mirroring.Discovery	7.0.15.0
Microsoft.SQLServer.2008.Mirroring.Monitoring	7.0.15.0
Microsoft.SQLServer.2008.Monitoring	7.0.15.0
Microsoft.SQLServer.2008.Presentation	7.0.15.0
Microsoft.SQLServer.2012.AlwaysOn.Discovery	7.0.15.0
Microsoft.SQLServer.2012.AlwaysOn.Monitoring	7.0.15.0
Microsoft.SQLServer.2012.Discovery	7.0.15.0
Microsoft.SQLServer.2012.Mirroring.Discovery	7.0.15.0
Microsoft.SQLServer.2012.Mirroring.Monitoring	7.0.15.0
Microsoft.SQLServer.2012.Monitoring	7.0.15.0
Microsoft.SQLServer.2012.Presentation	7.0.15.0
Microsoft.SQLServer.2014.AlwaysOn.Discovery	7.0.15.0
Microsoft.SQLServer.2014.AlwaysOn.Monitoring	7.0.15.0
Microsoft.SQLServer.2014.AlwaysOn.Views	7.0.15.0
Microsoft.SQLServer.2014.Discovery	7.0.15.0
Microsoft.SQLServer.2014.IntegrationServices.Discovery	7.0.15.0
Microsoft.SQLServer.2014.IntegrationServices.Monitoring	7.0.15.0
Microsoft.SQLServer.2014.IntegrationServices.Views	7.0.15.0
Microsoft.SQLServer.2014.Mirroring.Discovery	7.0.15.0
Microsoft.SQLServer.2014.Mirroring.Monitoring	7.0.15.0
Microsoft.SQLServer.2014.Mirroring.Views	7.0.15.0
Microsoft.SQLServer.2014.Monitoring	7.0.15.0
Microsoft.SQLServer.2014.Presentation	7.0.15.0
Microsoft.SQLServer.2014.Views	7.0.15.0
Microsoft.SQLServer.2016.AlwaysOn.Discovery	7.0.15.0
Microsoft.SQLServer.2016.AlwaysOn.Monitoring	7.0.15.0
Microsoft.SQLServer.2016.AlwaysOn.Views	7.0.15.0
Microsoft.SQLServer.2016.Discovery	7.0.15.0
Microsoft.SQLServer.2016.IntegrationServices.Discovery	7.0.15.0
Microsoft.SQLServer.2016.IntegrationServices.Monitoring	7.0.15.0
Microsoft.SQLServer.2016.IntegrationServices.Views	7.0.15.0
Microsoft.SQLServer.2016.Mirroring.Discovery	7.0.15.0
Microsoft.SQLServer.2016.Mirroring.Monitoring	7.0.15.0
Microsoft.SQLServer.2016.Mirroring.Views	7.0.15.0
Microsoft.SQLServer.2016.Monitoring	7.0.15.0
Microsoft.SQLServer.2016.Presentation	7.0.15.0
Microsoft.SQLServer.2016.Views	7.0.15.0
Microsoft.SQLServer.2017.AlwaysOn.Library	6.7.60.0
Microsoft.SQLServer.2017.AlwaysOn.Library.Views	6.7.60.0
Microsoft.SQLServer.2017.AlwaysOn.Linux.Discovery	6.7.60.0
Microsoft.SQLServer.2017.AlwaysOn.Linux.Monitoring	6.7.60.0
Microsoft.SQLServer.2017.AlwaysOn.Linux.Views	6.7.60.0
Microsoft.SQLServer.2017.AlwaysOn.Windows.Discovery	6.7.60.0
Microsoft.SQLServer.2017.AlwaysOn.Windows.Monitoring	6.7.60.0
Microsoft.SQLServer.2017.AlwaysOn.Windows.Views	6.7.60.0
Microsoft.SQLServer.2017.Library	6.7.60.0
Microsoft.SQLServer.2017.Library.Dashboards	6.7.60.0
Microsoft.SQLServer.2017.Library.Views	6.7.60.0
Microsoft.SQLServer.2017.Linux.Dashboards	6.7.60.0
Microsoft.SQLServer.2017.Linux.Discovery	6.7.60.0
Microsoft.SQLServer.2017.Linux.Monitoring	6.7.60.0
Microsoft.SQLServer.2017.Linux.Views	6.7.60.0
Microsoft.SQLServer.2017.Windows.Dashboards	6.7.60.0
Microsoft.SQLServer.2017.Windows.Discovery	6.7.60.0
Microsoft.SQLServer.2017.Windows.Monitoring	6.7.60.0
Microsoft.SQLServer.2017.Windows.Views	6.7.60.0
Microsoft.SQLServer.Core.CustomMonitoring	7.0.42.0
Microsoft.SQLServer.Core.Library	7.0.42.0
Microsoft.SQLServer.Core.Views	7.0.42.0
Microsoft.SQLServer.Core.WebDashboards	7.0.42.0
Microsoft.SQLServer.Generic.Dashboards	7.0.15.0
Microsoft.SQLServer.Generic.Presentation	7.0.15.0
Microsoft.SQLServer.IS.Windows	7.0.42.0
Microsoft.SQLServer.IS.Windows.Views	7.0.42.0
Microsoft.SQLServer.Library	7.0.15.0
Microsoft.SQLServer.Linux.Discovery	7.0.42.0
Microsoft.SQLServer.Linux.Monitoring	7.0.42.0
Microsoft.SQLServer.Linux.Views	7.0.42.0
Microsoft.SQLServer.Visualization.Library	7.0.42.0
Microsoft.SQLServer.Windows.Discovery	7.0.42.0
Microsoft.SQLServer.Windows.Monitoring	7.0.42.0
Microsoft.SQLServer.Windows.Views	7.0.42.0

Elements

TypeDefinitions

EntityTypes

ModuleTypes

Categories

Category (167)

Monitoring

Templates

Template (3)

PresentationTypes

Presentation

Resources

Reporting