The SQL Activity drilldown shows both current and recent activity details for the SQL Azure database you are diagnosing.
To see the SQL Activity drilldown
Click Monitor | SQL Activity.
To investigate...
Look at the...
SQL sessions including session details and locks
Sessions page
Shows all SQL Azure sessions, each row representing a single session. Note that many applications create multiple connections to SQL Azure.
Tips:
- Some columns may be hidden by default. To view them, right-click the grid headings and select Organize Columns.
- You can view more details for a session by clicking it in this grid. Additional pages are then displayed in the lower half of the drilldown.
- To find a particular session, right-click and select Find.
Shows the batch of SQL statements last executed or currently executing by the selected session.)
Tip: You can copy SQL text from the SQL Statement page by right-clicking and selecting the appropriate option from the shortcut menu.
Shows the query execution plan for the selected session in XML.
Click View Plan to open the plan in SQL Server Management Studio (if installed) and view the query execution plan in graphical format
Shows all locks held or requested by the selected session.
If a lock is one on which this session is waiting, the Status column will show it as being blocked. This column also highlights locks that are blocking other sessions.
Note: When in Playback (Playback (page 1)), history will not be displayed for SQL Azure database information.
Sessions grid