Collect and Analyze SQL Server Trace Data

Predefined templates

Pick one of the templates based on your past interactions.

• Choose Standard if you want to go with the default settings and catch the biggest amount of events
• Four categories of templates for each need: Locks and Blocks, Query Execution, System Monitoring, and Trace System
• Keep track of all the previous actions, stored procedures, and T-SQL batches from your past sessions

Events to capture

Pick the range of events you would like to capture and choose between the common event parameters:

• Analytic, Debug, Operational, and Admin action types for your database
• Over 120 events in Alwayson category
• More than 130 Execution-related events to display in a session
• Over a hundred of events to choose in General segment
• Warning, Transactions, Tracing, and tens of other event groups at your disposal

Actions

Select the actions needed to be captured in the next event session.

• Tens of global fields to check up for every displayable action
• Description for the actions in the list
• Search field and reset options
• Choose to collect IDs, hashes, names, time frames in a clean UI
• Create mini dumps for either all threads or the current thread
• Identification of queries with similar logic and execution plans

Event filters

Specify which events should or shouldn't be in your next event session. There is Event, Source, Comparator, and Pattern columns with numerous options to choose from.

Choose 'All' Operators for the bigger range or go with any particular option:

• NOT
• AND
• OR
• AND NOT
• OR NOT

Profile parameters

Select the columns you want to capture in the current event session.

• Pick all the columns at once or choose one by one in both directions
• Search and reset functions
• Order columns manually depending on their importance

• Existing Connection
• Login
• Logout
• RPC Completed
• SQL Batch Completed
• SQL Batch Starting

Server Profile document

• Adjust the size of each row
• Filter the results by such parameters as name, timestamp, duration, etc.
• Choose the event name to display among the list or use a custom one
• See all the event details in the lower box
• Extract Event SQL statement to a new SQL Window or to Clipboard
• Look through Global Fields and Event Fields details
• Treeview Database Explorer for convenient navigation