H3C Technologies H3C Intelligent Management Center - Manual (Page 243)

229
11 Database server monitor
This chapter describes how to add and modify monitors for 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 a 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 H3C 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 a 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 a 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 a SQL Server application monitor appears.
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. H3C recommends using Application
name_host IP address format for naming the application monitor.