Monitoring

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

Performance metrics are described in the Performance configuration section.

To get current memory usage or trace every worker thread see Memory, Performance and Scheduler sections.

To get per-database metrics see Database sections.