Query performance tuning: final notes

Improving Query Performance in SQL Server

Dean Smith

Founder, Atamai Analytics

Final notes

 SQL Server Execution Times:
   CPU time = 390 ms,  elapsed time = 382 ms.

 

  • Time statistics examples and exercises presented in this chapter are reported in milliseconds.

 

  • In the real world, it would not be uncommon to work with large complex queries that run for ten minutes, one hour or more.
Improving Query Performance in SQL Server

Final notes

 

  • Query statistics, indexes, and execution plans are all advanced topics with many books and websites devoted to each one.

 

  • Communicate with your database administrator regarding the permissions required to use query performance tuning tools and commands in SQL Server.

 

  • Don't rely on one tool or command for query performance tuning. They can often complement one another.
Improving Query Performance in SQL Server

Conclusion

Improving Query Performance in SQL Server

Preparing Video For Download...