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.6.2.0 for SQL Server 2008
  • Released:  10/15/2015
  • Publisher:  Microsoft

Classes

Name Attributes Description
SQL Server 2008 Installation Seed Hosted It is a seed for Microsoft SQL Server 2008 installation. This object indicates that the particular server computer contains Microsoft SQL Server 2008 installation.
SQL Server 2008 DB Engine Hosted An installation of a Microsoft SQL Server 2008 Database Engine. The database engine hosts databases and other SQL Server components.
SQL Server 2008 DB Hosted Microsoft SQL Server 2008 database
SQL Server 2008 Agent Hosted Microsoft SQL Server 2008 agent component
SQL Server 2008 Reporting Services Hosted An installation of Microsoft SQL Server 2008 Reporting Services
SQL Server 2008 Analysis Services Hosted An installation of Microsoft SQL Server 2008 Analysis Services
SQL Server 2008 Integration Services Hosted An installation of Microsoft SQL Server 2008 Integration Services
SQL Server 2008 Computers Non-Hosted, Singleton A group containing all Windows computers that are running a component of Microsoft SQL Server 2008.
SQL Server 2008 DB Engine Group Non-Hosted, Singleton A group containing all instances of Microsoft SQL Server 2008 database engines
SQL Server 2008 R2 DB Engine Group Non-Hosted, Singleton A group containing all instances of Microsoft SQL Server 2008 R2 database engines
SQL Server 2008 DB File Group Hosted Microsoft SQL Server 2008 database file group
SQL Server 2008 DB File Hosted Microsoft SQL Server 2008 database file
SQL Server 2008 DB Log File Hosted Microsoft SQL Server 2008 database log file
SQL Server 2008 Distributor Hosted All Microsoft SQL Server 2008 distributors. The distributor is a component used in SQL Server Replication.
SQL Server 2008 Publication Hosted All Microsoft SQL Server 2008 replication publications.
SQL Server 2008 Subscription Hosted All Microsoft SQL Server 2008 replication subscriptions.
SQL Server 2008 Publisher Hosted All Microsoft SQL Server 2008 publishers. The publisher is a component used in SQL Server Replication.
SQL Server 2008 Subscriber Hosted All Microsoft SQL Server 2008 subscribers. The subscriber is a component used in SQL Server replication.
SQL Server 2008 Replication Computers Non-Hosted, Singleton A group containing all Windows computers running Microsoft SQL Server 2008 involved in replication
SQL Server 2008 Agent Job Hosted All Microsoft SQL Server 2008 agent jobs.
SQL 2008 Mirrored DB Hosted Microsoft SQL Server 2008 Mirrored Database
SQL 2008 Mirroring Witness Role Hosted Microsoft SQL Server 2008 Database Mirroring Witness Role.
SQL 2008 Mirrored DB Witness Hosted Microsoft SQL Server 2008 Mirrored Database Witness
SQL 2008 Mirroring Group Non-Hosted Microsoft SQL Server 2008 Mirroring Group
SQL 2008 Mirroring Service Non-Hosted, Singleton Microsoft SQL Server 2008 Mirroring Service
SQL Server AlwaysOn Availability Group Non-Hosted, Singleton This group contains Microsoft SQL Server AlwaysOn Availability components
SQL Server AlwaysOn Availability Replicas Group Non-Hosted, Singleton This group contains Microsoft SQL Server AlwaysOn Availability Replica components
SQL Server AlwaysOn Database Replicas Group Non-Hosted, Singleton This group contains Microsoft SQL Server AlwaysOn Database Replicas components
SQL Server AlwaysOn High Availability Group Non-Hosted, Singleton This group contains Microsoft SQL Server AlwaysOn Availability components
SSAS Components Group Non-Hosted, Singleton This object discovery populates the SQL Server Analysis Services Group with all components that relate to Analysis 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 Availability Groups Non-Hosted, Singleton A group containing all AlwaysOnHightAvailability
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 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 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

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