To monitor a database, an administrator must first add the resource to the Monitor. By default, after the resource is added, monitoring starts.
As an administrator, you can add a resource one at a time or you can add multiple resources via an Import file. See Add multiple resources.
Log in to the Monitor as an administrator.
Follow the instructions in the Add Resource window to add a resource to monitor a database. In the Host field, specify the hostname or IP address of the computer on which the database server is running. You can use the name localhost to represent the current computer. This term is required. See Host connection parameter.
If the database is part of a mirroring system and you always want to monitor the primary server in this system, then in the Other field, type NODE=PRIMARY. See NodeType (NODE) connection parameter.
When prompted, enter the DBA user ID and password for the database, and then click OK.
When you add a database as a resource to be monitored, you must supply the DBA user ID and password for the database. These credentials are used to:
Connect to the database.
Create a new user named sa_monitor_user. The Monitor uses the sa_monitor_user to connect to the database and monitor it.
Install the database objects needed by the sa_monitor_user to monitor the database. For a list of the objects installed, see Installed objects.
Discard from the Monitor the DBA credentials. Because the sa_monitor_user is added to the database being monitored, it is not necessary to store the DBA credentials anywhere outside the database that is being monitored. See Installed objects.
The resource is added and monitoring of the resource starts automatically.
The resource appears in the Overview dashboard Resource List.
Optional: Add a dashboard for the resource. By default, when a resource is added, a dashboard is not.
Open the Overview dashboard.
Click Dashboards » Overview.
In the Resource List, click the new resource.
The Monitor creates and opens a new dashboard for the resource. The name of the new dashboard appears in the Dashboards section of the sidebar.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|