Windows Azure SQL Database Metrics REST API

Question

Hi everyone,

    If Any possible to get  Windows Azure SQL Database  Metrics like deadlocks, failed connections, successful connections through REST API.

Answer 1

Hello,

As per my understand, the SQL Database Management API is used for managing SQL Database servers.

If you want to tracking and troubleshooting Windows Azure SQL Database activity, you can use dynamic management views (DMV)  which record database connectivity-related events, including successful, failed, and terminated connections; throttling; and deadlocks. For example, sys.database_connection_stats and sys.event_log.

Reference:http://msdn.microsoft.com/en-us/library/windowsazure/ee730906.aspx

Regards,
Fanny Liu

If you have any feedback on our support, please click here.

---

Fanny Liu
TechNet Community Support

Answer 2

Hi Priya,

As fanny told you can use dynamic management views (DMV). Also check these helpful links.

http://blogs.msdn.com/b/wayneb/archive/2012/11/02/introducing-sys-database-connection-stats-for-troubleshooting-windows-azure-sql-database.aspx

Best Practices(Troubleshooting): http://www.windowsazure.com/en-us/develop/net/best-practices/troubleshooting/ 

---

Do not Forget to Vote as Answer/Helpful, please. It encourages us to help you.