Module 13: Performance Tuning

In this module, you will learn the following:

Performance tuning methodologies

Instance level
Database level
Application level

Overview of tools and techniques for performance analysis and tuning

If you've installed Silverlight, you can click the Play button in the video player at left.
Or, right-click (Save Target As...) the link below to download.

Video Download
WMV

Length: 31 Minutes 41 seconds

Downloads
Powerpoint - Open the file using PowerPoint 2007.
Zip - Unzip the file, click launch.htm to view interactive training.

Module 13: Demo 1

In this demonstration you will learn to:

Use the Compression Wizard to benefit from ROW or PAGE type options.
Understand how to calculate compression savings with the wizard or with scripts
Implement compression with the wizard or with scripts

Video Download
WMV

Length: 6 Minutes 8 seconds

Module 13: Demo 2

In this demonstration you will learn to:

Use the SQL Server Profiler to capture events within SQL Server as it is being used.
Choose the type of events to monitor
Review the activities by Replaying the trace at a later time.
Generate script templates for traces

Video Download
WMV

Length: 20 Minutes 16 seconds

Module 13: Demo 3

In this demonstration you will learn to:

Enforce a MERGE JOIN in a query.
Benefit from the OPTIMIZE FOR hint.
Override the row locking default with a TABLOCK hint.
Remove all shared locks with the NOLOCK hint

Video Download
WMV

Length: 13 Minutes 4 seconds

Module 13: Demo 4

In this demonstration you will learn to:

Override an existing query with a Plan Guide.
Use the new SQL Server 2008 interface to implement Plan Guides

Video Download
WMV

Length: 6 Minutes 4 seconds