Heres an interesting question that came up in our IEPTO1 class in Chicago this week (paraphrasing): I was doing a demo recently where I was demonstrating physical I/Os occurring. I used DBCC DROPCLEANBUFFERS, then enabled SET STATISTICS IO ON and performed a SELECT operation. I was expecting to see physical reads occurring but I only saw logical [&]

The post When DBCC DROPCLEANBUFFERS doesnt work& appeared first on Paul S. Randal.

http://feedproxy.google.com/~r/PaulSRandal/~3/Y6UxGqmx6B0/