SQL Server Performance Tuning Part 2

Resolving SQL Server performance tuning issues

Created by: Raphael Asghar
Production SQL Database Administrator

What Will I Learn?

• This is the second part of SQL Server performance tuning course; at the end of this course the student will be able to resolve and troubleshoot issues related index tuning, page splitting, tempb database sizing, recompilation of stored procedures, and much more with the use of tools and utilities such the performance monitor, DTA, DMVs, extended events, profiler and other tools.

Requirements

• SQL performance tuning part 2 requires that you MUST have SQL performance tuning part 1 course and SQL administration part 1,2,3 as well as Learn T-SQL courses. All SQL Server application, Virtual Box application and Windows 2016 operating system will be available as a trail period for 6 months via downloads

Target audience

• Any student who has knowledge of SQL Administration and wants to learn about SQL Server performance tuning their SQL servers. You must have the prerequisite SQL performance tuning part 1 course