Microsoft SQL Server 2014 Unleashed

Verifying That a Plan Guide Is Being Applied

When you have a plan guide defined, you might want to verify that the application query is making use of the plan guide. You can follow these steps to confirm whether a plan guide is being used:

1. After creating the plan guide, run SQL Server Profiler and configure it to capture the query text and XML execution plan for the application and the query in question and start the Profiler trace.

2. Run your application and cause it to invoke the query in question.

3. Stop the Profiler trace and collect the query plan by right-clicking the Showplan XML Statistics Profile event that corresponds to the query and then selecting the Extract Event Data option.

4. Save the event data to a file.

5. Open the