Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

sys.dm_exec_requests read vs logical_reads columns

Posted on 2010-09-05
3
Medium Priority
?
1,665 Views
Last Modified: 2012-05-10
If we  looked at sys.dm_exec_requests dmv, can someone tell me what the difference on read,writes and logical_reads column ?
Is that means logical_reads are reads from memory whereas reads are read from disk and write are write to disk ?
0
Comment
Question by:motioneye
  • 2
3 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33609097
>> Is that means logical_reads are reads from memory whereas reads are read from disk and write are write to disk ?

Yes, Logical reads are the ones read from Memory - Buffer cache to be exact.
And Reads are from Physical Disk or MDF or Data File.

And Logical Writes are the ones done to LDF or log files and the Writes are the ones done to MDF or data file.
0
 
LVL 70

Expert Comment

by:Scott Pletcher
ID: 33628624
>> And Logical Writes are the ones done to LDF or log files and the Writes are the ones done to MDF or data file. <<

Are you sure about that?

I thought Logical Writes are those done to buffers (i.e., in memory only), and presumaby Writes are physical writes.
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 2000 total points
ID: 33634050
>> I thought Logical Writes are those done to buffers (i.e., in memory only), and presumaby Writes are physical writes.

Yes, got confused and thanks for correcting it..

From BOL:
"A logical write occurs when data is modified in a page in the buffer cache. A physical write occurs when the page is written from the buffer cache to disk."
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

824 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