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 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?

Regards,

Karol Bieniaszewsli