HP Intelligent Management Center v5.2 Application Performance Manager Administrator Guide
181
4. Configure the following parameters:
IP Address—Enter the IP address of the host on which the SQL Server to be monitored is
installed. If the host is already added to the IMC Platform, you can also click Select and select
the host from the Select Devices window. For information about selecting a host, see "2 Quick
start." APM automatically checks the specified IP address and associates the application
monitor with the host managed in the IMC Platform.
Name—Enter a unique application monitor name. HP recommends using Application
name_host IP address format for naming the application monitor.
Description—Enter a description for the application monitor.
Port—Enter the service port number for the SQL Server, 1433 by default.
Traffic Collection Port—Enter the service port number for SQL Server. This field appears only
when at least one probe is configured for APM.
Polling Interval (min)—Select a polling interval for the application monitor. Available options
include 1, 2, 3, 4, 5, 10, 20, and 30. The default polling interval is 5 minutes. A shorter polling
interval provides more accurate real-time data but consumes more system resources.
Authentication Type—Select an authentication type of the SQL Server. Available options are
Windows authentication and SQL Server authentication.
Username—Enter the username of the SQL Server administrator.
Password—Enter the password of the SQL Server administrator.
Instance Name—Enter the SQL Server instance name that is the same as the name configured
when the SQL Server was installed. Keep this field empty if the default instance name has been
used.
Contact—Enter contact information, such as name, email address, and telephone number. The
default is the username of the operator who created the application monitor.
Related Applications—Configure the applications that SQL Server depends on. Click Add, and
then select applications in the popup Select Applications window. Operating system
applications, such as Windows, AIX, FreeBSD, OpenBSD, HP-UX, Solaris, Mac OS, and Linux,
cannot be selected. APM automatically adds the dependencies between SQL Server and
operating system applications by IP address and displays their dependencies in the application
topology.
Detect Application—Select this parameter if you want to enable application detection.
Application detection enables APM to verify connection to the application by using the previous
parameter settings, and to determine whether to add the application monitor based on the
verification result. APM adds the application monitor only when it can connect to the
application. When this parameter is not selected, APM adds the application monitor without
verifying the connection.
5. Click OK.
Modifying an SQL Server application monitor
Authorized users can modify all parameters except the IP address of an SQL Server application monitor.
When the IP address of the SQL Server host changes, operators must add a new application monitor for
the host. However, the new application monitor cannot inherit the history data from the previous
application monitor.
To modify an SQL Server application monitor:
1. Click the Resource tab.