Extended Monitoring Guide
All MS SQL Server services must have a device entry under the /Devices/Server/Windows/MSSQLServer device class. In addition, verify that your Zenoss Windows service account has access to the MS SQL Server service.
Navigate to the device or device class in the Zenoss web interface.
If applying changes to a device, click the page menu, then select → .
If applying changes to a device class, click on the zProperties tab.
Verify the credentials for the service account to access the service.
Table 35.3. MS SQL Server zProperties
Name Description zWinUser
Windows user with privileges to gather performance information.
zWinPassword
Password for the above user.
Click to save your changes.
You will now be able to start collecting the MS SQL Server server metrics from this device.
Navigate to the Perf tab and you should see some placeholders for graphs. After approximately 15 minutes you should see the graphs start to become populated with information.