Class / Schedule


Information Technology

SQL Server Performance Tuning and Monitoring (3 Days)

This 3-day course is about getting the best performance out of your SQL Server. We start by looking at the internals of SQL Server, how it interoperates with Windows, and then hardware’s effects on performance. Then, building upon that knowledge, we begin troubleshooting performance and enacting best practices in order to get more out of our servers. During these sections, we will also be using monitoring tools and views so we can quantify our results.

Versions Covered: All versions of SQL Server starting at 2008

    Performance Objectives: Upon successful completion of this course you should be able to:

    • Describe the architecture of SQL Server
    • Understand SQL Server’s execution model for queries
    • Select the “best” hardware for a particular deployment
    • Evaluate storage and memory solutions to maximize performance
    • Describe and analyze query performance and execution
    • Evaluate and optimize locking behavior
    • Maximize TEMPDB use
    • Use Perfmon to analyze, benchmark, and troubleshoot SQL Server
    • Use SQL Profiler to analyze, benchmark, and troubleshoot SQL Server
    • Use Query Hints to help SQL Server efficiently execute queries
    • Use Indexes and Statistics
    • Understand Query Plans and how to interpret their output

    Course Competencies: SQL server troubleshooting and following best practices

      Intended Audience: Administrators and Programmers who work with SQL Server

        Recommended Pre-requisite: Knowledge of the SQL (Structured Query Language) and some experience of SQL Server

        • Sorry, there are no classes currently available for this course.