Subject Detecting disk operations
Author liviuslivius

Is there a way to detect throught mon$ tables or trace or other way disk operations caused by query? I see only page_reads and page_writes, page_marks, page_fetches but how to distinguish which one:
1. Page is read because missed in cache
2. Page is read/write beacause of big sort operation
3. Page is read/write from temp object bigger then memory buffer e.g big global temporary table, others?

Karol Bieniaszewsli

Wysłano z mojego smartfonu w PLAY