SQL Server Database Performance Monitoring and Tuning

SQL Server Database Performance Monitoring and Tuning, available at $49.99, has an average rating of 3.75, with 33 lectures, based on 118 reviews, and has 742 subscribers.

You will learn about SQL Server Database Performance Monitoring (Automated) and Tuning How to capture database performance metrics, Causes of Performance bottlenecks, Diagnosing Performance issues, Indexes, Statistics, Wait Statistics, Parameter Sniffing, How to capture expensive stored procedures, blocking incidents, deadlock incidents, How to automate the entire performance metrics collection process At the end of the course, the students will be able to deploy the code directly on their machine and see the results instantly. The final output of the consolidated script will be equivalent to other expensive software in the market. This course is ideal for individuals who are SQL Server DBAs, Developers, Architects who want to perform the database performance monitoring and tuning or Any Beginner who wants to start with Microsoft SQL Server as a career option It is particularly useful for SQL Server DBAs, Developers, Architects who want to perform the database performance monitoring and tuning or Any Beginner who wants to start with Microsoft SQL Server as a career option.

Enroll now: SQL Server Database Performance Monitoring and Tuning

Summary

Title: SQL Server Database Performance Monitoring and Tuning

Price: $49.99

Average Rating: 3.75

Number of Lectures: 33

Number of Published Lectures: 33

Number of Curriculum Items: 34

Number of Published Curriculum Objects: 34

Original Price: ₹7,900

Quality Status: approved

Status: Live

What You Will Learn

SQL Server Database Performance Monitoring (Automated) and Tuning
How to capture database performance metrics, Causes of Performance bottlenecks, Diagnosing Performance issues, Indexes, Statistics, Wait Statistics, Parameter Sniffing, How to capture expensive stored procedures, blocking incidents, deadlock incidents, How to automate the entire performance metrics collection process
At the end of the course, the students will be able to deploy the code directly on their machine and see the results instantly. The final output of the consolidated script will be equivalent to other expensive software in the market.

Who Should Attend

SQL Server DBAs, Developers, Architects who want to perform the database performance monitoring and tuning
Any Beginner who wants to start with Microsoft SQL Server as a career option

Target Audiences

SQL Server DBAs, Developers, Architects who want to perform the database performance monitoring and tuning
Any Beginner who wants to start with Microsoft SQL Server as a career option

This course equips you with the skills required to manage the SQL Server database efficiently. The course mainly focuses on performance monitoring and tuning and how to automate the monitoring process. The most valuable gift of this course is to have ready to implement scripts including schema and other required objects at the end of the course. Students can directly deploy the code and start generating SQL Server database performance metrics.

Note: It is recommended to run the code on a test environment before deploying on production.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Chapter 2: About The Course

Lecture 1: About The Course

Chapter 3: Why Automation Is Necessary ?

Lecture 1: Why The Automation Is Necessary ?

Chapter 4: What To Monitor ?

Lecture 1: What To Monitor ?

Chapter 5: Query Optimizer

Lecture 1: Query Optimizer

Chapter 6: Parameter Sniffing

Lecture 1: Parameter Sniffing

Chapter 7: Causes of Performance Degradation

Lecture 1: TempDB Contention

Lecture 2: Non-Scheduled Database Maintenance

Lecture 3: Expensive Stored Procedures or Queries

Lecture 4: Blocking Incidents

Lecture 5: Deadlock Incidents

Lecture 6: Wrong Index Strategy

Lecture 7: A High CPU Consumption Consistently

Lecture 8: High Memory Usage – Memory Allocation Background

Lecture 9: High Memory Usage – Configurations and Parameters

Lecture 10: Disk I/O Bottleneck

Lecture 11: Poor Database Design

Lecture 12: Poor Application Design

Chapter 8: Diagnosing Performance Problem

Lecture 1: Index Management

Lecture 2: Analyzing Execution Plan for Indexes

Lecture 3: Detecting and Reducing Fragmentation

Lecture 4: Statistics

Lecture 5: Wait Statistics

Lecture 6: Dealing with TempDB Contention

Lecture 7: Temporary Table Caching

Lecture 8: Temporary Table Vs Table Variable

Lecture 9: Identifying Expensive Stored Procedures and Queries

Lecture 10: Identifying Blocking Incidents

Lecture 11: Identifying Deadlock Incidents

Lecture 12: Optimize for Adhoc Query Workload

Lecture 13: Analyzing Execution Plan

Chapter 9: Automating the Monitoring Process – Putting It All Together

Lecture 1: Automating the Monitoring Process – Putting It All Together

Lecture 2: Creating required objects and jobs

Instructors

Gangadhar Gawande
SQL Server Database Performance Monitoring and Tuning

Rating Distribution

1 stars: 8 votes
2 stars: 5 votes
3 stars: 18 votes
4 stars: 43 votes
5 stars: 44 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu