Product has been added to your cart.

Bonus – Managed Instance DTUs (4m)

Azure SQL DB and Azure Managed Instances have a killer edge over regular SQL Server: they make performance troubleshooting way easier. You don’t have to guess whether you’re hitting a limit on your CPU, disk, memory, etc – you can simply query sys.dm_db_resource_stats and see if Microsoft is throttling your database. Demo script: Transact-SQL /* Palate…

To access this incredible, amazing content, you gotta get Recorded Class Season Pass, or log in if you already shelled out the cash.

  1. Home
  3. SQL Server Training Classes by Brent Ozar
  5. Performance Tuning in 21 Demos
  7. Bonus – Managed Instance DTUs (4m)
Azure SQL DB and Azure Managed Instances have a killer edge over regular SQL Server: they make performance troubleshooting way easier. You don’t have to guess whether you’re hitting a limit on your CPU, disk, memory, etc – you can simply query sys.dm_db_resource_stats and see if Microsoft is throttling your database. Demo script: Transact-SQL /* Palate...
To access this incredible, amazing content, you gotta get Recorded Class Season Pass, or log in if you already shelled out the cash.