Drilldown on current and recent activity.
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.
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.)
You can copy SQL text from the SQL Statement page. Right click and select 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.
When in Playback, history will not be displayed for SQL Azure database information. For more information, see Playback.
TIP: For general information on how to use Spotlight grids, see Spotlight grids