The History section view is divided into two sections that are correlated to each other:
Time spent waiting for in memory log and checkpoint related events. | |
Time spent waiting for events related to natively compiled stored procedures. | |
The total number of transactions that have run in the In Memory OLTP database engine. | |
Total number of megabytes written to the In Memory OLTP log records. | |
The number of conflicts between transactions while writing a row which lead to aborts. | |
Total number of transactions that require log IO. Only considers transactions on durable tables. | |
The number of times a transaction aborts because a transaction on which it was dependent aborts. | |
The number of times a transaction has aborted due to a validation failure. | |
The total number of transactions that were aborted, either through user or system abort. |
Addition and deletion of login accounts.
Track changes to sp_configure settings, and DBCC trace flags.
There are two ways to access the Execution Plan History dialog:
The execution plan dashboard displays the following content.
Date — Displays all the execution date and time of the selected statement\batch
Type — Displays the type of the execution plan.
Plan handle — Displays the SQL handle on the execution plan.
By pressing the Generate Plan button the execution plan is generated and can be viewed by clicking on Compare Plan. This opens a pop up with a compression of all available execution plans of the selected statement.
Provides the same view as without SQL PI configured. See Blocking History .
Provides the same view as without SQL PI configured. See Viewing SQL Statement Details .
© ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center