Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The following problems require user action before SQL Diagnostic Manager can begin collecting OS metrics:

OLE Automation Procedures Disabled

Select the Collect Operating System data using OLE Automation option to enable OLE Automation procedures.

OLE Automation Procedures Unavailable

The stored procedures associated with OLE Automation are missing on the SQL Server instance. SQL Diagnostic Manager cannot capture OS metrics until these stored procedures are available on the SQL Server instance.

WMI Service Not Running

The WMI Service on the monitored SQL Server instance may not be running. SQL Diagnostic Manager cannot collect OS metrics until this service is started.

Lightweight Pooling Enabled

This is an advanced feature used in symmetric multiprocessing environments in SQL Server. SQL Diagnostic Manager cannot collect OS metrics until this option is disabled on your monitored SQL Server instances.

...

heartbeatIntervalSeconds="180" wmiQueryTimeOut="300"/>

</Services>

Scroll pdf ignore
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >

...

 

...