Page History
...
- Collect Operating System metrics using direct WMI: Select to collect your OS Metrics using WMI.
Info | ||||||
---|---|---|---|---|---|---|
| ||||||
The advantages of using WMI are the following:
The disadvantages when using direct WMI are that you must have RPC port 135 opened for WMI request initiation access, you must have permissions configured on each SQL instance to allow for remote access to WMI, and you must use a Windows account. For more information about other required opened high-end ports in firewall WMI, see the Microsoft document,
|
...
- 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.
Scroll pdf ignore |
---|
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > > |