Send weekly SQL Server health reports via email

Description

This workflow runs every Monday morning and automatically diagnoses the health of your SQL Server database across 4 dimensions — slow queries, missing indexes, index fragmentation, and server wait stats. It merges all results, scores each finding by severity, and sends a beautifully formatted HTML email report only when issues are found. Zero noise when everything is healthy.

Who it's for

SQL Server developers, DBAs, and backend engineers who manage production MSSQL databases and want weekly automated diagnostics delivered to their inbox — without manual querying or third-party monitoring tools.

How it works:

1. Schedule Trigger fires every Monday at 7 AM.

2. 4 SQL nodes run in parallel — slow queries, missing indexes, index fragmentation, wait stats.

3. Merge node combines all results into a single stream.