Analyze SQL Server health – with historical capability
SQL Server CPU , RAM , Memory usage and Top Query behind it
SQL Server performance metric ,Storage Usage & Capacity Analysis
As there are lot of limitations (unavailable) if you wish to generate Azure SQL DB or PAAS SQL DB performance report. Gone are those days, SQL Planner provides several health insight, Performance reports, Root-cause along with 20+ alerts on SQL PAAS DB as below : One Graph to explain following : 1. DTU (avg cpu …
Steps to create : Click On Menu > Create Alert Health Analysis Job , you would see screen similar to below image , this is the setting that must be defined to receive alert and see specific SQL server health analytic report. It simply run set of T-SQL command (based on SQL Server DMV and …