Introduction to SQL Server Query Optimization

Enabling and Using STATISTICS IO

Your browser needs to be JavaScript capable to view this video

Try reloading this page, or reviewing your browser settings

This video introduces STATISTICS IO and how IO metrics can help in identifying poorly-written queries, as well as the location of a given performance problem.

Keywords

  • IO
  • Query Optimization
  • STATISTICS IO
  • Logical Reads
  • Physical Reads

About this video

Author(s)
Edward Pollack
First online
28 June 2019
DOI
https://doi.org/10.1007/978-1-4842-5144-7_4
Online ISBN
978-1-4842-5144-7
Publisher
Apress
Copyright information
© Ed Pollack 2019