Testing data collection methods

SQL Monitor - 2.0

Versions available: 3.2, 3.1, 3.0, 2.3, 2.2, 2.1, 2.0

Learning SQL Monitor - 2.0

Testing data collection methods

SQL Monitor collects data from your monitored servers using the following methods:

Ping
Remote registry (PerfMon & registry access)
WMI
Remote file access
SQL

If you are experiencing connection issues in SQL Monitor, you can start to diagnose where the problem occurs by testing each type of connection independently.

Opening the command prompt

To test each data channel, you will first need to open a command prompt as an administrator:

Log in to the machine that is running the SQL Monitor Base Monitor service. See the About page (Configuration > About) for details of which machine is running the Base Monitor service.
Run the command prompt as an administrator:
1. From the Start menu, select All Programs > Accessories.
2. Right-click on Command Prompt and select Run as administrator.
3. A security warning may be displayed. Click Yes to continue.

Testing ping

At the command prompt, run:

ping myserver.example.com

where myserver.example.com is the name of the Windows server you are attempting to monitor.

Testing remote registry (PerfMon)

At the command prompt, run:
runas /netonly /user:example.com\myaccount "perfmon"

where example.com\myaccount is the Windows account you are using to monitor the server. This is the account listed under Credentials on the Monitored servers page in SQL Monitor (Configuration > Monitored servers), as shown below:
When prompted, enter the password for this account.
Click on Performance Monitor in the left pane, then click the Add button:
In the Select counters from computer box, enter the name of the server you are attempting to monitor.
By default, Processor is selected in the list of counters and _Total in the Instances of selected object box.
Click Add>>. The selected counter appears in the Added counters box on the right:
To check another server you are attempting to monitor, type its name in the Select counters from computer box and repeat the steps above.

Testing remote registry

At the command prompt, run:
runas /netonly /user:example.com\myaccount "regedit"

where example.com\myaccount is the Windows account you are using to monitor the server. This is the account listed under Credentials on the Monitored servers page in SQL Monitor (Configuration > Monitored servers), as shown below:
When prompted, enter the password for this account.
In the Registry Editor, select File > Connect Network Registry.
Enter the name of the server you are attempting to monitor in the Select Computer dialog box:
Click OK. The name of the server should be displayed in the left pane.
Beneath the name of the server, expand HKEY_LOCAL_MACHINE. You should see a list of registry keys:
Repeat the steps above for other servers you want to test.

Testing WMI

At the command prompt, run:
wbemtest
In the Windows Management Instrumentation Tester dialog box, click Connect.
In the Namespace box, type \\myserver.example.com\root\cimv2 where where myserver.example.com is the name of the Windows server you are attempting to monitor.
Under Credentials, enter the Windows account you are using to monitor the server and the password. This is the account listed under Credentials on the Monitored servers page in SQL Monitor (Configuration > Monitored servers).
Click Connect.
Click Query and enter the following query:
SELECT Name FROM Win32_Service
Click Apply. You should see a list of results similar to those shown below:

Testing remote file access

At the command prompt, run:
runas /netonly /user:example.com\myaccount "explorer"

where example.com\myaccount is the Windows account you are using to monitor the server. This is the account listed under Credentials on the Monitored servers page in SQL Monitor (Configuration > Monitored servers).
When prompted, enter the password for this account.
In the Explorer window address bar, type \\myserver.example.com\c$ where myserver.example.com is the name of the server you are attempting to monitor. You should see the contents of that server's C: drive displayed.

Testing SQL connection

You can test SQL connectivity using SQL Server Management Studio.

Testing SQL connection using SQL Server authentication:

From the Start menu, select All Programs > Microsoft SQL Server 2005/2008 > SQL Server Management Studio.
At the Connect to Server dialog, enter the fully qualified name of the SQL Server instance you are attempting to monitor in the Server name box.
Select SQL Server Authentication.
Enter the SQL Server login and password you are using to connect to the SQL Server instance and click Connect.

Testing SQL connection using Windows authentication:

From the Start menu, select All Programs > Microsoft SQL Server 2005/2008 to display a sub-menu.
Hold down the Shift key, right-click on SQL Server Management Studio and select Run as different user.
At the Windows Security dialog, enter the Windows user name and password you are using to connect to the SQL Server instance and click OK.
At the Connect to Server dialog, enter the fully qualified name of the SQL Server instance you are attempting to monitor in the Server name box, and click Connect.