Page History
...
Column | Description |
---|---|
What to do next | In the SQL tab, examine the information displayed in the History tab to identify object changes and correlate these changes to performance degradation. |
Advice | Several changes may effect In MS-SQL time and may effect other statements In MS-SQL as well. Changes such as index creation/drop can cause access plan changes that can effect statement performance. Do the following:
|
...
Column | Description |
---|---|
What to do next | Perform one of the following options:
|
Advice | The following scenarios indicate which factors can lead to heavy resource consumption and what steps you can take:
|
...
Column | Description |
---|---|
What to do next | Examine the storage devices statistics and hit radio. |
Advice |
|
...