Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
SQL Server Database Performance Monitoring and Tuning
Rating: 3.9 out of 5(137 ratings)
804 students

SQL Server Database Performance Monitoring and Tuning

Become A Smart DBA
Created byGangadhar Gawande
Last updated 9/2020
English

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

Course content

9 sections • 33 lectures • 2h 37m total length

  • Introduction4:50

    After completing this chapter you will be familiar with the overall understanding of the course.

Requirements

  • Basic knowledge of RDBMS database

Description

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.

Who this course is for:

  • 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

Report abuse