Versions Compared

Key

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

...

  • 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
titleAdvantages and disadvantages of using OLE automation

 The advantages of using OLE automation are the following:

  1. You do not require any additional ports to be opened, since the standard SQL communication port is sufficient.
  2. SQL Diagnostic Manager uses the SQL Server service account permissions to capture WMI metrics.
  3. And, uses SQL Authentication.
Note
When The disadvantages 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
titleAdvantages and disadvantages of using direct WMI

The advantages of using WMI are the following:

  1. You do not require additional SQL Server configuration adjustments.
  2. 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 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,

Newtablink
aliasSetting Up a Fixed Port for WMI
urlhttps://msdn.microsoft.com/en-us/library/bb219447(v=vs.85).aspx
.

    • Required permissions for direct WMI collection

...