Monitoring

Database monitoring is possible by getting current dynamic statistics and configuration via sp_env() object.

To get per-thread backtrace see Scheduler,

To get per-database metrics see Database, Performance and Scheduler sections.