Currently there isn't much for "real time" up to the minute monitoring for connections, sessions, and requests. I would like to see some enhancements to the active session page that contains a better view of the currently running processes.
Yeah. It's better if we can monitor with realtime.
I actually run the free Dell Spotlight Essentials on my servers in addition to DPA just so I can get some kind of real time view of what's going on. That adds a lot of overhead and just seems silly. It would be much better to add the functionality to DPA.
I used the dell spotlight too, but then switched to sql heartbeat. I definitely don't like all the overhead though of running something extra.