Monitoring and Managing Ingres with Visual Performance Monitor
Visual Performance Monitor can be used as a monitoring tool, a performance analysis tool, and a system management tool.
Visual Performance Monitor lets you monitor the following:
• Servers
You can view a list of the servers that are started on an installation, and information about each server. For example, you can view the sessions that are currently active for each server. You can also remove a session or stop a server (if you are a privileged user).
Visual Performance Monitor provides the following information for a particular server:
– Lock lists
– Locks
– Transactions
– Locked databases, tables, and pages
– Other locked resources
– Network traffic for Net servers
• Users and sessions
You can monitor users for whom there are open sessions. You can find out which sessions are open for a particular user, and drill down further to reveal all the related information about those sessions (lock lists, transactions locked, databases locked, and so on).
• Logging
You can view logging system summaries, transaction lists, process, and database lists. Log information can be used to monitor transaction rates, log file activity, processes, and databases in the logging system. This information is useful in determining which logging parameters need to be adjusted.
• Locking
You can monitor lock information to help determine which lock parameters need to be adjusted. Viewing locking system summaries, lock lists, and resources provides you with the information you need to spot conditions when, for example, additional locking system resources need to be added.
Viewing your lock lists is useful for locating transactions that cannot proceed because they are blocked by another transaction.
• System performance
You can view your performance information from a “database” point of view. This means you can access performance information using a database branch, as opposed to the root branches of Visual Performance Monitor.
• Replication
You can start, stop, and monitor Replicator servers that are required for the replication scheme that has been defined in a VDBA DOM window. You can set up startup parameters for these servers, send events to these servers, view and manage collisions, and display other miscellaneous replication monitor information.
Visual Performance Monitor lets you perform the following actions:
• Refresh data in the window from a server
• Shut down a database server or close a session
Last modified date: 01/30/2023