locked
Obtaining MB/Sec for Buffer Pool RRS feed

  • Question

  • Hi all,

    I use performance objects such as Physical Disk: Bytes/Sec to monitor physical IO on disks. I need something like that to calculate number of pages read from buffer pool for data scans/seeks.

    Any help would be greatly appreciated!

    Wednesday, February 22, 2017 5:21 PM

Answers

  • Thanks Shashank,

    I already use Reads & Writes column of trace in profiler. But I need Buffer Pool IO like a graph for each second :|

    There is no I/O as such for buffer pool you must node that if page is not present in buffer pool I/O request is raised and when it is acknowledged page is brought back into memory and this is actually I/O required and since page is always read in memory their is actually no buffer pool I/O it would be only disk I/O. Here is couple of Buffer Manager Object for your reference

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP


    Friday, February 24, 2017 9:00 AM

All replies

  • I guess the Statistics IO ON would give you that information. The output would be like

    Table 'ProductCostHistory'. Scan count 1, logical reads 5, physical   
    reads 0, read-ahead reads 0, lob logical reads 0, lob physical reads 0,   
    lob read-ahead reads 0

    If it is logical read it means read from buffer pool

    If it is physical it means I/O was issues to read page from disk into memory

    Read aheads are pages read in single scatter gather read to bring as much pages to avoid any physical read


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP


    Thursday, February 23, 2017 5:50 AM
  • Thanks Shashank,

    I already use Reads & Writes column of trace in profiler. But I need Buffer Pool IO like a graph for each second :|

    Friday, February 24, 2017 8:32 AM
  • Thanks Shashank,

    I already use Reads & Writes column of trace in profiler. But I need Buffer Pool IO like a graph for each second :|

    There is no I/O as such for buffer pool you must node that if page is not present in buffer pool I/O request is raised and when it is acknowledged page is brought back into memory and this is actually I/O required and since page is always read in memory their is actually no buffer pool I/O it would be only disk I/O. Here is couple of Buffer Manager Object for your reference

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP


    Friday, February 24, 2017 9:00 AM