Wednesday, July 1, 2015

[OpsMgr 2007 R2] [OpsMgr 2012] Microsoft System Center Management Pack for SQL Server #SQL #OpsMgr


We just have in place the last version of the SQL Monitoring in our productions environment and Microsoft has released a new one. New version is now 6.6.0.0 and please find here the different link on the Microsoft site.  

 
 



- 'SQL Server 2005 2008 2012'  Version: '6.6.0.0'  Released on: '12-15-2014'
- 'SQL Server 2014'  Version: '6.6.0.0'  Released on: '12-15-2014'
- 'SQL Server 2008 Reporting Services (Native Mode)'  Version: '6.6.0.0'  Released on: '11-4-2014'
- 'SQL Server 2012 Reporting Services (Native Mode)'  Version: '6.6.0.0'  Released on: '11-4-2014'
- 'SQL Server 2012 Analysis Services'  Version: '6.6.0.0'  Released on: '11-4-2014'
- 'SQL Server 2008 Analysis Services'  Version: '6.6.0.0'  Released on: '11-4-2014'
- 'SQL Server 2014 Reporting Services (Native Mode)'  Version: '6.6.0.0'  Released on: '11-4-2014'
- 'SQL Server 2014 Analysis Services'  Version: '6.6.0.0'  Released on: '11-4-2014'

 
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.

Important Prerequisite Notes:
Clusters: In order to ensure that all monitoring works correctly for clustered instances of SQL Server ensure that your OpsMgr agents on the physical nodes of the cluster are running either OpsMgr 2007 R2 or OpsMgr 2007 SP1 with the most recent cumulative update for OpsMgr 2007 SP1 applied or OpsMgr 2012. 

Changes in June 2015 Update of the SQL 2005,2008,2012 and 2014 Management pack

SQL Server Management Pack version 6.6.0.0 includes the following changes:
·         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.


For more information, read the détails on the different Microsoft download pages.
 

This posting is provided "AS IS" with no warranties.