0

I've been getting some warnings about high utilization on our SQL Azure database server. What is the best way to monitor the utilization of that machine and try to analyze what is causing the high utilization spikes?

Improve this question

3 Answers 3

Reset to default
1

Log into the Azure management portal http://manage.windowsazure.com Select your SQL Database that you interested in getting details on. Select monitor Let’s say you want to monitor your DTU %. Click on that line item. Select ADD RULE Name the rule and describe it Specify who you want to receive the alerts.

This flow with screen shots can be found here: http://blogs.msdn.com/b/mschray/archive/2015/09/04/monitoring-your-sql-database-in-azure.aspx

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

1

sys.resouce_stats and sys.resource_usage can be used for monitoring the resource usage. Query store feature in SQL DB v12 helps you debugging the performance issues:

http://azure.microsoft.com/en-us/blog/query-store-a-flight-data-recorder-for-your-database/

Improve this answer

Comments

0

Using Dynamic Management Views
Azure SQL Database enables a subset of dynamic management views to diagnose performance problems
take look here DMV sql azure

Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.