question

JohnSterrett avatar image
JohnSterrett asked

How to collect active DTUs in Azure Database?

I know in the azure portal I can see active DTU and also DTU percentage. How could I obtain these counters via T-SQL or PowerShell? I am aware of sys.dm_resource_stats DMV but this just gives me utilization of resources.
azuresql azureazure-dtu
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

KenJ avatar image KenJ commented ·
I would love something like sys.dm_database_dtu_stats in both Azure and SQL Server itself so that on prem customers get instant sizing information for a potential migration.
1 Like 1 ·

1 Answer

·
JohnSterrett avatar image
JohnSterrett answered
Hi Everyone, I answered my question and wanted to share the answer here in case anyone else was curious how to put DTU with T-SQL. http://johnsterrett.com/2016/08/24/calculate-dtu-azure-sql-database/ Regards, John
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.