Share this page

# Database Server Resource monitoring

The Database Server Resource monitors measure database resource usage statistics for Oracle or SQL Servers during a scenario run. You use these monitors to isolate database server performance bottlenecks.

The SQL Server monitor can be configured as a native Controller monitor, or as a SiteScope monitor.

The Oracle monitor displays information from Oracle V$ tables: Session statistics, V$SESSTAT, system statistics, V$SYSSTAT, and other table counters defined by the user in the custom query.

Before defining the monitoring measurements for the Oracle monitor in Controller, you must set up the monitoring environment on the database server:

Note: If there is no application working with a database, you can only monitor the database manager instance.

For details about the Oracle monitor configuration, see Set up the Oracle monitoring environment.

You then enable each database resource monitor from Controller by selecting the counters you want the monitor to measure.

### See also

- Oracle performance counters
- SQL Server performance counters

https://admhelp.microfocus.com Professional Performance Engineering,VuGen 8942
Tips to improve your search results... OpenText™ Professional Performance Engineering Help Center OpenText™ Professional Performance Engineering Help 26.1-26.3 All View Local Help Center View Online Help Center Version: