YoVDO

SQL Server Performance Tuning Part 2

Offered By: Udemy

Tags

SQL Courses Relational Databases Courses Extended Events Courses

Course Description

Overview

Resolving SQL Server performance tuning issues

What you'll 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.

This course is designed for 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.

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. This will allow you to have an optimum running SQL Server and an extensive knowledge of how to trouble shoot and resolve the more pressing issues you may face in your environment.


Taught by

Raphael Asghar

Related Courses

Monitor and optimize operational resources in Azure SQL
Microsoft via Microsoft Learn
SQL Server Administration Part 2
Udemy
Extending Your Use of Extended Events
PASS Data Community Summit via YouTube
Azure SQL Database - Lessons Learned from the Trenches
PASS Data Community Summit via YouTube
Improving Columnstore Load Scalability on Large Servers
PASS Data Community Summit via YouTube