Page History
...
| Info |
|---|
If the Precise for SQL Server Collector is down, the instance availability status reported is "Unknown.". |
| Anchor | ||||
|---|---|---|---|---|
|
...
The Activity tab can also be referred to when planing planning your system's capacity, performing period-to-period comparisons, and determining how best to optimize storage. Use the Activity tab to examine resource consumption of your SQL Server instance, over time, as well as the resource consumption of your databases, programs, logins, and so on. You can also identify dominant resource consumption by selecting the Overview view.
...
As you can see schema changes, volume changes, and database option changes, were made to objects referred by this statement. By examining the time the changes were reported and when the statement's performance began to deteriorate, you can locate the changes that may have been the cause of the degradation in statement performance. In the Association area you can view additional details regarding the changes and you can launch from a specific change to another tab to further your investigation. (For example: by clicking on the “Launch icon” Launch icon of “Instance Instance parameter changes” Changes you will launch to Object tab while displaying the Instance Parameters Changes” Changes in the Main Area.
About recommending indexes for an SQL statement
...