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