SQL Server Performance Tuning

SQL Server Performance Tuning

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.

Index maintenance, Query Tuning, dealing with TempDb issues and many more.

Url: View Details

What you will learn

• This tutorial will provide comprehensive material of SQL Server performance tuning along with handy tips for issue resolution.
• Provide details about SQL waits and resolution.
• Learn about database statistics, optimizer and maintenance plan for tables and indexes.

Rating: 4.11765

Level: All Levels

Duration: 3.5 hours

Instructor: Amit Arora