Solved

sys.dm_exec_requests read vs logical_reads columns

Posted on 2010-09-05
3
1,546 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 69

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 500 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

840 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