Page History
...
| Column | Description |
|---|---|
 | If the object that was changed is one of the entities in the Objects tab (Instance, Database, Table and Index), the Launch icon opens the Objects tab with the selected object, in-context. Also, if the change type is "Access Plan Changed" the icon will launch the Compare View with the specified access plan compared to the last access path, as detected by the "Explain Statements" process. |
| Date | Indicates the date the change was detected. Click on the link to switch to Plan view and display the first access plan that was created by the Explain Statements process after the specified change was detected. |
| Change Type | Displays the type of schema change detected. Can be one of the following values:
|
| Object | Indicates the object that was changed, for example, database, table, and index. |
| Details | Displays information about the change that was made. For example if the "Auto Shrink File" option was changed in the specified database the Details column will contain: "Auto Shrink File (From NO to YES). |
About viewing estimated access plan changes
The Estimated Access Plan Changes view displays a list of all the access plans of the statement as detected by the Explain Statement process.
...
Table 10-13 Estimated Access Plan Changes table
Column Description
...
| Column | Description |
|---|---|
 | Click on the tune icon to switch to Plan view and display the first access plan that was created by the Explain Statements process after the specified change was detected. |
 |
...
| The Launch and Compare icon opens the access plan in Compare view and enables you to compare the specified access plan with the last access plan, as detected by the "Explain Statements" process. |
| Date |
...
| Indicates the date the specified access plan was detected by the "Explain Statements" process. |
| Estimated |
...
| Cost | Indicates the estimated cost of the specified access plan. |
| Table |
...
| Scans | Displays the number of table scans performed in the specified access plan. |
| Index |
...
| Scans | Displays the number of index scans performed in the specified access plan. |
| Parallel |
...
| Displays the number of parallel operations performed in the specified access plan. |
| Nested |
...
| Loops | Displays the number of nested loops performed in the specified access plan. |
| Merge |
...
| Joins | Displays the number of merge joins performed in the specified access plan. |
| Hash |
...
| Joins | Displays the number of hash joins performed in the specified access plan. |
| Sorts |
...
| Displays the number of sort operations performed in the specified access plan. |
About viewing actual access plan changes
The Actual Access Plan Changes view displays a list of the execution plan of a batch that was actually used when the batch was executed. (SQL Server 2005 only).
...
Table 10-14 Actual Access Plan Changes table
| Column |
|---|
...
| Description |
|---|
...
|
...
| Click on the Tune icon to switch to Plan view and display the first access plan that was created by the Explain Statements process after the specified change was detected. |
|
...
| The Launch and Compare icon opens the access plan in Compare view and enables you to compare the specified access plan with the last access plan. |
| Date |
...
| Indicates the date the specified access plan was executed, as taken from system views. Click on the link to switch to Plan view and display the first access plan that was created by the Explain Statements process after the specified change was detected. |
| Estimated |
...
| Cost | Indicates the estimated cost of the specified access plan. |
| Table |
...
| Scans | Displays the number of table scans performed in the specified access plan. |
| Index |
...
| Scans | Displays the number of index scans performed in the specified access plan. |
...
| Parallel | Displays the number of parallel operations performed in the specified access plan. |
| Nested |
...
| Loops | Displays the number of nested loops performed in the specified access plan. |
| Merge |
...
| Joins | Displays the number of merge joins performed in the specified access plan. |
| Hash |
...
| Joins | Displays the number of hash joins performed in the specified access plan. |
| Sorts |
...
| Displays the number of sort operations performed in the specified access plan. |
About viewing instance parameters changes
The Instance Parameters Changes view displays a list of all the instance parameter changes detected by the Collect Schema Changes process.
...
Table 10-15 Instance parameters changes table
| Column |
|---|
...
| Description |
|---|
...
|
...
| The Launch icon opens the Objects tab with the selected instance. |
| Date |
...
| Indicates the date the change was detected. Click on the link to display the plan after the change occurred. Click on the link to switch to Plan view and display the first access plan that was created by the Explain Statements process after the specified change was detected. |
| Details |
...
| Displays additional information on the Instance Parameters change that was made, including the name of the parameter, and old and new values. |
The following parameter changes are displayed:
- Maximum recovery interval in minutes
- Number of locks for all users
- Number of open database objects
- Maximum worker threads
- Network packet size
- Memory for index create sorts (KB)
- Priority boost
- Minimum memory per query (KB)
- Query wait(s)
- Set working set size
- Affinity mask
- Cost threshold for parallelism
- Maximum degree of parallelism
- Minimum size of server memory (MB)
- Maximum size of server memory (MB)
- Maximum estimated cost of query allowed to run by query governor
- User mode scheduler uses lightweight pooling
About viewing database options changes
The Database Options Changes view displays a list of all the database changes detected by the Collect Schema Changes process
...
Table 10-16 Database options changes
| Column |
|---|
...
| Description |
|---|
...
|
...
| The Launch icon opens the Objects tab with the selected database. |
| Date |
...
| Indicates the date the change was detected. Click on the link to switch to Plan view and display the first access plan that was created by the Explain Statements process after the specified change was detected. |
| Database |
...
| Displays the name of the database in which the changes occurred. |
| Details |
...
| Provides additional information on the type of database change that was made, including the name of the database option, and the old and new values. |
The following database options changes are displayed:
- Recovery Model Changed
- Auto Update Statistics Changed
- Ansi Null Changed
- Auto Shrink File Changed
- Close Cursors On Commit Changed
- Status Changed
- Auto Create Statistics Changed
- Truncate Log Changed
- Compatibility Level Changed
About viewing volume changes
The Volume Changes view displays a list of all tables whose number of rows were increased by 1000, and whose size increased by 10%, and all indexes whose depth was changed.
...
Table 10-17 Volume changes table
| Column |
|---|
...
| Description |
|---|
...
|
...
| The Launch icon opens the Objects tab with the selected database. |
| Date |
...
| Indicates the date the change was detected. Click on the link to switch to Plan view and display the first access plan that was created by the Explain Statements process after the specified change was detected. |
| Object |
...
| Indicates the object that was changed. |
| Details |
...
| Displays information about the change that was made. |
Comparing access plans of a specified statement
The Compare view enables you to compare access plans of a specified statement. By default, the last access plan is displayed in the left pane. The access plan you want to compare it to is displayed in the right pane. The statement's text is displayed at the bottom of each access plan pane and the selected operator is highlighted.
The 
The Compare icon displays the list of execution plans available for a statement.
...