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 and how it interoperates with Windows. 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. We will also look at how best to deploy SQL Server in a virtual environment.

Versions Covered: 2008 and 2012.

    Performance Objectives: Upon 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 PowerShell to work with SQL Server
    • Tune SQL Server in a virtual environment like VMware or Hyper-V

    Competencies covered in this course: SQL server troubleshooting and following best practices

      Intended Audience: Administrators and Programmers who work with SQL Server

        Prerequisites: 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
        • Mar 28 2017 8:00am-4:30pm
        • Mar 29 2017 8:00am-4:30pm
        • Mar 30 2017 8:00am-4:30pm
        $995.00 Thu, 03/09/2017 - 16:00 Jim Parshall