HomeOn-Demand LearningSQL ServerSQL Server Performance Tuning

SQL Server Performance Tuning


What Will You Learn?

  • SQL Server Index Tuning and Query Tuning best practices
  • To use tools such as Profiler, Extended Events and SQLIO
  • To create a plan that will assist the DBA to monitor servers, alert on issues and resolve slowdowns


SQL Server performance is as much an art form as it is a science. Often, a server will give conflicting information about the state that it is in. The SQL Server Performance Tuning course is designed to provide SQL DBAs with the tools and knowledge that is required to keep their SQL Servers running efficiently and reliably. Additionally, you will experience how to perform advanced performance tuning and optimization in your everyday DBA work.



BI Consultant and Trainer
As a Business Intelligence Consultant and Trainer for Pragmatic Works, Mitchell’s focus is on the full BI Stack (SSIS, SSAS and SSRS). In addition to the BI Stack, he also has experience with Data Modeling, T-SQL, MDX, Power Pivot and the Power BI Tools. Mitchell graduated from the University of North Florida in 2007 and is constantly expanding his knowledge on all things SQL Server.


What to Know Before the Class

The course assumes attendees have a strong understanding of SQL Server fundamentals. For example, knowing and using the SQL Server Management Studio (SSMS) interface and associated toolbox items before attending this class.

Curriculum For This Course

System Requirements

  • Microsoft Windows XP Professional, Microsoft Windows Server 2003, Microsoft Vista, Windows 7, Windows 8, or Windows 10
  • 2 GHz or faster CPU
  • 2 GB of available RAM (recommended 4 GB)
  • 20 GB of free hard drive space
  • SQL Server Developer, Standard or Enterprise Edition 2008/2008R2/2012/2014
    • SQL Server Database Engine
    • SQL Server Management Studio
  • AdventureWorks2012 or AdventureWorks2014 databases installed on the instance
  • AdventureWorksDW2012 or AdventureWorksDW2014 databases installed on the instance

You may also like…