Member Login
  • Products
    • Qure Suite
    • Qure Analyzer
    • Qure Optimizer
  • Downloads
    • Qure Analyzer (Free)
    • Qure Optimizer (Free Trial)
  • Support
    • Contact Support
    • Frequently Asked Questions
    • Limitations and Known Issues
  • Resources
    • SQL Server Articles
    • Whitepapers
    • Videos and Tutorials
    • Attend an Online Demo
    • inTune eMagazine
    • SQL Server Tuning Blog
  • Learn More
    • About Workload Tuning
    • SQL Server Tuning
    • SQL Server Performance
    • SQL Server Performance Tuning
    • Tips
  • Company
    • About DBSophic
    • Management
    • Partners
    • News
    • Success Stories
    • Customer Testimonials
    • Selected Customers
  • Contact Us
Subscribe to blog

SQL Server Tuning Blog

By SQL Server MVP Ami Levin

Posted by Ami Levin
Ami Levin
My name is Ami Levin, and I've been working with SQL Server for over 15 years. I
User is currently offline
on Monday, 05 December 2011
in SQL Server Tuning
  • Hits: 292
  • 0 Comments
  • Subscribe to updates
  • Print
  • Bookmark

SQL Server Logical Reads – What do they really tell us?

Tweet

If you’ve ever used SQL Trace, STATISTICS IO or any other SQL Server monitoring, you should know what logical reads mean. Or do you? Logical reads server as one of the primary counters for evaluating a Query’s performance. The rule of thumb says “The lower the number of reads, the better the query performs”. I’m sure you’ve heard it before. But… did you notice that in some cases the exact opposite is true? Did you ever see a query improve dramatically in terms of duration and CPU but have it’s logical reads sky-rocket? If you want to understand the TRUE essence of logical reads and be able to tell when it is really a good indicator of performance, I highly recommend you to read this article.

0 votes
Tags: Articles
  • About the author
  • Related Posts
Ami Levin
My name is Ami Levin, and I've been working with SQL Server for over 15 years. In 2006 I was awarded the SQL Server MVP award.I am also the CTO (and co-founder) of DBSophic. I hope you will find this blog interesting and useful. Your feedback will be highly appreciated.
  • View author's profile
  • Subscribe to blogger updates
  • Physical Join Operators in SQL Server

    Writing a query that joins several tables is easy, right? There are just a few major join types and their syntax is pretty straightforward and clear. ...
    By Ami Levin on - Dec 21 in SQL Server Tuning
  • SQL Server Optimizer - Partial Aggregates

    The SQL Server query optimizer is considered magical by many, even the top professionals. It is an extremely complicated piece of software whose intri...
    By Ami Levin on - Jan 12 in SQL Server Tuning

Comments

Please login first in order for you to submit comments

Biography

Ami Levin
My name is Ami Levin, and I've been working with SQL Server for over 15 years. In 2006 I was awarded the SQL Server MVP award. I am also the CTO (and co-founder) of DBSophic. I hope you will find this blog interesting and useful. Your feedback will be highly appreciated....
View all posts

Latest Posts

  • Qure Analyzer V1.5 Beta Available
    About a year ago, we launched Qure Analyzer V1.0 (previously called Qure Workload Analyzer). Si
    Read More
  • Variable Size Data Types and Memory Grants
    Yesterday, at our 118th Israeli SQL Server User Group Meeting, Adi Cohn delivered a session on commo
    Read More
  • Index rebuilds and statistics updates
    An interesting discussion came up lately on the MVP private forums regarding index rebuilds, recompi
    Read More

Tag Cloud

SQL Graphics Performance Articles Maintenance common pitfalls Announcements MVP Statistics Publications RTM iPad HA/DR Qure Analyzer Statistics SQL Server 2012 data types TSQL2sDay Performance

Blog Calendar

Loading ...
© 2011 DBSophic Ltd. All rights reserved. | Legal