SQL Administration Part 2 will benefit the student by providing the necessary guidelines for enhancing SQL Server performance by utilizing indexes, reviewing DMVs for analysis, and setting up performance counters for gathering resource metrics. The course will cover the following:
• What are indexes and the important role they play?
• Using SQL Profiler to find long running queries
• Executing SQL various tools to monitor SQL server performance
• How to manage large database and much more