The Live View displays current activity for the database server. The live view shows key performance metrics for the last time period, which can be refreshed in a specified time interval between 10 seconds and 5 minutes.
Access the Database Live Window
To access the Database Live window:
To view a database's current performance, click the name of the database.
Click the Live View tab.
For clustered databases, select the node to view its details.
Database Live Window Features
From the Database Live window, you can:
Select the Auto Refresh box and then from the Every list, choose how often you want the system to update the live view.
Click the down arrow next to the database collector name at the top of the page to choose to view the live view of a different database Collector by either selecting the database Collector name from the list or by searching for the database collector by entering text in the search bar and then clicking the refresh icon to show only database collectors that meet that search criteria.
Hover over the sections of the charts to see their details.
Click the View list to view All Active Sessions or All Sessions.
Click a column title on the Session List to sort the Session List using the clicked column as the sort key.
From the Database Live window, you can view:
CPU Usage: If you have enabled Hardware Monitoring for the server the chart shows the percentage of available CPU resources consumed by users and the system and a break down of how the CPU is being used.
IO - Disk input and output.
System - Database operating system activities.
User - User interaction with the database.
Memory Usage: Displays how much memory is in use and how much is available.
Query wait states: Activities that contribute to the time it takes the database to service the request. The wait states consuming the most time may point to performance bottlenecks. For example, database file sequential reads may be caused by segment header contention on indexes or by disk contention.
Session List: A table describing database usage instances and their properties. The database session is the application interaction with the database, a new session is started for each request. The columns displayed are database dependent.
Blocking Tree: A tree showing all the sessions causing blocks. Nested under each blocking session are the sessions being blocked and the corresponding queries and blocked objects.
For SQL Server, the CPU Usage and Memory Usage statistics are displayed in Live View even when hardware monitoring is disabled.
In the Live View for database clusters, you must select a node from the dropdown menu to view that node's activity.