SQL Server Optimization and Tuning

Microsoft SQL Server Optimization: Our SQL Server Optimization class covers advanced topics to tune SQL Server and databases. The prerequisite for this class is the SQL Server Administration class. This class is scheduled for two sessions a week over two months. Major topics covers in this class are below, but more details on our curriculums: • Introduction to SQL Server • Introduction to Applications/Server/Databases • Introduction to SQL Server Optimizer • Queries and Processes • Introduction to SQL Server Profiler / Tuning Advisor / Extended Events • Intro to PerfMon • Reports • PC Components/Hardware bottlenecks • Long Running Queries • Indexes /Structures / Types • Statistics • Database Layouts, Log files / TempDB • Database Configuration for Best Performance • Database Health • Intor to Estimated Plan Execution • SPs, DMVs • Locks / Blocks Analysis • Troubleshoots of OS Hardware Bottlenecks • Job Placement/ Resume Building/ and Interview Preparation Sessions.