Menu
We're getting spikes from time to time but can't find what causes it.
408
View your Azure Monitor metrics for all connected resources by going to the Azure Monitor page directly in the Azure portal. Or, on the Overview page of an Azure SQL DB, select Metrics under the Monitoring heading to reach Azure Monitor.
Upload the CSV file(s) and Calculate Once the script completes for each one of your databases or your SQL Server, enter the number of cores for your server, and upload the CSV file generated by the script. Click the Calculate button to view your recommended Service Tier/Performance Level and DTUs.
For example, a performance level with 5 DTUs has five times more power than a performance level with 1 DTU. A maximum DTU quota applies to each server. The DTU Quota applies to the server, not the individual databases and each server has a maximum of 1600 DTUs.
The following will show you a log of the 100 most recent DTU logs. As of now, a log entry is created every 15 seconds.
SELECT TOP 100 *
FROM sys.dm_db_resource_stats
ORDER BY end_time DESC
Please have a check on the below links which talks about Azure SQL Database Throughput Unit (DTU).
http://azure.microsoft.com/blog/2014/09/11/azure-sql-database-introduces-new-near-real-time-performance-metrics/
Azure SQL Database "DTU percentage" metric
http://msdn.microsoft.com/en-us/library/azure/dn741336.aspx
Regards, Mekh.
40
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
