Azure SQL DB

service tier;
CPU, RAM, Buffer & Proc caches, PLE, non-default DB settings, missing indexes and trace flags enabled;
connections and blocked ones;
existing ExtendedEvents sessions;
Consumption of resources for the last 60 mins;
DB wait stats;
User DB & tempdb sizes and last backups;
Access information + roles and rights;
Active sessions consuming tempdb;

Report: Sessions

This report shows list of sessions the sessions, connected to the database.

Besides connection info it highlights running and blocked sessions, text of queries running, link to subreport with execution plan (XML format) and previously executed query.

Report: MemoryMap

This report shows SQL server memory breakdown among memory consumers.

Despite it's hidden and we have no control over it in case of Azure SQL DB, it can be useful in case of troubleshooting memory related issues like cache pollution or similar.

Also, it helps to get understanding how large is buffer pool and is it enough for the database, for example.

Disclaimer: underlying SQL script was developed by mr.Mind (sql.ru) and used with his kind permission. Thanks, mate! :)

Report: BufferObjects

This report shows db objects & their sizes, which are Buffer cache now.

It helps to realise what's the current most popular table and/or index and what part of Buffer cache it occupies now.

Report: ExecutionPlan

This report shows Execution Plans in procedure cache grouped by type, date and hour of creation.

It helps with issues related to procedure cache and its analysis.

Report: Azure_Master

Main report for the master database

Shows the following for the today:

user databases hosted;
service tier and pool name;
creation date;
geo-replica enabled or not;
connectivity issues happened;
link to historical information (last 14 days);
CPU, I/O and storage usage.

Google Sites

Report abuse