RelationalDBDesign
SiteMap
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Database Web Apps
Data Manipulation
Access Features
Tables Queries
Monitoring SQL
«Prev
Next»
Configuration Monitoring
Importing/Exporting Data
Insert Data Load Statement
Select into Statement
Bulk Insert Statement
SQL Bulk Copy Program
Data Transformation Services
DTS Package Designer
Scheduling Running Package
DTS Wizard
Running DTS Wizard
Load Export Conclusion
Monitoring SQL-EM
Monitoring SQL Connections
Monitor Locked Resources
SQL-EM Monitor Locks
Overall System Performance
Monitor Data Cache
Monitor Performance using DBCC
Monitoring Databases
Monitor Database Size
Use SSMS monitor DB Size
Monitor Databases using DBCC
Monitor Consistency Individual Tables
Miscellaneous DB Monitoring via Dbcc
Monitor Transaction Log
Maintaining Database Statistics
View Statistical Information
Run sqlmaint.exe
Database Maintenance Plan wizard
SQL-Em Conclusion
SQL-Server Profiler
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.
Background/overview
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.
Instructions
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 .