Page History

The Configure OS Metric Collection window of the Add Servers wizard lets you select which type of operating system metrics collection you want to use or whether you do not want to collect any OS metrics from a SQL Server instance. SQL :

• Do not collect Operating System data
• Collect Operating System data using OLE Automation
• Collect Operating System data using direct WMI (selected by default when adding a new SQL Server instance)

 SQL Diagnostic Manager uses OLE automation or a direct connection to the Windows Management Interface (WMI) when collecting OS metrics and service status data on clustered SQL Servers. Collect Operating System data using direct WMI is selected by default when adding a new SQL Server instance.Select Do not collect Operating System data if you do not want to collect these statistics. For additional information about OS metrics collection, see Configure OS metrics monitoring.

...

You can open the Add Servers wizard from the SQL Diagnostic Manager Console menu by selecting File > Manage Servers, and then clicking Add in the Manage Servers window.

...

Disabling OS metric collection

SQL Diagnostic Manager does not require OS metrics collection. However, if you disable this feature, SQL Diagnostic Manager ceases to collect OS metrics and does not raise any previously-associated alerts. You can easily enable OS metric collection at any time if you decide that you want to continue collecting these metrics.

Permissions for direct WMI collection

It is preferred that the WMI user is a local administrator on the monitored SQL Server instance. However, if you do not want to grant administrator access, use the following steps to configure remote WMI access in Microsoft Windows:

...

For more information about using a direct WMI connection, see the Microsoft document,

Disabling OS metric collection

SQL Diagnostic Manager does not require OS metrics collection. However, if you disable this feature, SQL Diagnostic Manager ceases to collect OS metrics and does not raise any previously-associated alerts. You can easily enable OS metric collection at any time if you decide that you want to continue collecting these metrics.

Using direct WMI when the collection service is on a different domain than the SQL Server

...