Live Query Profiling allows for the capture and replay of live query execution data. To enable the collection of live query data, select the arrow next to Get Actual Plan, and then select With Live Query Profile. When this setting is enabled, live query execution data is captured along with the actual plan. Plan Explorer adds the benefit of being able to replay a live query. This replay data saves as part of the Plan Explorer session file.
- Default Actual Plan Collection Mode—Allows you to choose between getting only an actual plan or getting the actual plan and live profile by default.
- Live Profile Data Collection Interval—Determines how often live query data is collected. The minimum value is 100 ms.
For more information about this feature, see the Plan Explorer Update Just in "Time" for the New Year blog post.
Note: A minimum of SQL Server 2014 SP1 is required to collect live query profile data.