.png)
Objects the Management Pack Discovers
Updated: August 2, 2010
Applies To: Operations Manager 2007, Operations Manager 2007 R2, SQL Server
You can use the SQL Server Management Pack to monitor components of SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2. You can use the Authoring pane of the Operations console to enable discovery of components that are not automatically discovered. For more information about enabling object discovery, see Object Discoveries in Operations Manager 2007 in Operations Manager 2007 Help.
 Note |
|---|
| You can use the same procedure to override the settings for discovery of any object. |
The SQL Server Management Pack discovers the object types described in the following table. Not all of the objects are automatically discovered. Use overrides to discover those that are not discovered automatically.
| Category | Object type | Discovered Automatically |
|---|---|---|
|
SQL Server Roles |
SQL Server 2008 R2 DB Engine |
Yes |
|
SQL Server Roles |
SQL Server 2008 DB Engine |
Yes |
|
SQL Server Roles |
SQL Server 2005 DB Engine |
Yes |
|
SQL Server Roles |
SQL Server 2008 R2 Analysis Services |
Yes |
|
SQL Server Roles |
SQL Server 2008 Analysis Services |
Yes |
|
SQL Server Roles |
SQL Server 2005 Analysis Services |
Yes |
|
SQL Server Roles |
SQL Server 2008 R2 Reporting Services |
Yes |
|
SQL Server Roles |
SQL Server 2008 Reporting Services |
Yes |
|
SQL Server Roles |
SQL Server 2005 Reporting Services |
Yes |
|
SQL Server Roles |
SQL Server 2008 R2 Integration Services |
Yes |
|
SQL Server Roles |
SQL Server 2008 Integration Services |
Yes |
|
SQL Server Roles |
SQL Server 2005 Integration Services |
Yes |
|
Replication Components |
SQL Server 2008 R2 Distributor |
No |
|
Replication Components |
SQL Server 2008 Distributor |
No |
|
Replication Components |
SQL Server 2005 Distributor |
No |
|
Replication Components |
SQL Server 2008 R2 Publisher |
No |
|
Replication Components |
SQL Server 2008 Publisher |
No |
|
Replication Components |
SQL Server 2005 Publisher |
No |
|
Replication Components |
SQL Server 2008 R2 Subscriber |
No |
|
Replication Components |
SQL Server 2008 Subscriber |
No |
|
Replication Components |
SQL Server 2005 Subscriber |
No |
|
Replication Components |
SQL Server 2008 R2 Subscription |
No |
|
Replication Components |
SQL Server 2008 Subscription |
No |
|
Replication Components |
SQL Server 2005 Subscription |
No |
|
Other Object Types |
SQL Server 2008 R2 DB |
Yes |
|
Other Object Types |
SQL Server 2008 DB |
Yes |
|
Other Object Types |
SQL Server 2005 DB |
Yes |
|
Other Object Types |
SQL Server 2008 R2 Agent |
Yes |
|
Other Object Types |
SQL Server 2008 Agent |
Yes |
|
Other Object Types |
SQL Server 2005 Agent |
Yes |
|
Other Object Types |
SQL Server 2008 R2 Agent Job |
No |
|
Other Object Types |
SQL Server 2008 Agent Job |
No |
|
Other Object Types |
SQL Server 2005 Agent Job |
No |
|
Other Object Types |
SQL Server 2008 R2 DB File Group |
Yes |
|
Other Object Types |
SQL Server 2008 DB File Group |
Yes |
|
Other Object Types |
SQL Server 2005 DB File Group |
Yes |
|
Other Object Types |
SQL Server 2008 R2 DB File |
Yes |
|
Other Object Types |
SQL Server 2008 DB File |
Yes |
|
Other Object Types |
SQL Server 2005 DB File |
Yes |
Objects Discovered
Use the following procedures as an example of enabling automatic discovery for SQL Server 2005 Agent Job.
To use an override to change the setting for automatic discovery
-
In the Authoring pane, expand Management Pack Objects, and then click Object Discoveries.
-
On the Operations Manager toolbar, click Scope, and then filter the objects that appear in the details pane to include only SQL Server objects.
-
In the Operations Manager toolbar, use the Scope button to filter the list of objects, and then click SQL Server Agent Job.
-
On the Operations Manager toolbar, click Overrides, click Override the Object Discovery, and then click For all objects of type: SQL 2005 Agent, For a group.
-
In the Override Properties dialog box, click the Override box for the Enabled parameter.
-
Under Management Pack, click New to create an unsealed version of the management pack, and then click OK, or select an unsealed management pack that you previously created in which to save this override. As a best practice, you should not save overrides to the Default Management Pack.
After you change the override setting, the object type is automatically discovered and appears in the Monitoring pane under SQL Server.
