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

Discoveries

Name Enabled Target Class Description
  Alerts Scope Group Discovery
1
 
SQL Server Alerts Scope Group This object discovery populates the Alerts Scope group to contain all SQL Server Roles.
  Discover Database Mirroring direction
1
 
SQL 2008 Mirroring Group This object discovery discovers SQL Server 2008 Database Mirroring direction.
  Discover Databases for a Database Engine
1
 
SQL Server 2008 DB Engine This object discovery discovers all databases running for a given instance of SQL Server 2008 DB Engine. By default all databases are discovered and monitored. You can override the discovery to exclude one or more databases from being discovered using the Exclude List. This list takes a comma-separated list of database names or the * character to exclude all databases.
  Discover File Groups
1
 
SQL Server 2008 DB Engine This object discovery discovers the file group information for each SQL Server 2008 Database.
  Discover Files
1
 
SQL Server 2008 DB Engine This object discovery discovers the file information for each SQL Server 2008 Database. The discovery is disabled by default and should be enabled for specific databases or DB Engine instances where deeper file monitoring is required.
  Discover Mirrored Databases for a Database Engine
1
 
SQL Server 2008 DB Engine This object discovery discovers all mirrored databases running for a given instance of SQL Server 2008 DB Engine. By default all mirrored databases are discovered and monitored. You can override the discovery to exclude one or more databases from being discovered using the Exclude List. This list takes a comma-separated list of database names or the * character to exclude all databases.
  Discover Mirrored Databases Witnesses
1
 
SQL Server 2008 DB Engine This object discovery discovers all mirrored databases witnesses running for a given instance of SQL Server 2008 DB Engine. By default witnesses for all mirrored databases are discovered and monitored. You can override the discovery to exclude one or more databases from being discovered using the Exclude List. This list takes a comma-separated list of database names or the * character to exclude all databases.
  Discover Replication Components
0
 
SQL Server 2008 DB Engine This object discovery discovers all SQL Server Replication components on a SQL Server 2008 DB Engine. The discovery is disabled by default.
  Discover SQL Server 2008 Agent Jobs
0
 
SQL Server 2008 Agent This object discovery discovers all SQL Server 2008 Agent jobs. The discovery is disabled by default.
  Discover SQL Server 2008 Analysis Services (Windows Server)
0
 
SQL Server 2008 Installation Seed This object discovery discovers all instances of SQL Server 2008 Analysis Services. By default all instances are discovered an monitored.
  Discover SQL Server 2008 Database Engines (Windows Server)
1
 
SQL Server 2008 Installation Seed This object discovery discovers all instances of SQL Server 2008 DB Engine running on Windows Servers. By default all instances are discovered and monitored. You can override the discovery to exclude one or more instances from being discovered using the Exclude List. This list takes a comma-separated list of instance names or the * character to exclude all instances.
  Discover SQL Server 2008 Integration Services (Windows Server)
1
 
SQL Server 2008 Installation Seed This object discovery discovers if SQL Server 2008 Integrate Services is installed.
  Discover SQL Server 2008 Mirroring Service
1
 
SQL 2008 Mirroring Service This object discovery populates Microsoft SQL Server 2008 Mirroring Service with Mirroring Groups.
  Discover SQL Server 2008 Reporting Services (Windows Server)
0
 
SQL Server 2008 Installation Seed This object discovery discovers all instances of SQL Server 2008 Reporting Services. By default all instances are discovered an monitored.
  Discover SQL Server Agent for a DB Engine
1
 
SQL Server 2008 DB Engine This object discovery discovers the SQL Server Agent for an instance of SQL Server 2008 DB Engine. There will always be one SQL Server Agent instance for each DB Engine instance.
  Discover SQL Server Components Group membership
1
 
SQL Components Populates the Components group with all SQL Server related components
  Discover SQL Server Computer Group membership
1
 
SQL Server Computers Populates the computer group to contains all computers running SQL Server.
  Discover SQL Server Computer Group membership
1
 
SQL Computers Populates the computer group to contains all computers running SQL Server
  Discover SQL Server Instance Group membership
1
 
SQL Instances Populates the Instance group to contains all SQL Server DBEngines
  License Discovery for Microsoft SQL Server
1
 
SQL Server 2008 DB Engine This is a system discovery which should not be modified.
  MSSQL : SQL Server AlwaysOn High Availability Group Discovery
1
 
SQL Server AlwaysOn High Availability Group This object discovery populates the AlwaysOn High Availability Group to contain all SQL Server AlwaysOn Availability groups.
  MSSQL 2008: Mirroring Common Group Discovery
1
 
SQL Server Mirroring Components This object discovery populates the Mirroring Common group to contain all SQL Server Mirroring components.
  MSSQL 2008: Mirroring Group Discovery
1
 
SQL Server Mirroring Groups This object discovery populates the Mirroring Group to contain all SQL Server Mirroring groups.
  MSSQL 2008: Populate SQL Server 2008 Databases Group
1
 
SQL Server 2008 Databases Group This discovery rule populates the SQL Server 2008 Databases group with all SQL Server 2008 databases.
  MSSQL 2008: Populate SQL Server 2008 Instance Group
1
 
SQL Server 2008 Instance Group This discovery rule populates the SQL Server 2008 Instance group with all SQL Server 2008 DBEngines.
  MSSQL 2008: Populate SQL Server 2008 Instance Group
1
 
SQL Server 2008 Agents Group This discovery rule populates the SQL Server 2008 Agents group with all SQL Server 2008 agents.
  MSSQL 2008: Populate SQL Server 2008 Integration Services Group
1
 
SQL Server 2008 Integration Services Group This discovery rule populates the SQL Server 2008 Integration Services Group with all SQL Server 2008 Integration Services.
  MSSQL 2008: Populate SQL Server 2008 Mirroring Groups Group
1
 
SQL Server 2008 Mirroring Groups Group This discovery rule populates the SQL Server 2008 Mirroring Groups Group group with all SQL Server 2008 Mirroring Groups.
  MSSQL: Populate SQL Server Agent Group
1
 
SQL Server Agents This discovery rule populates the Agent group with all SQL Server Agents.
  MSSQL: Populate SQL Server Database Group
1
 
SQL Server Databases This discovery rule populates the Database group with all SQL Server Databases.
  MSSQL: Populate SQL Server Instance Group
1
 
SQL Server DB Engine Group This discovery rule populates the Instance group with all SQL Server DBEngines.
  MSSQL: Populate SQL Server Instance Group
1
 
SQL Server Integration Services Group This discovery rule populates the Instance group with all SQL Server Integration Services.
  Populate Microsoft SQL Server 2008 Computer Group
1
 
SQL Server 2008 Computers This object discovery populates the SQL Server 2008 Computer Group with all computers that are running one or more components of SQL Server 2008.
  Populate Microsoft SQL Server 2008 Instance Group
1
 
SQL Server 2008 DB Engine Group This object discovery populates the SQL Server 2008 Instance Group with all SQL Server 2008 DB Engine.
  Populate Microsoft SQL Server 2008 R2 Instance Group
1
 
SQL Server 2008 R2 DB Engine Group This object discovery populates the SQL Server 2008 R2 Instance Group with all SQL Server 2008 R2 DB Engine.
  Populate Microsoft SQL Server 2008 Replication Computers Group
0
 
SQL Server 2008 Replication Computers This object discovery populates the SQL Server 2008 Replication Component computer group with all computers that are running an instance of SQL Server 2008 DB Engine and have some replication component configured.
  Server Roles Group Discovery
1
 
Server Roles Group This object discovery populates the Server Roles group to contain all SQL Server Roles.
  SQL Server 2008 DB Installation Discovery Source
1
 
Windows Server This object discovery discovers 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 Replication Publications and Subscriptions Discovery Provider
0
 
SQL Server 2008 DB Engine This object discovery discovers replication publications and subscriptions for each SQL Server 2008 database. The discovery is disabled by default.

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