Databases Reference
In-Depth Information
Viewing Live Data
This example uses the session created earlier, which captures login events after ensuring it's started.
After right-clicking on the session in SQL Server Management Studio, click the Watch Live Data
option, as shown in Figure 13-20.
This opens a new tab in SQL Server Management Studio that says “Retrieving event informa-
tion from server. . .” and then you will begin seeing events as they are captured. Connecting to the
instance from another PC caused the events shown in Figure 13-21.
FIGURE 13-20
FIGURE 13-21
The output screen is divided into two parts, which are identii ed with boxes in the screenshot. The top
box displays a list of all the events that have been captured — in this example, several login events.
The bottom box shows the event and global i elds captured for the event selected in the top box.
However, more information can be displayed in the top box if you'd rather see more i elds when
events are being captured. You can customize the view by right-clicking on the column bar at the top
of the events and selecting Choose Columns (see Figure 13-22). The Choose Columns dialog will then
appear (see Figure 13-23).
FIGURE 13-23
FIGURE 13-22
Search WWH ::
Custom Search