The SQL Server Management Pack provides the capabilities for Operations Manager 2007 SP1, 2007 R2 and 2012 to discover SQL Server 2005. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents.
|
6.3.173.1 for SQL Server 2012
|
8/20/2012 |
6.7.7.0 for SQL Server 2012
6.6.2.0 for SQL Server 2012
6.4.0.0 for SQL Server 2012
6.4.1.0 for SQL Server 2012
6.3.173.0 for SQL Server 2012
6.7.20.0 for SQL Server 2012
|
The Monitoring pack for SQL Server provides the capabilities for Operations Manager 2007 R2 and Operations Manager 2012 to discover SQL Server 2005, 2008, 2008 R2, and SQL Server 2012. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents.
The monitoring provided by this management pack includes performance, availability, and configuration monitoring, performance data collection, and default thresholds. You can integrate the monitoring of SQL Server components into your service-oriented monitoring scenarios.
In addition to health monitoring capabilities, this management pack includes dashboard views, diagram views and extensive knowledge with embedded inline tasks, and views that enable near real-time diagnosis and resolution of detected issues. |
|
6.6.0.0 for SQL Server 2005
|
6/29/2015 |
6.3.173.0 for SQL Server 2005
6.6.2.0 for SQL Server 2005
6.1 for SQL Server 2005
6.3.173.1 for SQL Server 2005
|
The following list gives an overview of the features of the SQL Server management pack. Refer to the SQL Server management pack guide for more details.
New features and fixes:
Dashboards were replaced with the new ones
Components of replication functionality are deprecated and disabled by default
SPN monitor now correctly handles disjoined namespaces
Added support for filegroups containing filestreams and partition schemes
Memory Consumption monitor has been fixed
Upgradeability from 6.4.1.0 version is supported
Added CPU Usage monitor and rule for SQL Server 2005
Added ConsecutiveSamples Condition to the Buffer Cache Hit Ratio and Page Life Expectancy monitors
AlwaysOn discovery was reworked
Minor fixes. |
|
6.6.2.0 for SQL Server 2008
|
10/15/2015 |
6.3.173.1 for SQL Server 2008
6.7.20.0 for SQL Server 2008
6.3.173.0 for SQL Server 2008
6.1 for SQL Server 2008
6.6.0.0 for SQL Server 2008
6.7.7.0 for SQL Server 2008
|
Feature Summary:
The following list gives an overview of SQL Server management pack features. Refer to SQL Server management pack guide for more details.
New features and fixes:
Added a support for disabled TCP/IP protocol
Fixed performance metrics error that may occur on some localized versions of Windows
Fixed bugs in monitor tiles on SQL Server Summary Dashboard
Fixed incorrect performance of Transaction log free space monitor
Added new type of events from failed discoveries; added a new rule that collects such events
Added overrides to prevent various scripts timeout failure
Removed some 1X1 tiles from Summary Dashboards
Filestream filegroups are excluded from discovery for now
2008/2012 Summary Dashboards tiles were reorganized
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 Replication Monitoring (applicable to SQL Server 2008 version of management pack only)
Approximately twenty rules to detect replication events.
Support for Mirroring Monitoring (applicable to SQL Server 2008 and 2012 versions of management pack only)
Discover mirroring databases, witness, and mirroring group.
Monitor database mirror state, database mirror witness state, and mirroring partners’ state.
Custom diagram view to represent the primary and the mirrored databases visually.
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 details regarding the 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 such areas as database free space, SQL Server related performance, SQL Server related alerts, and lists of the various SQL Server roles, and the discovered components along with 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 Microsoft Generic Report Library can be used against the roles and components discovered by 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 need to leave the Operations Console in most cases.
Databases monitoring 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 |
|
6.6.0.0 for SQL Server 2012
|
6/29/2015 |
6.7.7.0 for SQL Server 2012
6.6.2.0 for SQL Server 2012
6.7.20.0 for SQL Server 2012
|
The following list gives an overview of the features of the SQL Server management pack. Refer to the SQL Server management pack guide for more details.
New features and fixes:
Dashboards were replaced with the new ones
Components of replication functionality are deprecated and disabled by default
SPN monitor now correctly handles disjoined namespaces
Added support for filegroups containing filestreams and partition schemes
Memory Consumption monitor has been fixed
Upgradeability from 6.4.1.0 version is supported
Added CPU Usage monitor and rule for SQL Server 2005
Added ConsecutiveSamples Condition to the Buffer Cache Hit Ratio and Page Life Expectancy monitors
AlwaysOn discovery was reworked
Minor fixes. |
|
6.3.173.1 for SQL Server 2008
|
8/20/2012 |
6.6.2.0 for SQL Server 2008
6.7.20.0 for SQL Server 2008
6.3.173.0 for SQL Server 2008
6.1 for SQL Server 2008
6.4.1.0 for SQL Server 2008
6.6.0.0 for SQL Server 2008
6.7.7.0 for SQL Server 2008
6.4.0.0 for SQL Server 2008
|
The Monitoring pack for SQL Server provides the capabilities for Operations Manager 2007 R2 and Operations Manager 2012 to discover SQL Server 2005, 2008, 2008 R2, and SQL Server 2012. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents.
The monitoring provided by this management pack includes performance, availability, and configuration monitoring, performance data collection, and default thresholds. You can integrate the monitoring of SQL Server components into your service-oriented monitoring scenarios.
In addition to health monitoring capabilities, this management pack includes dashboard views, diagram views and extensive knowledge with embedded inline tasks, and views that enable near real-time diagnosis and resolution of detected issues. |
|
6.3.173.0 for SQL Server 2005
|
4/2/2012 |
6.6.0.0 for SQL Server 2005
6.6.2.0 for SQL Server 2005
6.1 for SQL Server 2005
6.4.0.0 for SQL Server 2005
6.3.173.1 for SQL Server 2005
6.4.1.0 for SQL Server 2005
|
SQL Server 2005 management pack |
|
6.7.20.0 for SQL Server 2008
|
3/14/2017 |
6.6.2.0 for SQL Server 2008
6.3.173.1 for SQL Server 2008
6.3.173.0 for SQL Server 2008
6.1 for SQL Server 2008
6.6.0.0 for SQL Server 2008
6.7.7.0 for SQL Server 2008
|
Feature Summary
The following list gives an overview of SQL Server management pack features. Refer to SQL Server management pack guide for more details.
Discovery and monitoring of SQL Server 2008, 2008 R2 and 2012 roles like DB Engine, Integrations Services.
Discovery of SQL Server 2008, 2008 R2 and 2012 components: Databases, SQL Agent and SQL jobs.
Monitoring of SQL Server 2012 Always On:
Automatic discovery and monitoring of availability groups, availability replicas, and availability databases.
Health roll-up from availability database to availability replicas.
Detailed knowledge for each related monitoring workflow.
Seamless integration with SQL Server policy based management (PBM):
Automatic discovery and monitoring of custom PBM polices targeted to Database or Database components.
Rollup of policy execution health to the health of related SCOM entity.
Low-privilege monitoring is supported for both stand-alone installations and clustered environments, except PBM.
Support of Mirroring Monitoring for SQL Server 2008, 2008 R2 and 2012
Discover mirroring databases, witness, and mirroring group.
Monitor database mirror state, database mirror witness state, and mirroring partners’ state.
Custom diagram view to represent the primary and the mirrored databases visually. |
|
6.3.173.0 for SQL Server 2008
|
4/2/2012 |
6.6.2.0 for SQL Server 2008
6.3.173.1 for SQL Server 2008
6.7.20.0 for SQL Server 2008
6.1 for SQL Server 2008
6.4.1.0 for SQL Server 2008
6.6.0.0 for SQL Server 2008
6.7.7.0 for SQL Server 2008
6.4.0.0 for SQL Server 2008
|
SQL Server 2008 management pack |
|
6.1 for SQL Server 2008
|
8/5/2010 |
6.6.2.0 for SQL Server 2008
6.3.173.1 for SQL Server 2008
6.7.20.0 for SQL Server 2008
6.3.173.0 for SQL Server 2008
6.4.1.0 for SQL Server 2008
6.6.0.0 for SQL Server 2008
6.7.7.0 for SQL Server 2008
6.4.0.0 for SQL Server 2008
|
SQL Server 2008 management pack |
|
6.4.1.0 for SQL Server 2008
|
10/14/2013 |
6.3.173.1 for SQL Server 2008
6.3.173.0 for SQL Server 2008
6.1 for SQL Server 2008
6.4.0.0 for SQL Server 2008
|
The Management pack for SQL Server provides the capabilities for Operations Manager 2007 R2 and Operations Manager 2012 to discover SQL Server 2005, 2008, 2008 R2, and SQL Server 2012. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents.
The monitoring provided by this management pack includes performance, availability, and configuration monitoring, performance data collection, and default thresholds. You can integrate the monitoring of SQL Server components into your service-oriented monitoring scenarios.
In addition to health monitoring capabilities, this management pack includes dashboard views, diagram views and extensive knowledge with embedded inline tasks, and views that enable near real-time diagnosis and resolution of detected issues. |
|
6.7.7.0 for SQL Server 2012
|
10/6/2016 |
6.3.173.1 for SQL Server 2012
6.6.0.0 for SQL Server 2012
6.6.2.0 for SQL Server 2012
6.3.173.0 for SQL Server 2012
6.7.20.0 for SQL Server 2012
|
Feature Summary
The following list gives an overview of SQL Server management pack features. Refer to SQL Server management pack guide for more details.
•Discovery and monitoring of SQL Server 2008, 2008 R2 and 2012 roles like DB Engine, Integrations Services.
•Discovery of SQL Server 2008, 2008 R2 and 2012 components: Databases, SQL Agent and SQL jobs.
•Monitoring of SQL Server 2012 Always On:
•Automatic discovery and monitoring of availability groups, availability replicas, and availability databases.
•Health roll-up from availability database to availability replicas.
•Detailed knowledge for each related monitoring workflow.
•Seamless integration with SQL Server policy based management (PBM): •Automatic discovery and monitoring of custom PBM polices targeted to Database or Database components.
•Rollup of policy execution health to the health of related SCOM entity.
•Low-privilege monitoring is supported for both stand-alone installations and clustered environments, except PBM.
•Support of Mirroring Monitoring for SQL Server 2008, 2008 R2 and 2012
• Discover mirroring databases, witness, and mirroring group.
• Monitor database mirror state, database mirror witness state, and mirroring partners’ state.
• Custom diagram view to represent the primary and the mirrored databases visually.
New Features and Fixes •Added support for configurations where computer host names are longer than 15 symbols
•Added "Event ID" to descriptions of all the alerts generated by the alerting rules
•Added support for databases stored on SMB Shares
•Updated the visualization library
•Removed files of SQL 2005 MP from the installer since this MP is no longer supported
•Added 2 rules for alerts generating when there are problems with execution of the monitoring workflows scripts on the following agents: "MSSQL: Monitoring failed" and "MSSQL: Monitoring warning"
•Added "MSSQL 20XX: Discovery warning" rules to generate alerts when there are non-critical problems with execution of the discovery scripts (warning events in the Operations Manager log)
•Changed "MSSQL 20XX: Discovery failed" rules to generate alerts for only critical errors during executing discovery scripts
•Improved error logging in the MP scripts
•Fixed issue: SQL Server 2012 Always On discoveries fail after stopping WSFC service
•Fixed issue: "Set DB offline" task does not work when the database is in Availability Group
•Fixed issue: user policy discovery script fails with "Invalid namespace "ROOT\Microsoft\SqlServer\ComputerManagement12" error
•Fixed issue: Always On console task does not work
•Deprecated "Run As Account does not exist on the target system, or does not have enough permissions" rule
•Fixed some issues in the scripts, which could lead to unstable work with WMI
•Fixed error logging in a script for Blocking Sessions monitor
•Fixed issue: CPU Usage monitor and rule did not work for SQL Server cluster instance
•Fixed issue: connection to an SQL Server instance was not closing when the destination was wrong
•Fixed Non-Readable Replica detection (Always On)
•Made detection condition stricter for DB User Policy event-based discovery: added management group name
•Made detection condition stricter for Script Failed alerting rule: added management group name
|
|
6.6.2.0 for SQL Server 2005
|
10/15/2015 |
6.6.0.0 for SQL Server 2005
6.3.173.0 for SQL Server 2005
6.1 for SQL Server 2005
6.3.173.1 for SQL Server 2005
|
Feature Summary:
The following list gives an overview of SQL Server management pack features. Refer to SQL Server management pack guide for more details.
New features and fixes:
Added a support for disabled TCP/IP protocol
Fixed performance metrics error that may occur on some localized versions of Windows
Fixed bugs in monitor tiles on SQL Server Summary Dashboard
Fixed incorrect performance of Transaction log free space monitor
Added new type of events from failed discoveries; added a new rule that collects such events
Added overrides to prevent various scripts timeout failure
Removed some 1X1 tiles from Summary Dashboards
Filestream filegroups are excluded from discovery for now
2008/2012 Summary Dashboards tiles were reorganized
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 Replication Monitoring (applicable to SQL Server 2008 version of management pack only)
Approximately twenty rules to detect replication events.
Support for Mirroring Monitoring (applicable to SQL Server 2008 and 2012 versions of management pack only)
Discover mirroring databases, witness, and mirroring group.
Monitor database mirror state, database mirror witness state, and mirroring partners’ state.
Custom diagram view to represent the primary and the mirrored databases visually.
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 details regarding the 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 such areas as database free space, SQL Server related performance, SQL Server related alerts, and lists of the various SQL Server roles, and the discovered components along with 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 Microsoft Generic Report Library can be used against the roles and components discovered by 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 need to leave the Operations Console in most cases.
Databases monitoring 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 |
|
6.1 for SQL Server 2005
|
8/5/2010 |
6.6.0.0 for SQL Server 2005
6.3.173.0 for SQL Server 2005
6.6.2.0 for SQL Server 2005
6.4.0.0 for SQL Server 2005
6.3.173.1 for SQL Server 2005
6.4.1.0 for SQL Server 2005
|
SQL Server 2005 management pack |
|
6.6.0.0 for SQL Server 2008
|
6/29/2015 |
6.6.2.0 for SQL Server 2008
6.3.173.1 for SQL Server 2008
6.7.20.0 for SQL Server 2008
6.3.173.0 for SQL Server 2008
6.1 for SQL Server 2008
6.7.7.0 for SQL Server 2008
|
The following list gives an overview of the features of the SQL Server management pack. Refer to the SQL Server management pack guide for more details.
New features and fixes:
Dashboards were replaced with the new ones
Components of replication functionality are deprecated and disabled by default
SPN monitor now correctly handles disjoined namespaces
Added support for filegroups containing filestreams and partition schemes
Memory Consumption monitor has been fixed
Upgradeability from 6.4.1.0 version is supported
Added CPU Usage monitor and rule for SQL Server 2005
Added ConsecutiveSamples Condition to the Buffer Cache Hit Ratio and Page Life Expectancy monitors
AlwaysOn discovery was reworked
Minor fixes. |
|
6.6.2.0 for SQL Server 2012
|
10/15/2015 |
6.3.173.1 for SQL Server 2012
6.6.0.0 for SQL Server 2012
6.7.7.0 for SQL Server 2012
6.3.173.0 for SQL Server 2012
6.7.20.0 for SQL Server 2012
|
Feature Summary:
The following list gives an overview of SQL Server management pack features. Refer to SQL Server management pack guide for more details.
New features and fixes:
Added a support for disabled TCP/IP protocol
Fixed performance metrics error that may occur on some localized versions of Windows
Fixed bugs in monitor tiles on SQL Server Summary Dashboard
Fixed incorrect performance of Transaction log free space monitor
Added new type of events from failed discoveries; added a new rule that collects such events
Added overrides to prevent various scripts timeout failure
Removed some 1X1 tiles from Summary Dashboards
Filestream filegroups are excluded from discovery for now
2008/2012 Summary Dashboards tiles were reorganized
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 Replication Monitoring (applicable to SQL Server 2008 version of management pack only)
Approximately twenty rules to detect replication events.
Support for Mirroring Monitoring (applicable to SQL Server 2008 and 2012 versions of management pack only)
Discover mirroring databases, witness, and mirroring group.
Monitor database mirror state, database mirror witness state, and mirroring partners’ state.
Custom diagram view to represent the primary and the mirrored databases visually.
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 details regarding the 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 such areas as database free space, SQL Server related performance, SQL Server related alerts, and lists of the various SQL Server roles, and the discovered components along with 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 Microsoft Generic Report Library can be used against the roles and components discovered by 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 need to leave the Operations Console in most cases.
Databases monitoring 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 |
|
6.4.0.0 for SQL Server 2012
|
9/10/2013 |
6.3.173.1 for SQL Server 2012
6.4.1.0 for SQL Server 2012
6.3.173.0 for SQL Server 2012
|
The Management Pack for SQL Server provides the capabilities for Operations Manager 2007 R2 and Operations Manager 2012 to discover SQL Server 2005, 2008, 2008 R2, and SQL Server 2012. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents. |
|
6.4.1.0 for SQL Server 2012
|
10/14/2013 |
6.3.173.1 for SQL Server 2012
6.4.0.0 for SQL Server 2012
6.3.173.0 for SQL Server 2012
|
The Management pack for SQL Server provides the capabilities for Operations Manager 2007 R2 and Operations Manager 2012 to discover SQL Server 2005, 2008, 2008 R2, and SQL Server 2012. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents.
The monitoring provided by this management pack includes performance, availability, and configuration monitoring, performance data collection, and default thresholds. You can integrate the monitoring of SQL Server components into your service-oriented monitoring scenarios.
In addition to health monitoring capabilities, this management pack includes dashboard views, diagram views and extensive knowledge with embedded inline tasks, and views that enable near real-time diagnosis and resolution of detected issues. |
|
6.4.0.0 for SQL Server 2005
|
9/10/2013 |
6.3.173.0 for SQL Server 2005
6.1 for SQL Server 2005
6.3.173.1 for SQL Server 2005
6.4.1.0 for SQL Server 2005
|
The Management Pack for SQL Server provides the capabilities for Operations Manager 2007 R2 and Operations Manager 2012 to discover SQL Server 2005, 2008, 2008 R2, and SQL Server 2012. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents. |
|
6.3.173.1 for SQL Server 2005
|
8/20/2012 |
6.6.0.0 for SQL Server 2005
6.3.173.0 for SQL Server 2005
6.6.2.0 for SQL Server 2005
6.1 for SQL Server 2005
6.4.0.0 for SQL Server 2005
6.4.1.0 for SQL Server 2005
|
The Monitoring pack for SQL Server provides the capabilities for Operations Manager 2007 R2 and Operations Manager 2012 to discover SQL Server 2005, 2008, 2008 R2, and SQL Server 2012. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents.
The monitoring provided by this management pack includes performance, availability, and configuration monitoring, performance data collection, and default thresholds. You can integrate the monitoring of SQL Server components into your service-oriented monitoring scenarios.
In addition to health monitoring capabilities, this management pack includes dashboard views, diagram views and extensive knowledge with embedded inline tasks, and views that enable near real-time diagnosis and resolution of detected issues. |
|
6.4.1.0 for SQL Server 2005
|
10/14/2013 |
6.3.173.0 for SQL Server 2005
6.1 for SQL Server 2005
6.4.0.0 for SQL Server 2005
6.3.173.1 for SQL Server 2005
|
The Management pack for SQL Server provides the capabilities for Operations Manager 2007 R2 and Operations Manager 2012 to discover SQL Server 2005, 2008, 2008 R2, and SQL Server 2012. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents.
The monitoring provided by this management pack includes performance, availability, and configuration monitoring, performance data collection, and default thresholds. You can integrate the monitoring of SQL Server components into your service-oriented monitoring scenarios.
In addition to health monitoring capabilities, this management pack includes dashboard views, diagram views and extensive knowledge with embedded inline tasks, and views that enable near real-time diagnosis and resolution of detected issues. |
|
6.7.7.0 for SQL Server 2008
|
10/6/2016 |
6.6.2.0 for SQL Server 2008
6.3.173.1 for SQL Server 2008
6.7.20.0 for SQL Server 2008
6.3.173.0 for SQL Server 2008
6.1 for SQL Server 2008
6.6.0.0 for SQL Server 2008
|
Feature Summary
The following list gives an overview of SQL Server management pack features. Refer to SQL Server management pack guide for more details.
•Discovery and monitoring of SQL Server 2008, 2008 R2 and 2012 roles like DB Engine, Integrations Services.
•Discovery of SQL Server 2008, 2008 R2 and 2012 components: Databases, SQL Agent and SQL jobs.
•Monitoring of SQL Server 2012 Always On:
•Automatic discovery and monitoring of availability groups, availability replicas, and availability databases.
•Health roll-up from availability database to availability replicas.
•Detailed knowledge for each related monitoring workflow.
•Seamless integration with SQL Server policy based management (PBM): •Automatic discovery and monitoring of custom PBM polices targeted to Database or Database components.
•Rollup of policy execution health to the health of related SCOM entity.
•Low-privilege monitoring is supported for both stand-alone installations and clustered environments, except PBM.
•Support of Mirroring Monitoring for SQL Server 2008, 2008 R2 and 2012
• Discover mirroring databases, witness, and mirroring group.
• Monitor database mirror state, database mirror witness state, and mirroring partners’ state.
• Custom diagram view to represent the primary and the mirrored databases visually.
New Features and Fixes •Added support for configurations where computer host names are longer than 15 symbols
•Added "Event ID" to descriptions of all the alerts generated by the alerting rules
•Added support for databases stored on SMB Shares
•Updated the visualization library
•Removed files of SQL 2005 MP from the installer since this MP is no longer supported
•Added 2 rules for alerts generating when there are problems with execution of the monitoring workflows scripts on the following agents: "MSSQL: Monitoring failed" and "MSSQL: Monitoring warning"
•Added "MSSQL 20XX: Discovery warning" rules to generate alerts when there are non-critical problems with execution of the discovery scripts (warning events in the Operations Manager log)
•Changed "MSSQL 20XX: Discovery failed" rules to generate alerts for only critical errors during executing discovery scripts
•Improved error logging in the MP scripts
•Fixed issue: SQL Server 2012 Always On discoveries fail after stopping WSFC service
•Fixed issue: "Set DB offline" task does not work when the database is in Availability Group
•Fixed issue: user policy discovery script fails with "Invalid namespace "ROOT\Microsoft\SqlServer\ComputerManagement12" error
•Fixed issue: Always On console task does not work
•Deprecated "Run As Account does not exist on the target system, or does not have enough permissions" rule
•Fixed some issues in the scripts, which could lead to unstable work with WMI
•Fixed error logging in a script for Blocking Sessions monitor
•Fixed issue: CPU Usage monitor and rule did not work for SQL Server cluster instance
•Fixed issue: connection to an SQL Server instance was not closing when the destination was wrong
•Fixed Non-Readable Replica detection (Always On)
•Made detection condition stricter for DB User Policy event-based discovery: added management group name
•Made detection condition stricter for Script Failed alerting rule: added management group name
|
|
6.3.173.0 for SQL Server 2012
|
4/2/2012 |
6.3.173.1 for SQL Server 2012
6.7.7.0 for SQL Server 2012
6.6.2.0 for SQL Server 2012
6.4.0.0 for SQL Server 2012
6.4.1.0 for SQL Server 2012
6.7.20.0 for SQL Server 2012
|
SQL Server 2012 management pack |
|
6.4.0.0 for SQL Server 2008
|
9/10/2013 |
6.3.173.1 for SQL Server 2008
6.3.173.0 for SQL Server 2008
6.1 for SQL Server 2008
6.4.1.0 for SQL Server 2008
|
The Management Pack for SQL Server provides the capabilities for Operations Manager 2007 R2 and Operations Manager 2012 to discover SQL Server 2005, 2008, 2008 R2, and SQL Server 2012. It monitors SQL Server components such as database engine instances, databases, and SQL Server agents. |
|
6.7.20.0 for SQL Server 2012
|
3/14/2017 |
6.3.173.1 for SQL Server 2012
6.6.0.0 for SQL Server 2012
6.7.7.0 for SQL Server 2012
6.6.2.0 for SQL Server 2012
6.3.173.0 for SQL Server 2012
|
Feature Summary
The following list gives an overview of SQL Server management pack features. Refer to SQL Server management pack guide for more details.
Discovery and monitoring of SQL Server 2008, 2008 R2 and 2012 roles like DB Engine, Integrations Services.
Discovery of SQL Server 2008, 2008 R2 and 2012 components: Databases, SQL Agent and SQL jobs.
Monitoring of SQL Server 2012 Always On:
Automatic discovery and monitoring of availability groups, availability replicas, and availability databases.
Health roll-up from availability database to availability replicas.
Detailed knowledge for each related monitoring workflow.
Seamless integration with SQL Server policy based management (PBM):
Automatic discovery and monitoring of custom PBM polices targeted to Database or Database components.
Rollup of policy execution health to the health of related SCOM entity.
Low-privilege monitoring is supported for both stand-alone installations and clustered environments, except PBM.
Support of Mirroring Monitoring for SQL Server 2008, 2008 R2 and 2012
Discover mirroring databases, witness, and mirroring group.
Monitor database mirror state, database mirror witness state, and mirroring partners’ state.
Custom diagram view to represent the primary and the mirrored databases visually. |