Search SSWUG.ORG:

DATABASES

SQL Server Logical Reads – What do they really tell us? This is an off-site link.  Please review our Terms of Service for additional information.




(Ami Levin) SQL Server trace, the most common tool DBAs use to evaluate query performance, provides the ‘logical reads’ counter on which many DBAs rely for evaluating a query’s I/O performance. In this article, we will examine this counter’s true meaning and provide examples that prove it can sometimes be quite misleading…

Read this article...







comments powered by Disqus