Answered by:
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.
Thursday, September 5, 2013 8:43 AM
Answers
-
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 LiuIf you have any feedback on our support, please click here.
Fanny Liu
TechNet Community Support- Marked as answer by Fanny Liu Thursday, September 12, 2013 8:25 AM
Friday, September 6, 2013 8:49 AM -
Hi Priya,
As fanny told you can use dynamic management views (DMV). Also check these helpful links.
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.
- Marked as answer by Fanny Liu Thursday, September 12, 2013 8:25 AM
Friday, September 6, 2013 9:00 AM
All replies
-
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 LiuIf you have any feedback on our support, please click here.
Fanny Liu
TechNet Community Support- Marked as answer by Fanny Liu Thursday, September 12, 2013 8:25 AM
Friday, September 6, 2013 8:49 AM -
Hi Priya,
As fanny told you can use dynamic management views (DMV). Also check these helpful links.
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.
- Marked as answer by Fanny Liu Thursday, September 12, 2013 8:25 AM
Friday, September 6, 2013 9:00 AM