Documentation forSQL Sentry

Least Privilege General Performance Monitoring

Note:  It's possible to collect Performance Counter data in the SQL Sentry Event Calendar without Windows Administrator privileges.

Collecting Performance Counters

Add the SQL Sentry monitoring service account to the Performance Monitor security group of the machine where the monitoring service is installed. For the service to access the Performance Counters of your watched instances remotely, grant the service account read access to certain registry keys. Complete the following steps on each target that you want to collect Performance Counters

1. Navigate to the winreg key located at the following path:

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurePipeServers\winreg

2. Right click on the winreg key and select Permissions. Add the SQL Sentry monitoring service account.

3. Restart Windows.

Note:  For general information on editing the Windows Registry see Windows registry information for advanced users.