Manualshelf

HP Intelligent Management Center v5.2 Application Performance Manager Administrator Guide

ManualsBrandsHP ManualsComputer AccessoriesHP IMC Application Manager additional 50-monitor E-LTU
181182183184185186187188189190
180
10 Database server monitor
APM supports monitoring the following database servers:
SQL Server
MySQL
Oracle
DB2
DBQuery
Sybase
This chapter describes how to add and modify monitors for these database servers, and how to view the
monitor reports.
SQL Server
SQL Server is a Microsoft developed Database Management System (DBMS). The performance and
stability can impact the service applications directly, so APM supports the monitor function to SQL Server.
APM can monitor SQL Server 2000, SQL Server 2005, and SQL Server 2008.
Adding an SQL Server application monitor
APM monitors the SQL Server through the service port (1433 by default). When you add application
monitors for SQL Server, follow these guidelines:
Add SQL Server hosts to the IMC Platform so APM can obtain and display network connections of
the hosts and their access devices in the application topology. For more information about adding
hosts to the IMC Platform, see HP IMC Base Platform Administrator Guide.
Obtain the correct username and password of the user who has the SQL Server administrator's
privileges and the corresponding authentication type.
Obtain the instance name for the SQL Server unless the default instance name has been used.
To view traffic statistics in the monitor report of the SQL Server application, make sure at least one
probe is configured in APM. After an SQL Server application monitor is added, APM sends the IP
address and service port of the monitored SQL Server application to the probes for traffic collection.
To add an SQL Server application monitor:
1. Click the Resource tab.
2. Enter the Add Application page in one of the following ways:
Select Application Management > Add Application from the navigation tree.
The page displays all application types that can be monitored by APM.
Select Application Management > Application Monitor from the navigation tree, and then click
Add on the application monitor list page.
3. Click SQL Server of the Database Server Monitor class.
The page for adding an SQL Server application monitor appears.