Hi, 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 cache2. Page is read/write beacause of big sort operation3. Page is read/write from temp object bigger then memory buffer e.g big global temporary table, others?
Regards,Karol Bieniaszewsli Wysłano z mojego smartfonu w PLAY
