• Management Pack:  SQL Server 2012
  • MP Version:  7.0.4.0
  • Released:  4/18/2018
  • Publisher:  Microsoft

Overview

Management pack for SQL Server provides the capabilities for Operations Manager 2007 R2, Operations Manager 2012 SP1, Operations Manager 2012 R2 and Operations Manager 2016 to discover 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, along with 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. Note: If you are going to localize this management pack, keep in mind that localization installers on this page do not include files for localizing SQL Server Dashboards. Please use this link to download the required localization for Dashboards. 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 2012 roles like DB Engine, Integrations Services. Discovery of SQL Server 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 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.
Login
This object represents Availability Database object. A hidden object, which is used to roll up the health from agents to availability database level. Availability Group Availability Group Health Availability Replica This is representation of Database Replica State SMO object Custom User Policy which has Availability Group as Facet and one of the error categories as Policy Category. Custom User Policy which has Availability Group as Facet and one of the warning categories as Policy Category. Custom User Policy which has Availability Replica as Facet and one of the error categories as Policy Category. Custom User Policy which has Availability Replica as Facet and one of the warning categories as Policy Category. Custom User Policy which has Database Replica State as Facet and one of the error categories as Policy Category. Custom User Policy which has Database Replica State as Facet and one of the warning categories as Policy Category. This group contains Microsoft SQL Server Always On Availability components This group contains Microsoft SQL Server Always On Availability Replica components This group contains Microsoft SQL Server Always On Database Replicas components A group containing all Windows computers that are running a component of Microsoft SQL Server 2008, 2008 R2 or 2012. A group containing all Windows computers that are running a component of Microsoft SQL Server 2012. This group contains all Windows computers that are running a component of Microsoft SQL Server A group containing all Windows computers running Microsoft SQL Server 2012 involved in the replication. Considered to be obsolete in this Management Pack. Defines the basic properties of computers running Windows operating systems Always On Seed An installation of Microsoft SQL Server 2008, 2008 R2 or 2012 Database Engine. Analysis Services Database Group contains all SQL Server root objects such as Analysis Services instance. Analysis Services Server Roles Group contains all SQL Server root objects such as Analysis Services instance. A group containing Azure SQL Cloud Services A group containing Azure SQL Database Cloud Services A group containing all Always On High Availability groups of Microsoft SQL Server 2012 Replication Database Health Group is group of Replication Database Health objects Server Roles Group contains all SQL Server root objects such as Database Engine, Analysis Services instance or Reporting Service instance. Microsoft SQL Server 2012 Mirroring Service A group containing all components related to Microsoft SQL Server 2008, 2008 R2 or 2012. A group containing all instances of Microsoft SQL Server 2008, 2008 R2 or 2012. A group containing all SQL Server 2008 agents A group containing all SQL Server 2008 databases A group containing all SQL Server 2008 DB Engine Instances A group containing all SQL Server 2008 Integration Services A group containing all SQL Server 2008 Mirroring groups A group containing all SQL Server 2012 agents A group containing all SQL Server 2012 databases A group containing all instances of Microsoft SQL Server 2012 database engines A group containing Microsoft SQL Server 2012 DB Engines With Many DBs A group containing all SQL Server 2012 DB Engine Instances A group containing all SQL Server 2012 Integration Services A group containing all SQL Server 2012 Mirroring groups A group containing all instances of Microsoft SQL Server 2012 WOW64 database engines SQL Server Agents. SQL Server Alerts Scope Group contains SQL Server objects which can throw alerts. This object is used to collect alerts. This group contains Microsoft SQL Server Always On Availability components SQL Server Analysis Services Alerts Scope Group contains SQL Server Analysis Services objects which can throw alerts. SQL Server Databases. This group containing all instances of Microsoft SQL Server database engines A group containing all instances of Microsoft SQL Server Express 2012 database engines. This group containing all instances of Microsoft SQL Server Integration Services This group contains Microsoft SQL Server Mirroring components This group contains Microsoft SQL Server Mirroring groups This object discovery populates the SQL Server Analysis Services Group with all components that relate to Analysis Services. This object discovery populates the Local Deployment group to contain all SQL Server Reporting Services Roles. This object discovery populates the Local Instance group to contain all SQL Server Reporting Services Roles. It is a seed for Microsoft SQL Server 2012 installation. This object indicates that the particular server computer contains Microsoft SQL Server 2012 installation. This object is used to collect errors from event log of computers that have SQL Server components. All Microsoft SQL Server 2012 subscribers. The subscriber is a component used in SQL Server Replication; it is considered to be obsolete in this Management Pack. A group containing a part of databases of a particular Microsoft SQL Server 2012 DB engine All Microsoft SQL Server 2012 replication publications. Considered to be obsolete in this Management Pack. All Microsoft SQL Server 2012 publishers. The publisher is a component used in SQL Server Replication; it is considered to be obsolete in this Management Pack. All Microsoft SQL Server 2012 replication subscriptions. Considered to be obsolete in this Management Pack. An installation of Microsoft SQL Server 2012 Database Engine. The database engine hosts databases and other SQL Server components. Microsoft SQL Server 2012 database Microsoft SQL Server 2012 agent component An installation of Microsoft SQL Server 2012 Reporting Services An installation of Microsoft SQL Server 2012 Analysis Services An installation of Microsoft SQL Server 2012 Integration Services Microsoft SQL Server 2012 database Filegroup Microsoft SQL Server 2012 database file Microsoft SQL Server 2012 FILESTREAM Filegroup Microsoft SQL Server 2012 database log file All Microsoft SQL Server 2012 distributors. The distributor is a component used in SQL Server Replication; it is considered to be obsolete in this Management Pack. All Microsoft SQL Server 2012 agent jobs. Custom User Policy which has Database as Facet and one of the error categories as Policy Category. Custom User Policy which has Database as Facet and one of the warning categories as Policy Category. A group containing all Availability Groups of Microsoft SQL Server 2012 A group containing all Availability Replicas of Microsoft SQL Server 2012 A group containing all Database Replicas of Microsoft SQL Server 2012 All Microsoft SQL Server 2008, 2008 R2, and 2012 databases. Microsoft SQL Server 2012 Mirrored Database Microsoft SQL Server 2012 Database Mirroring Witness Role. Microsoft SQL Server 2012 Mirrored Database Witness Microsoft SQL Server 2012 Mirroring Group

Download diagram as a Visio file

Compare with Other Versions of This Management Pack

  • 6.6.0.0
  • 6.7.20.0
  • 6.6.2.0
  • 6.7.7.0
  • 7.0.0.0
  • 7.0.2.0

    • See Also for SQL Server 2012 Management Pack


    Downloads for SQL Server 2012 Management Pack

    Back to top
    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