1

Activity Monitor can show real time the overall IO performance in MBytes/s on a server, but cannot show the same per session level.

I know about DMVs, and sp_who2 to retrieve session level io consumption , but there, its only the number of reads/writes can be extracted, not the actual Megabytes/s.

How can I see real time, session level io performance in MBytes/s?

1

You can use either a Profiler trace or sp_whoisactive to get the number of reads per session. Reads are the number of logical disk reads in 8KB pages, so if the number of reads is 2, for example, that might equate to 16KB of disk I/O.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.