Structure

Stored Procedures

usp_sqlwatch_config_*

Configuration helpers to help apply relevant, and optional, configuration to SQL Server Instance. To be run by the user on demand, not scheduled.

usp_sqlwatch_internal_*

Procedures used internally by SQLWATCH.

usp_sqlwatch_logger_*

Data Collectors scheduled by the Agent Jobs.

usp_sqlwatch_report_*

Interface procedures generating standardised report data, currently used by Power BI but can be used by any other reporting tool. As of version 2.0 they are being written and expanded. Not all metrics are covered yet.