The Monitoring the Database Activity module provides you with the instructions and devices to develop your hands-on skills in the following topics.
- Managing Activity Monitor
- Working with Performance Monitor
Lab time: It will take approximately 60 minutes to complete this lab.
Four exam objectives are covered in this lab.
- Open Object Explorer and Activity Monitor
- Set the Activity Monitor refresh interval
- Use Activity Monitor to detect and fix blockage
- Use Performance Monitor with appropriate counters to detect low-performing activities
Exercise 1 - Managing Activity Monitor
You can retrieve process and query related information from Activity Monitor. Using Activity Monitor, you, as a database administrator, can determine the status of processes, monitor the database activity, and troubleshoot the problematic queries. There are six expandable and collapsible panes in Activity Monitor. These are as follows:
- Overview: This panel displays overall information of the processes, the waiting tasks, database I/O, and so on.
- Processes: This pane provides the list of active database users who are logged into the database. The active session IDs are also displayed along with other process details. You can identify the problem causing processes or sessions from the list and kill them.
- Resource Waits: This pane shows information related to various wait categories such as memory, lock, network I/O, logging, and so on in the databases.
- Data File I/O: This pane displays disk level I/O information related to the log files in the databases.
- Recent Expensive Queries: This pane provides information on the weak or problematic queries that have recently created an impact on the database performance. You can also view the execution plan of the weak queries to troubleshoot and fix the issues.
- Active Expensive Queries: This pane shows information on the poorly performing queries that are active in the database.
In this exercise, you will perform the following tasks in Activity Monitor:
- Set the refresh interval.
- Identify the problematic database queries and fix them.
- Review the information displayed in the Activity Monitor panes.
Exercise 2 - Working with Performance Monitor
You can use Windows Performance Monitor snap-in to analyze the performance of computers. Performance Monitor provides a visual display of the system’s performance with the help of graphs, histograms, or reports. There are various performance counters available such as memory, physical disk, processor time, and so on that helps to generate the real-time performance report.
In this exercise, you will use Performance Monitor to detect low-performing activities on PLABSQL01.
See the full benefits of our immersive learning experience with interactive courses and guided career paths.