Database Resource Monitoring Overview
LoadRunner's 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 LoadRunner 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 How to 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.