• Management Pack:  SQL Server
  • MP Version:  6.3.173.1 for SQL Server 2012
  • Released:  8/20/2012
  • Publisher:  Microsoft

Discoveries

Name Enabled Target Class Description
  AlwaysOn Seed Discovery
1
 
SQL Server 2012 DB Engine This discovery is used to define which machines have AlwaysOn enabled.
  Discover Databases for a Database Engine
1
 
SQL Server 2012 DB Engine This object discovery discovers all databases running for a given instance of SQL Server 2012 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 2012 DB Engine This object discovery discovers the file group information for each SQL Server 2012 Database.
  Discover Files
1
 
SQL Server 2012 DB Engine This object discovery discovers the file information for each SQL Server 2012 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 Server 2012 DB Engine This object discovery discovers all SQL Server Replication components on a SQL Server 2012 DB Engine. The discovery is disabled by default.
  Discover SQL Server 2012 Agent Jobs
0
 
SQL Server 2012 Agent This object discovery discovers all SQL Server 2012 Agent jobs. The discovery is disabled by default.
  Discover SQL Server 2012 Analysis Services (Windows Server)
1
 
SQL Server 2012 Installation Seed This object discovery discovers all instances of SQL Server 2012 Analysis Services. By default all instances are discovered an monitored.
  Discover SQL Server 2012 Database Engines (Windows Server)
1
 
SQL Server 2012 Installation Seed This object discovery discovers all instances of SQL Server 2012 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 2012 Integration Services (Windows Server)
1
 
SQL Server 2012 Installation Seed This object discovery discovers if SQL Server 2012 Integrate Services is installed.
  Discover SQL Server 2012 Reporting Services (Windows Server) onStandardMonitoring SQL Server 2012 Installation Seed This object discovery discovers all instances of SQL Server 2012 Reporting Services. By default all instances are discovered an monitored.
  Discover SQL Server Agent for a DB Engine
1
 
SQL Server 2012 DB Engine This object discovery discovers the SQL Server Agent for an instance of SQL Server 2012 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 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
  General AlwaysOn Discovery
1
 
AlwaysOn Seed Discovery of AlwaysOn objects
  General Custom User Policy Discovery
0
 
Availability Group Health Discovery of Custom User Policies for AlwaysOn objects
  Populate Microsoft SQL Server 2012 Computer Group
1
 
SQL Server 2012 Computers This object discovery populates the SQL Server 2012 Computer Group with all computers that are running one or more components of SQL Server 2012.
  Populate Microsoft SQL Server 2012 Instance Group
1
 
SQL Server 2012 DB Engine Group This object discovery populates the SQL Server 2012 Instance Group with all SQL Server 2012 DB Engine.
  Populate Microsoft SQL Server 2012 Replication Computers Group
1
 
SQL Server 2012 Replication Computers This object discovery populates the SQL Server 2012 Replication Component computer group with all computers that are running an instance of SQL Server 2012 DB Engine and have some replication component configured.
  SQL Server 2012 Database Custom User Policy Discovery
0
 
SQL Server 2012 DB Engine Discovery of Custom User Policies for SQL Server 2012 Database
  SQL Server 2012 DB Installation Discovery Source
1
 
Windows Server This object discovery discovers 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 Replication Publications and Subscriptions Discovery Provider
0
 
SQL Server 2012 DB Engine This object discovery discovers replication publications and subscriptions for each SQL Server 2012 database. The discovery is disabled by default.

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