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.4.1.0 for SQL Server 2012
  • Released:  10/14/2013
  • Publisher:  Microsoft

Overview

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.
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. 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. A group containing all Windows computers running Microsoft SQL Server 2012 involved in replication Defines the basic properties of computers running Windows operating systems AlwaysOn Seed An installation of any version of Microsoft SQL Server Database Engine A group containing all components related to Microsoft SQL Server A group containing all instances of Microsoft SQL Server A group containing all instances of Microsoft SQL Server 2012 database engines It is a seed for Microsoft SQL Server 2012 installation. This object indicates that the particular server computer contains Microsoft SQL Server 2012 installation. All Microsoft SQL Server 2012 subscribers.  The subscriber is a component used in SQL Server replication. All Microsoft SQL Server 2012 replication publications. All Microsoft SQL Server 2012 publishers.  The publisher is a component used in SQL Server Replication. All Microsoft SQL Server 2012 replication subscriptions. An installation of a 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 file group Microsoft SQL Server 2012 database file Microsoft SQL Server 2012 database log file All Microsoft SQL Server 2012 distributors.  The distributor is a component used in SQL Server Replication. 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. All Microsoft SQL Server databases regardless of version

Download diagram as a Visio file

Compare with Other Versions of This Management Pack

  • 6.3.173.1 for SQL Server 2012
  • 6.4.0.0 for SQL Server 2012
  • 6.3.173.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