Page History
The Advanced Connection Settings window of the SQL Doctor allows you to input options for how you want to collect performance counters.
Access the Advanced Connection Settings window
You can access the Advanced Connection Settings window by clicking Advanced Connection Settings in the Add Server window or by selecting Edit > General Settings and clicking the corresponding link.
| Tip |
|---|
The options available in the Advanced Connection Setting windows are not available for cloud instances. The Advanced Connection Setting is not available when SQL Doctor recognizes instances running on a Linux operating system. |
Select your advanced connection settings
You can configure SQL Doctor to use either SQL Server OLE Automation or Windows Management Instrumentation (WMI) for collecting performance metrics from the selected instance.
SQL Server Automation
To use SQL Server OLE automation, check the Use OLE Automation for collecting performance counters box and then click OK.
Windows Management Instrumentation
To use WMI for collection, type the user name and password in the appropriate fields. The Authority field is optional when setting your WMI namespace security. Then click OK to close the Advanced Connection Settings window.
| Info |
|---|
Windows Management Instrumentation (WMI) is not available on a Linux operating system. |
| Tip |
|---|
For more information about WMI connection, see the following Microsoft tip at http://technet.microsoft.com/en-us/library/ee692772.aspx#EEAA. |
| Scroll pdf ignore | ||||||
|---|---|---|---|---|---|---|
Newtabfooter |
|
...
SQL Doctor provides complete SQL performance tuning. Learn more > >
...