SQL Server Administration Part 2

Learn how to optimize, improve performance, review and analysis statistics, use monitoring tools, and create indexes

Created by: Raphael Asghar
Production SQL Database Administrator

What Will I Learn?

• 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.

Requirements

• All the student needs is a laptop or a desktop. All material where appropriate will be downloaded via internet. Plus, you will need as a pre-requisite SQL Administration Part 1. All scripts and documentation will be provided by me to the student via zip file.

Target audience

• Student who are interested in managing SQL Server, Developers, IT Admins, System Admins and anyone who is responsible for the databases.