Table of Exercises
Exercise 1.1 Correlating a Trace with Windows Performance Log Data
Exercise 2.1 Using the Database Tuning Advisor
Exercise 2.2 Generating Query Plans
Exercise 2.3 Maintaining Indexes
Exercise 2.4 Troubleshooting Deadlocks
Exercise 3.1 Reverting to Database Snapshots
Exercise 4.1 Implementing SQL Server Event Alerts
Exercise 4.2 Implementing SQL Server Performance Condition Alerts
Exercise 4.3 Implementing WMI Event Alerts
Exercise 4.4 Implementing INSTEAD OF Triggers.
Exercise 4.5 Implementing DDL Triggers
Exercise 5.1 Running Database Consistency Checks
Exercise 5.2 Using the Database Maintenance Plan Wizard.
Exercise 6.1 Creating an SSIS Package
Get MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.