This chapter comes from our "SQL Server 2005 Database Administration" course
Visit the course home page for full details (such as the videos in the course, free videos for the course, and more)

Chapter 11: Monitoring and Performance Tuning SQL Server

This SQL Server chapter is all about performance tuning your SQL Server and queries. The more you know about how SQL Server does what it does, the better prepared you are to make smart design decisions. Watch these videos for a solid foundation of the "how and why" things work the way they do in SQL Server.

Videos in Chapter 11

1	Performance Tuning Query Tips That Everyone Should Know - Using DBCC and SET Commands	Download
2	SET Commands for Performance Tuning and Query Execution Statistics	Download
3	Pt. 1 - Using SQL Profiler - Concepts, Terms and Screens	Download
4	Pt. 2 - Determining Which Events and Data Columns to Use in Your Trace	Download
5	Pt. 3 - Performance Tuning Profiler and Traces By Adding Filters and Working with Large Traces	Download
6	Pt. 4 - Managing, Viewing and Interpreting SQL Server Traces	Download
7	Pt. 5 - Templates and Working Within the Profiler UI	Download
8	Part1 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions	Download
9	Part2 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions	Download
10	Part3 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions	Download
11	Part4 - Dynamic Management Views (DMVs) for Monitoring Users and Transactions	Download

Login

Chapter 11: Monitoring and Performance Tuning SQL Server

Videos in Chapter 11