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

LifeAsBob - Blog



No Ads ever, except search!
Monday, May 27, 2024 Login

Blog posts for the month of March,2020.
Faith Calf 20203/2/2020 10:00:12 AM

Faith's Calf 2020


Performance Dashboard Azure SQL PAAS2/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