• Management Pack:  SQL Server
  • MP Version:  6.1 for SQL Server 2008
  • Released:  8/5/2010
  • Publisher:  Microsoft

Discoveries

Name Enabled Target Class Description
  Discover Databases for a Database Engine
1
 
SQL 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 2008 DB Engine This object discovery discovers the file group groupinformation for each SQL Server 2008 Database.
  Discover Files
1
 
SQL 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 Replication Components
0
 
SQL 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 2008 Agent Jobs
0
 
SQL 2008 Agent This object discovery discovers all SQL Server 2008 Agent jobs. The discovery is disabled by default.
  Discover SQL 2008 Analysis Services (Windows Server)
1
 
Windows Server This object discovery discovers all instances of SQL Server 2008 Analysis Services. By default, all instances are discovered an monitored.
  Discover SQL 2008 Database Engines (Windows Server)
1
 
Windows Server 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 2008 Integration Services (Windows Server)
1
 
Windows Server This object discovery discovers if SQL Server 2008 Integrate Services is installed.
  Discover SQL 2008 Reporting Services (Windows Server) onStandardMonitoring Windows Server This object discovery discovers all instances of SQL Server 2008 Reporting Services. By default all instances are discovered an monitored.
  Discover SQL Agent for a DB Engine
1
 
SQL 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 agent instance for each DB Engine instance.
  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 2008 DB Engine This is a system discovery which should not be modified.
  Populate Microsoft SQL Server 2008 Computer Group
1
 
SQL 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 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 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
1
 
SQL 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.
  SQL 2008 Replication Publications and Subscriptions Discovery Provider
0
 
SQL 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