• Management Pack:  SQL Server
  • MP Version:  6.7.7.0 for SQL Server 2012
  • Released:  10/6/2016
  • Publisher:  Microsoft

Classes

Name Attributes Description
Always On Seed Hosted  
Availability Group Non-Hosted  
Availability Group Health Hosted  
Availability Replica Hosted  
Database Replica Hosted This is representation of Database Replica State SMO object
Availability Group Critical Policy Hosted Custom User Policy which has Availability Group as Facet and one of the error categories as Policy Category.
Availability Group Warning Policy Hosted Custom User Policy which has Availability Group as Facet and one of the warning categories as Policy Category.
Availability Replica Critical Policy Hosted Custom User Policy which has Availability Replica as Facet and one of the error categories as Policy Category.
Availability Replica Warning Policy Hosted Custom User Policy which has Availability Replica as Facet and one of the warning categories as Policy Category.
Database Replica Critical Policy Hosted Custom User Policy which has Database Replica State as Facet and one of the error categories as Policy Category.
Database Replica Warning Policy Hosted Custom User Policy which has Database Replica State as Facet and one of the warning categories as Policy Category.
SQL Server 2012 Installation Seed Hosted It is a seed for Microsoft SQL Server 2012 installation. This object indicates that the particular server computer contains Microsoft SQL Server 2012 installation.
SQL Server 2012 DB Engine Hosted An installation of Microsoft SQL Server 2012 Database Engine. The database engine hosts databases and other SQL Server components.
SQL Server 2012 DB Hosted Microsoft SQL Server 2012 database
SQL Server 2012 Agent Hosted Microsoft SQL Server 2012 agent component
SQL Server 2012 Reporting Services Hosted An installation of Microsoft SQL Server 2012 Reporting Services
SQL Server 2012 Analysis Services Hosted An installation of Microsoft SQL Server 2012 Analysis Services
SQL Server 2012 Integration Services Hosted An installation of Microsoft SQL Server 2012 Integration Services
SQL Server 2012 Computers Non-Hosted, Singleton A group containing all Windows computers that are running a component of Microsoft SQL Server 2012.
SQL Server 2012 DB Engine Group Non-Hosted, Singleton A group containing all instances of Microsoft SQL Server 2012 database engines
SQL Server 2012 DB Filegroup Hosted Microsoft SQL Server 2012 database Filegroup
SQL Server 2012 DB File Hosted Microsoft SQL Server 2012 database file
SQL Server 2012 DB FILESTREAM Filegroup Hosted Microsoft SQL Server 2012 FILESTREAM Filegroup
SQL Server 2012 DB Log File Hosted Microsoft SQL Server 2012 database log file
[Deprecated] SQL Server 2012 Distributor Hosted 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.
[Deprecated] SQL Server 2012 Publication Hosted All Microsoft SQL Server 2012 replication publications. Considered to be obsolete in this Management Pack.
[Deprecated] SQL Server 2012 Subscription Hosted All Microsoft SQL Server 2012 replication subscriptions. Considered to be obsolete in this Management Pack.
[Deprecated] SQL Server 2012 Publisher Hosted 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.
[Deprecated] SQL Server 2012 Subscriber Hosted 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.
[Deprecated] SQL Server 2012 Replication Computers Non-Hosted, Singleton A group containing all Windows computers running Microsoft SQL Server 2012 involved in the replication. Considered to be obsolete in this Management Pack.
SQL Server 2012 Agent Job Hosted All Microsoft SQL Server 2012 agent jobs.
SQL Server Express 2012 DB Engine Group Non-Hosted, Singleton A group containing all instances of Microsoft SQL Server Express 2012 database engines.
Database Critical Policy Hosted Custom User Policy which has Database as Facet and one of the error categories as Policy Category.
Database Warning Policy Hosted Custom User Policy which has Database as Facet and one of the warning categories as Policy Category.
SQL Server 2012 WOW64 DB Engine Group Non-Hosted, Singleton A group containing all instances of Microsoft SQL Server 2012 WOW64 database engines
SQL 2012 Mirrored DB Hosted Microsoft SQL Server 2012 Mirrored Database
SQL 2012 Mirroring Witness Role Hosted Microsoft SQL Server 2012 Database Mirroring Witness Role.
SQL 2012 Mirrored DB Witness Hosted Microsoft SQL Server 2012 Mirrored Database Witness
SQL 2012 Mirroring Group Non-Hosted Microsoft SQL Server 2012 Mirroring Group
SQL 2012 Mirroring Service Non-Hosted, Singleton Microsoft SQL Server 2012 Mirroring Service
SQL Server Always On Availability Group Non-Hosted, Singleton This group contains Microsoft SQL Server Always On Availability components
SQL Server Always On Availability Replicas Group Non-Hosted, Singleton This group contains Microsoft SQL Server Always On Availability Replica components
SQL Server Always On Database Replicas Group Non-Hosted, Singleton This group contains Microsoft SQL Server Always On Database Replicas components
SQL Server Always On High Availability Group Non-Hosted, Singleton This group contains Microsoft SQL Server Always On Availability components
SSAS Instance Group Non-Hosted, Singleton This object discovery populates the SQL Server Analysis Services Group with all components that relate to Analysis Services.
Azure SQL Cloud Services Non-Hosted, Singleton A group containing Azure SQL Cloud Services
Azure SQL Database Cloud Services Non-Hosted, Singleton A group containing Azure SQL Database Cloud Services
SQL Server Computers Non-Hosted, Singleton This group contains all Windows computers that are running a component of Microsoft SQL Server
SQL Server Mirroring Components Non-Hosted, Singleton This group contains Microsoft SQL Server Mirroring components
SQL Server Mirroring Groups Non-Hosted, Singleton This group contains Microsoft SQL Server Mirroring groups
Replication Database Health Group Non-Hosted, Singleton Replication Database Health Group is group of Replication Database Health objects
Server Roles Group Non-Hosted, Singleton Server Roles Group contains all SQL Server root objects such as Database Engine, Analysis Services instance or Reporting Service instance.
SQL Server Alerts Scope Group Non-Hosted, Singleton SQL Server Alerts Scope Group contains SQL Server objects which can throw alerts.
SQL Server DB Engine Group Non-Hosted, Singleton This group containing all instances of Microsoft SQL Server database engines
SQL Server Integration Services Group Non-Hosted, Singleton This group containing all instances of Microsoft SQL Server Integration Services
SQL Server Analysis Services Alerts Scope Group Non-Hosted, Singleton SQL Server Analysis Services Alerts Scope Group contains SQL Server Analysis Services objects which can throw alerts.
Analysis Services Database Group Non-Hosted, Singleton Analysis Services Database Group contains all SQL Server root objects such as Analysis Services instance.
Analysis Services Server Roles Group Non-Hosted, Singleton Analysis Services Server Roles Group contains all SQL Server root objects such as Analysis Services instance.
SSRS: Deployment Group Non-Hosted, Singleton This object discovery populates the Local Deployment group to contain all SQL Server Reporting Services Roles.
SSRS: Instance Group Non-Hosted, Singleton This object discovery populates the Local Instance group to contain all SQL Server Reporting Services Roles.
Group of Always On High Availability Groups Non-Hosted, Singleton A group containing all Always On High Availability groups of Microsoft SQL Server 2012
Group of Availability Groups Non-Hosted, Singleton A group containing all Availability Groups of Microsoft SQL Server 2012
Group of Availability Replicas Non-Hosted, Singleton A group containing all Availability Replicas of Microsoft SQL Server 2012
Group of Database Replicas Non-Hosted, Singleton A group containing all Database Replicas of Microsoft SQL Server 2012
SQL Server Event Log Collection Target Hosted This object is used to collect errors from event log of computers that have SQL Server components.
SQL Server 2008 Instance Group Non-Hosted, Singleton A group containing all SQL Server 2008 DB Engine Instances
SQL Server 2008 Databases Group Non-Hosted, Singleton A group containing all SQL Server 2008 databases
SQL Server 2008 Agents Group Non-Hosted, Singleton A group containing all SQL Server 2008 agents
SQL Server 2008 Mirroring Groups Group Non-Hosted, Singleton A group containing all SQL Server 2008 Mirroring groups
SQL Server 2008 Integration Services Group Non-Hosted, Singleton A group containing all SQL Server 2008 Integration Services
SQL Server 2012 Instance Group Non-Hosted, Singleton A group containing all SQL Server 2012 DB Engine Instances
SQL Server 2012 Databases Group Non-Hosted, Singleton A group containing all SQL Server 2012 databases
SQL Server 2012 Agents Group Non-Hosted, Singleton A group containing all SQL Server 2012 agents
SQL Server 2012 Mirroring Groups Group Non-Hosted, Singleton A group containing all SQL Server 2012 Mirroring groups
SQL Server 2012 Integration Services Group Non-Hosted, Singleton A group containing all SQL Server 2012 Integration Services
SQL DB Engine Hosted An installation of any version of Microsoft SQL Server Database Engine
SQL Database Hosted All Microsoft SQL Server databases regardless of the version
SQL Computers Non-Hosted, Singleton A group containing all Windows computers that are running a component of Microsoft SQL Server
SQL Instances Non-Hosted, Singleton A group containing all instances of Microsoft SQL Server
SQL Components Non-Hosted, Singleton A group containing all components related to Microsoft SQL Server
SQL Server Databases Non-Hosted, Singleton SQL Server Databases
SQL Server Agents Non-Hosted, Singleton SQL Server Agents

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