...
- Collect Operating System metrics using OLE automation: Change your OS metrics collection to use OLE automation if you want OS and disk statistics, plus the auto discovery of mount points.
| Info |
|---|
| title | Advantages and disadvantages of using OLE automation |
|---|
|
The advantages of using OLE automation are the following: - You do not require any additional ports to be opened, since the standard SQL communication port is sufficient.
- SQL Diagnostic Manager uses the SQL Server service account permissions to capture WMI metrics.
- And, uses SQL Authentication.
|
| Note |
|---|
| The disadvantages when When using OLE automation are that you must enable this option; also, OLE automation opens up possibilities for a sysadmin to run queries to reach outside SQL, although you must be a sysadmin to run these queries, it may not be the best option for some environments. |
- Collect Operating System metrics using direct WMI: Select to collect your OS Metrics using WMI.
| Info |
|---|
| title | The advantages and disadvantages Advantages of using direct WMI |
|---|
|
The advantages of using WMI are the following: - You do not require additional SQL Server configuration adjustments.
- You do not require SQL Server to gather the performance data because the collection service reaches directly to WMI.
|
| Note |
|---|
When The disadvantages when using direct WMI are that you must have RPC port 135 opened for WMI request initiation access, you . You must have permissions configured on each SQL instance to allow for remote access to WMI, and you must use using a Windows account. For more information about other required opened Other high-end ports opened may be required in firewall WMI, see the Microsoft document, to allow WMI to communicate. The following article explains how to set a fixed port for WMI: | Newtablink |
|---|
| alias | Setting Up a Fixed Port for WMI |
|---|
| url | https://msdnsupport.microsoftsolarwinds.com/en-us/library/bb219447(v=vs.85).aspx |
|---|
|
.| SuccessCenter/s/article/Setting-a-fixed-port-for-WMI?language=en_US |
|
|
- Required permissions for direct WMI collection
...
For more information about using a direct WMI connection, see the Microsoft document,
| Newtablink |
|---|
| alias | Securing a Remote WMI Connection |
|---|
| url | https://docs.microsoft.com/en-us/windows/win32/wmisdk/securing-a-remote-wmi-connection |
|---|
|
.
- Configure WMI to run out-of-process
...
To configure the WMI timeout value:
- NAvigate Navigate to the SQL Diagnostic Manager install directory
- Open SQLdmCollectionService.exe.Config
- Modify the <CollectionService> node under the <Services> node
- Add wmiQueryTimeOut="300" as a parameter to this node
- Save and close file
- Restart the collection service
Sample configuration entry:
...
- 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.