Enterprise Services Engineering and Architectural Services is open and providing full level services for funded projects

Class / Schedule

Information Technology

SQL Server Performance Tuning and Monitoring (3 Days)

01-04-T827
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

        Scheduled Class Location and Dates
        City Facility Date and Time Course Cost Cancel Date Instructor
        Lacey SPSCC - LACEY
        4220 6th Ave SE Bldg. 1
        Lacey, WA 98503
        • Sep 18 2017 8:00am-4:30pm
        • Sep 19 2017 8:00am-4:30pm
        • Sep 20 2017 8:00am-4:30pm
        $995.00 Wed, 08/30/2017 - 17:00 Jim Parshall