Page History
The File Activity panel displays the top five database files with the highest relative activity since the last refresh. Available metrics allow you to view the top Reads/sec, Writes/sec, and Transfers/sec activity for all files or a selected database, disk, or file. Unexpected spikes in the amount of file activity may warn you of ineffective or excessive indexing or out-of-date statistics. For additional information, see View file activity.
| Anchor | ||||
|---|---|---|---|---|
|
...
You also can change the database collection interval and grooming options to help you see more data points. Use the Collect and alert on database metrics field in the General tab of the Monitored SQL Server Properties window to manage your database collection. For grooming options, use the Groom Sessions, Queries, Deadlocks, Waits, and History Browser data older than field in the Grooming Options window.
| Tip |
|---|
Decreasing the collection interval and grooming your data less often can result in performance issues and require additional storage space in your Repository. |
...