Monitoring SQL Azure Using Dynamic Management Views

  • Article

Microsoft SQL Azure Database enables a subset of dynamic management views to diagnose the performance problems, which might be caused by blocked or long-running queries, resource bottlenecks, poor query plans, and so on. This topic provides information on how to detect common performance problems by using the dynamic management views in SQL Azure.

SQL Azure partially supports three categories of dynamic management views:

  • Database-related dynamic management views.
  • Execution-related dynamic management views.
  • Transaction-related dynamic management views.

Link: https://msdn.microsoft.com/en-us/library/ff394114(v=MSDN.10).aspx