Enhance your SQL Server performance with optimization techniques, index creation, and monitoring tools. Learn valuable utilities for effective SQL administration.
SQL Administration Part 2 dives into sharpening your SQL Server game! You’ll learn to boost performance through indexes, analyze stats, and get comfy with monitoring tools. Plus, it's all about preparing you for the next step in your SQL journey!
Learn how to optimize, improve performance, review and analysis statistics, use monitoring tools, and create indexes
SQL Administration Part 2 will benefit the student by providing the necessary guide lines for enhancing SQL Server performance by utilizing indexes, reviewing DMVs for analysis, and setting up performance counters for gathering resource metrics; and also I will explain a handful of utilities to gather information about SQL Server internals, such as SQL Profiler, Database Tuning Advisor (DTA), Extended Events, SQL performance monitor, Activity monitor, and teach about partitions, creating contained database for recovery, reviewing SQL server logs and by installing SQL Server 2014 as the newer SQL version.The student will not only add to the knowledge gained bur SQL Administration Part 1, but get prepared for the next course SQL Administration Part 3 – the high availability solutions.
At the end of SQL Administration Part 2, the student will be able to create indexes for to gain performance, use the SQL Profiler to find and trouble shoot expensive queries, use the activity monitor for analysis, deploy the performance monitor to find specific about SQL Server internals, use DTA utility, create and investigate issues with DMVs and extended events, look at SQL logs, monitor the health of the SQL Server more efficiently and much more.
49 Lectures
Worked as a Production SQL Database Administrator and developer for over 15 years for various companies such as Neutrogena, BakeMark, Solutions2Go and NextGen. Want to help those students that want more that the basic SQL Language. Creating real life courses for those students who want a simple path to becoming a SQL DBA. I love SQL Administration and all that...
The best Microsoft SQL Server DBA course I have taken. The institutor delivery is spot-on with both theoretical and practical. I think the Part 1,2,3 should be included as a course instead of the separation!
good
WORTH IT
Good explanation on the difference between clustered and non clustered indexes.
The course is excellent.
good
It was simple session with crisp explanation
good
All topics are very helpful and clear.
Your email address will not be published. Required fields are marked *
Jorge U.
Very explained topics