Welcome, Guest to: Public MPWiki ▼
Welcome to Management Pack Wiki! Your documentation pro for SCOM Management Packs
0 comment(s) Post a comment
  • Management Pack:  SQL Server
  • MP Version:  6.7.7.0 for SQL Server 2012
  • Released:  10/6/2016
  • Publisher:  Microsoft

Overview

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
Login
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 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 any version of Microsoft SQL Server 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 A group containing all instances of Microsoft SQL Server 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 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. 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 databases regardless of the version 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.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
  • See Also for SQL Server Management Pack


    Downloads for SQL Server Management Pack

    Post a comment
    Comments to other elements of this Management Pack:
    Article Message Posted By
    Overview
    We are providing a platform for those who want to join this profession.
    writing jobs
    jobs
    shahid.afraid111@gmail.com at 10/29/2014 11:48:42 AM
    Overview
    Is Management Pack inventory available for SQL Server 2012 MP version 6.5.1.0?
    milmanfm@gmail.com at 9/23/2014 11:36:42 AM
    Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQ
    Due to over storage of SQL database files the memory allocation refuses and creates some errors which are responsible for SQL database inaccessibility. You must go through this to learn more about resolving solutions:- http://www.sqlrecoverysoftware.net/blog/sql-error-926-and-945.html
    enriquemallon@gmail.com at 6/28/2014 10:10:17 AM
    Database consistency errors found
    I recommend you to read this article which serve you how get rid of this consistency error:- http://www.sqlrecoverysoftware.net/blog/fix-database-consistency-errors.html
    elliswhite43@gmail.com at 5/10/2014 11:06:07 AM
    Overview shantal@list.ru at 7/2/2013 11:57:28 AM
    Overview
    Where can i get the Management pack Inventory for SQL 2008
    vivakhangloo@gmail.com at 4/4/2013 8:32:16 AM
    Overview
    According to the Pinpoint catalog, the SQL MP was updated to include SQL 2012 monitoring as of 4/2/2012. Do you have an ETA for when this MPwiki entry will be updated? Keep up the great work; thanks!
    bdady@denaliai.com at 5/30/2012 2:47:22 PM
    DB File Space
    You should keep in mind that file-level monitoring works rather good now but in case of extremely loaded server (e.g. which works all the time about 99% of CPU) or you have really huge number of DBs and files (e.g. 500 databases consist of 1000-2000 files) - you should think about Database-level space monitoring.
    legolasishe@mail.ru at 3/21/2012 1:39:09 PM
    Overview shantal@list.ru at 11/4/2011 3:29:24 PM
    Overview igrudina@viacode.com at 10/26/2011 4:12:53 PM