• Management Pack:  SQL Server
  • MP Version:  6.6.0.0 for SQL Server 2012
  • Released:  6/29/2015
  • Publisher:  Microsoft

Overview

The following list gives an overview of the features of the SQL Server management pack. Refer to the SQL Server management pack guide for more details. New features and fixes: 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.
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 2012. 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 AlwaysOn Seed Microsoft SQL Server 2012 Mirroring Service A group containing all instances of Microsoft SQL Server 2012 database engines A group containing all instances of Microsoft SQL Server 2012 WOW64 database engines A group containing all instances of Microsoft SQL Server Express 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; it is considered to be obsolete in this Management Pack. Microsoft SQL Server 2012 FILESTREAM Filegroup 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 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 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.7.7.0 for SQL Server 2012
  • 6.6.2.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

    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