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.