User guide

10 Appendix
The Appendix contains the following topics:
SQL Sentry Performance Advisor
Performance Advisor Security Requirements
Performance Advisor Required Ports
Performance Advisor Data Capacity Planning
SMTP Settings
Uninstalling SQL Sentry
Object Removal Script for Watched 2000 Servers
Object Removal Script for Watched 2005+ Servers
Watched Server Objects
Standard Vs Enterprise Editions
10.1 SQL Sentry Performance Advisor
PERFORMANCE ADVISOR
This section contains the following topics:
Performance Advisor Security Requirements
Performance Advisor Required Ports
Performance Advisor Data Capacity Planning
For general information concerning SQL Sentry Performance Advisor, including an explanation of the
Performance Metrics displayed on the Dashboard, please see the Performance Advisor section of the
SQL Sentry User Guide.
10.1.1 Performance Advisor Security Requirements
Performance Advisor collects various performance and configuration data directly from Windows, and
therefore requires a higher level of access to the operating system than does Event Manager. The
easiest approach is to either make the SQL Sentry Monitoring Service account a Domain Administrator
level account, or a member of the local Administrators group on any watched servers.
In some scenarios it may be possible to use a non-Administrator service account, although this is not
an officially supported approach. This article identifies the steps required to do this:
1. Enable DCOM on the SQL Sentry Server machine, SQL Sentry Client machine, and the server to
be watched. (See this link for instructions.)
2. Give the SQL Sentry Monitoring Service account proper permissions to the required WMI
namespaces. You can do this by going to the properties for "WMI Control", found under
SQL Sentry Quick Start 34
©2015 SQL Sentry. All Rights Reserved.