View top queries, stored procs, top waits, index usage at estate level on Azure SQL
You can currently only view the top stats at DB level for Azure SQL. We run a multi-tenanted SaaS application where all DB's are identical across the estate, so to be able to compare offending stored procs, indexes etc. across the board would be incredibly helpful.
4
votes
Ben
shared this idea
-
Mark Freeman
commented
Ideally, enable setting up an Application and associating Databases with an Application, as we have multiple such Applications with many Databases for different regions or clients that have identical schemas for each Database associated with any given Application.
-
Mark Freeman
commented
This sounds challenging, as the execution plan could be different in each database.