mountainss Cloud and Datacenter Management Blog

Microsoft SystemCenter blogsite about virtualization on-premises and Cloud

UPDATE System Center Management Pack for SQL Server 2014 #SCOM #SQL2014 #sysctr #SQL

Leave a comment


Instance SummaryInstance Summary Dashboard.

The System Center Management Pack for SQL Server 2014 enables the discovery and monitoring of SQL Server 2014 Database Engines, Databases, SQL Server Agents and other related components. This Management Pack is designed to run by Operations Manager 2007 R2 (except dashboards), Operations Manager 2012 or Operations Manager 2012 R2.

The monitoring provided by this management pack includes performance, availability, and configuration monitoring, as well as performance and events data collection. All monitoring workflows have predefined thresholds and complimentary knowledge base articles. You can integrate the monitoring of SQL Server 2014 components into your service-oriented monitoring scenarios.

In addition to health monitoring capabilities, this management pack includes dashboards, diagram views, state views, performance views, alert views and diagnostic tasks that enable near real-time diagnostics and remediation of detected issues.

Note: This management pack does not depend on SQL Server Library management pack. You do not need to import it to enable the monitoring of SQL Server 2014.
Note: This management pack is only for SQL Server 2014. Please use this link to download the Operations Manager Management Pack for SQL Server 2005/2008/2012.

Feature Summary
The following list gives an overview of features introduced by System Center Operations Manager Management Pack for SQL Server 2014. Please refer to the SQL Server 2014 Management Pack Guide for more details.

  • Discovery and monitoring of SQL Server 2014 roles like DB Engine, Integrations Services.
  • Discovery of SQL Server 2014 components: Databases, SQL Agent and SQL jobs.
  • The management pack introduces 100+ monitors and 380+ rules to provide a deep monitoring of SQL Server 2014. Please refer to the SQL Server 2014 Management Pack Guide for the full list of monitoring scenarios and workflow inventory.
  • Monitoring of SQL Server 2014 AlwaysOn:
    • 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 2014 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.
  • Monitoring of SQL Server In-Memory OLTP.
  • Reports for long-term analysis of different problematic areas related to SQL Server 2014, such as SQL Server lock analysis, top deadlocked databases, SQL Server service pack levels, user connection activity. Also, generic reports from the Microsoft Generic Report Library can be used to review availability and performance of objects discovered by System Center Operations Manager Management Pack for SQL Server 2014.
  • Low-privilege monitoring is supported for both stand-alone installations and clustered environments, except PBM.
  • Support for Mirroring Monitoring
    • 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.

New features

  • Added Mirroring monitoring scenarios for SQL Server 2014 product
  • SPN monitor now has ‘search scope’ parameter which allows the end user to choose between LDAP and Global Catalog
  • Fixed Timeout error in CPU utilization monitoring scenario
  • Monitoring SQL Server Instances on the same server with their own network interfaces and default port is now available
  • SQL Server instances with underscores and other allowed special symbols in names can be monitored
  • Minor fixes.

Improvements:

  • Dependency on SQL Server Library management pack has been eliminated.
  • Support of Localized performance counter for CPU and Logical Disk Metrics.
  • SQL Server Integration Services monitoring seed discovery.
  • SQL Server Integration Services moved to separate management pack.
  • SQL Server non-default port is now supported.
  • Optimized performance collection replaced with raw performance collection to guarantee accuracy of hourly and daily aggregated data.

Fixes:

  • Standard Edition Databases discovery issue fixed.
  • AlwaysOn: Endpoint URL points to a non-computer name.
  • AlwaysOn: read intent is not supported, false alert message removed.

Other changes:

  • Monitoring of SQL Server Reporting Services has been deprecated. This component will be monitored by dedicated management pack.
  • Monitoring of SQL Server Analysis Services has been deprecated. This component will be monitored by dedicated management pack.
  • Monitoring of SQL Server Replication has been deprecated. This component will be monitored by dedicated management pack.

You can download the Microsoft System Center Management Pack for SQL Server 2014 here

Advertisements

Author: James van den Berg

I'm Microsoft Architect and ICT Specialist and Microsoft MVP System Center Cloud and Datacenter Management

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s