Monitoring SQL  «Prev  Next»

Monitoring SQL Server with SQL and SQL-EM - Exercise

Objective:Test the students knowledge of monitoring SQL Server with SQL and SQL-EM.

Exercise scoring

This exercise is worth a total of 15 points. To receive full credit, provide three SQL statements. Once you have completed your answer, you will submit the exercise.


As a SQL Server system administrator for the XYZ rental corporation, part of your job is to monitor production problems. Users are complaining that the system performance is horrible ( yes, that is not a very technical term, but that is how your end users will describe their problems). From your current monitoring, you know that they are not having disk problems, network problems, or cpu problems.


Using the SQL tools presented so far, find out what user is currently causing the problem, and what table is causing the problem. You need to provide three SQL Statements to get information that will help you find the cause.

Submitting your exercise

Enter your answer into the text box below.
Click the Submit button to submit the answer .