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

Microsoft is conducting an online survey to understand your opinion of the MSDN Web site. If you choose to participate, the online survey will be presented to you when you leave the MSDN Web site.

Would you like to participate?