SQL Server Performance Tuning Part 2
Offered By: Udemy
Course Description
Overview
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 SQLMicrosoft 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