Thursday, July 31, 2014
 
  Performance Tuning Methodologies

Performance Tuning Methodologies

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
  Implementing Compression

Implementing Compression

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


  Troubleshooting deadlocks

Troubleshooting Deadlocks using Profiler

In this demonstration you will learn how to:

  • Create a simple deadlocking event
  • Execute to see default behavior
  • Monitor with profile




Troubleshooting and Tuning Performance Issues in SQL Server 2008

In this module you will learn about performance tuning methodologies, and tools and techniques for performance analysis and tuning.

  Implementing Query Hints

Implementing Query Hints

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
  Implementing Plan Guides

Implementing Plan Guides

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


HOME   |   Article Library   |   Scripts & Tools   |   Training Videos   |   Job Board   |   Resources
Copyright 2010 by SQLCOMMUNITY.COM