SQL Server Performance Tuning

£395.00

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

Category:

DESCRIPTION

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.

INSTRUCTOR

MITCHELL PEARSONMITCHELL PEARSON

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.


Duration: 4:08:36
SQL Server performance is as much an art form as it is a science. Many times a server will give conflicting information about the state that it is in. The SQL Server Performance Tuning training 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.
SQL Server Performance Tuning - What you need to get started
Module 01 - Class Introduction
10:18
Module 02A - Understanding Queries in SQL Server (Query Basics)
18:35
Module 02B - Understanding Queries in SQL Server(Relational Engine Query Process)
35:31
Module 02C - Understanding Queries in SQL Server (Parallelism)
21:20
Module 03A - Index Tuning (Basic Tuning)
38:42
Module 03B - Index Tuning (Columnstore Indexes and Maintenance)
34:56
Module 04 - Locking, Blocking, Deadlocks and Latches
Module 05 - Waits and Queues Methodology
20:42
Module 06 - Baselines
19:13
Module 07 - Monitoring and Alerting
12:15
Module 08 - Extended Events
37:04
Class Survey

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