Udemybeginneren

SQL Server Performance Tuning Part 2

Optimize SQL Server performance! Learn to diagnose and fix slow queries, improve database speed, and boost overall efficiency. Practical tuning techniques included.

4.6(2,548)
13,470students
7h 35m
Certificate
Raphael Asghar
Raphael AsgharProduction SQL Database Administrator

Course Content

SQL Server Performance Tuning Part 2 is a beginner-level Udemy course taught by Raphael Asghar. It runs 7h 35m, is taught in English, and includes a certificate of completion. Learners rate it 4.6 out of 5 from 2,548 reviews, with 13,470 students enrolled. It is a paid course, last updated May 2018.

Build upon your existing SQL Server administration skills with this advanced course focused on SQL Server performance tuning. This course is specifically designed for individuals who already possess a solid foundation in SQL administration and have completed SQL Performance Tuning Part 1.

Dive deep into optimizing your SQL Server environment and gain the expertise to proactively address performance bottlenecks. You'll learn practical techniques for resolving and troubleshooting critical issues, including:

  • Index Tuning: Master strategies for creating and maintaining efficient indexes to accelerate query execution.
  • Page Splitting: Understand and address page splitting issues that can degrade performance.
  • TempDB Database Sizing: Learn how to properly size and configure the TempDB database for optimal performance.
  • Stored Procedure Recompilation: Gain control over stored procedure recompilation to improve execution speed.

Throughout the course, you'll utilize powerful tools and utilities such as:

  • Performance Monitor: Effectively monitor system performance and identify bottlenecks.
  • Database Tuning Advisor (DTA): Leverage DTA for automated performance recommendations.
  • Dynamic Management Views (DMVs): Utilize DMVs to gain real-time insights into SQL Server performance.
  • Extended Events: Implement Extended Events for comprehensive performance monitoring and troubleshooting.
  • Profiler: Employ Profiler to capture and analyze SQL Server activity.

By the end of this course, you'll possess a comprehensive understanding of SQL Server performance tuning and be equipped to maintain an optimum running SQL Server, confidently troubleshoot and resolve common performance problems in your environment. Become a SQL Server performance expert and ensure your databases are running at peak efficiency.

$ whoami — the devs behind tutorialsearch.io

Hire the developers behind TutorialSearch.io

We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.

5.0
1h 11m
beginner
pluralsight
5.0
43m
beginner
pluralsight
5.0
4h 43m
expert
pluralsight