In this lesson, you remove the demo12 resource, which deletes the collected metrics and stops data collection. In a production environment when you want to continue monitoring your database, you leave both the database and the Monitor running.
You must be logged in to the Monitor as an administrator to perform the following tasks. Only administrators can remove resources. You cannot delete the SQL Anywhere Monitor resource. See Monitor users.
Log in to the Monitor as an administrator.
Remove the demo12 resource.
Choose Tools » Administration.
Select the demo12 resource, and click Stop.
Click Yes to confirm that you want to remove the resource.
When you remove a database resource, the Monitor does not delete the monitoring objects installed in the database. To delete these objects, you must connect as a user with DBA authority to the database, and then execute the following command:
DROP USER sa_monitor_user;
Log out of the Monitor.
Close the browser window where you are viewing the Monitor.
Exit the Monitor and stop monitoring.
On Windows, in the system tray, right-click the SQL Anywhere Monitor icon and choose Exit SQL Anywhere Monitor.
On Linux, run the samonitor.sh script from the bin32 or bin64 directory in the Monitor installation directory:
The Monitor stops collecting metrics for all resources.
Shut down the SQL Anywhere database.
Double-click the network server icon in the system tray for the demo12 database server.
Click Shut Down in the database server messages window.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|