• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1696
  • Last Modified:

sys.dm_exec_requests read vs logical_reads columns

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
motioneye
Asked:
motioneye
  • 2
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> 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
 
Scott PletcherSenior DBACommented:
>> 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
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> 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: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now