STATISTICS IO With Query Associated Output

This session will teach you some basics things linked to Query Optimisation meaning how to map the output from STATISTICS IO (logical reads, etc.) with actual query plan in order to find which query should be analysed/query optimised. This means that logical reads and scan count, read-ahead reads, physical reads, page server reads, page server read-ahead reads, lob logical reads, lob physical reads, lob page server reads, lob read-ahead reads, lob page server read-ahead reads from STATISTICS IO are associated with actual query plan from with are extracted the following elements: missing indexes, wait types, statistics, warnings, parameter sniffing.

STATISTICS IO Query Optimization