Post reply

Physical reads

  • February 20, 2013 at 11:26 am

    #268893

    I am a little confused about the concept of physical reads:

    In Extended event, I add an event, and filter by physical_reads, the definition of it is:

    physical_reads (package0.uint64)

    The number of physical page reads issued by the batch.

    Does this mean to read from hard disk?

    Also in Performance monitor, if I select the counter SQL Server: Buffer Manager:Physical reads/sec

    The description is : Number of physical database page reads issued.

    Does this also mean to read from physical disk or read from Buffer manager?

    Thanks

  • February 20, 2013 at 2:36 pm

    #1589740

    Physical Reads= data pages read from hard drive

    Logical Reads= data pages read from buffer pool (data catch)

    Pooyan

  • February 20, 2013 at 2:48 pm

    #1589745

    Thanks, how about the counter:

    SQL Server: Buffer Manager:Physical reads/sec

    Does this mean per second physical read from hard disk or buffer manager?

    Thanks

  • February 20, 2013 at 2:52 pm

    #1589749

    from Hard Drive

    Pooyan

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply