Query performance tuning: final notes

1. Query performance tuning: final notes

We'll complete this chapter with some final notes on tools and commands that are available with SQL Server to help analyze and tune query performance.

2. Final notes

In SQL Server time statistics are commonly reported in milliseconds. In the examples and exercises presented in this chapter, we compared queries and said that based on the differences in time one would likely run slower or faster than the other. In reality, the time differences reported in the examples and exercises would be unnoticeable. In the real world, it would not be uncommon to work with large complex queries that run for ten minutes, one hour or more. This is where utilizing time statistics for query tuning performance is invaluable.

3. Final notes

This chapter provided a brief overview of query statistics, indexes, and execution plans. All of these are advanced topics with many entire books and websites devoted to each of these and other query performance tuning tools and commands. The use of SQL Server tools and commands discussed in this chapter may require elevated levels of database permissions. We recommend communicating with your database administrator about your requirements before starting a project that may require analyzing query performance. When trying to tune query performance with any of the tools and commands available in SQL Server, don’t just rely on one. Each one can provide a different insight, and often they complement one another.

4. Conclusion

Thanks for taking this course. We hope you enjoyed it and we look forward to seeing you in another one.

Create Your Free Account

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.