x

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.

more ▼

asked May 05, 2016 at 06:49 PM in Default

avatar image

JohnSterrett
1.3k 2 6

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.

May 05, 2016 at 09:14 PM KenJ
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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

more ▼

answered Aug 24, 2016 at 08:35 PM

avatar image

JohnSterrett
1.3k 2 6

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x16
x1
x1

asked: May 05, 2016 at 06:49 PM

Seen: 181 times

Last Updated: Aug 24, 2016 at 08:35 PM

Copyright 2017 Redgate Software. Privacy Policy