Description
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.
Requrirements
Requirements
SQL performance tuning part 2 requires that you MUST have SQL performance tuning part 1 course and SQL administration part 1,2,3 as well as Learn T-SQL courses. All SQL Server application, Virtual Box application and Windows 2016 operating system will be available as a trail period for 6 months via downloads