Skip to main content

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