The postings on this site are my own and do not represent my Employer's positions, advice or strategies.

LifeAsBob - Blog

  DateTime Here

Performance Dashboard Azure SQL PAAS

Performance Dashboard does not work with Azure SQL (PAAS).

But yes with some slight modifications you can make it work, I've extracted, updated, re-written all the msdb queries into new queries.  Some functionality does not directly translate between on-prem SQL / IAAS SQL / Managed Instance to Azure PAAS, so some stuff you have to drop.

I will post an update of how I run and the queries and the new RDL Files for PAAS Soon.

Also you want to ADD NEW STUFF.

  • Elastic Pools
  • DTU's
  • Deadlocks
  • Is automatic Tuning, Force Plans Enabled
  • What limits have you reached if any in the past 24 hours
  • Enhance to use query store
  • Show count of number of forced plans

 


Blog Home