Loading SQL Statements from the Cursor Cache

You can load SQL statements from the cursor cache into the SQL Tuning Set. However, because only current and recent SQL statements are in the SQL cache, collecting these statements only once may result in a SQL Tuning Set this is not representative of the entire database workload.

To load SQL statements from the cursor cache: 

1. On the Create SQL Tuning Set: Load Methods page, select Load SQL statements one time only.

2. From the Data Source list, select Cursor Cache.

3. Click Next.

   The Create SQL Tuning Set: Filter Options page is shown.

4. Proceed to the next step, as described in "Creating a SQL Tuning Set: Filter Options".