Solved

logical vs physical reads

Posted on 2006-11-16
6
926 Views
Last Modified: 2008-03-17
what is the difference between logical reads and physical reads?
0
Comment
Question by:yanci1179
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
6 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 300 total points
ID: 17959845
physical reads means the data has been read from disk into memory
logical reads means the the data was already in memory

1 logical reads means 1 page of data, ie 8KB
0
 

Author Comment

by:yanci1179
ID: 17959911
i read that in books online....but it didn't really mean much.  Ideally which one should be lower?
0
 
LVL 32

Assisted Solution

by:bhess1
bhess1 earned 200 total points
ID: 17959980
In a perfect world, physical reads would be equal to the number of data blocks in your database, and all other reads would be logical.  So, by preference logical reads should be the higher of the two.
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 17960495
perfectly, the physical reads should be 0. also, logical reads as low as possible.
0
 

Author Comment

by:yanci1179
ID: 17960572
let me see if I understand this logical data read from what is already in cache.  if it's not there then it has to read the physical tables and retrieve the data?
0
 
LVL 32

Expert Comment

by:bhess1
ID: 17962141
Absolutely correct.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question