June 2015
Intermediate to advanced
1800 pages
70h 6m
English
Filters restrict the event data returned in your trace output. You can filter the events captured by the SQL Server Profiler via the Column Filters button on the Events Selection tab. An example of the Edit Filter window is shown in Figure 5.8. All the available columns for the trace are shown on the left side of the Edit Filter window. Those columns that have filters on them have a filter icon displayed next to the column in the column list.
FIGURE 5.8 Editing filter properties.
The filtering options in SQL Server 2014 are similar to those available in prior versions. Which options are available depends on the type of column you are ...
Read now
Unlock full access