You will get a conceptual understanding of various SQL Server database performance issues and learn about different places to check for the performance information along with tuning approach.
Broadly this course will cover following:
Understanding SQL Server waits and how to resolve it.
Tempdb contention issues.
Learn about database statistics, optimizer and maintenance plan for tables and indexes.
SQL Tuning techniques.
Partition in SQL Server.
General guidelines for avoiding performance issues in SQL database.