Obtaining MB/Sec for Buffer Pool

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!

Answer 1

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

Answer 2

Thanks Shashank,

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

Answer 3

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