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

LifeAsBob - Blog

 

Home

No Ads ever, except search!
Tuesday, March 19, 2024 Login
Public

Performance Dashboard Azure SQL PAAS 2/17/2020 9:48:49 AM

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