Become A Smart DBA
What you'll learn:
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.
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.
