![]() ![]() ![]() For example, database file sequential reads may be caused by segment header contention on indexes or by disk contention. The wait states consuming the most time may point to performance bottlenecks. Query wait states: Activities that contribute to the time it takes the database to service the request.Memory Usage: Displays how much memory is in use and how much is available.User - User interaction with the database.System - Database operating system activities.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.Click a column title on the Session List to sort the Session List using the clicked column as the sort key.įrom the Database Live window, you can view:.Click the View list to view All Active Sessions or All Sessions.Hover over the sections of the charts to see their details. Select the Auto Refresh box and then from the Every list, choose how often you want the system to update the live view.Ĭlick 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. To view a database's current performance, click the name of the database.įor clustered databases, select the node to view its details.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. The Live View displays current activity for the database server. Access Database Visibility from Application Monitoring Views. ![]()
0 Comments
Leave a Reply. |