Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Reads/sec chart displays the number of physical reads per second the disk sub-system is performing to bring SQL Server database pages into the data (buffer) cache. If the reads rate is excessive for a long period of time, consider taking action to avoid performance issues.

...

Anchor
357549304
357549304
Writes chart (per second)

The Writes/sec chart  chart displays the number of physical database writes per second the disk sub-system is performing. If the writes rate is excessive for a long period of time, consider taking action to avoid performance issues.

...

There are circumstances under which the File Activity panel does not display any data. For example, when you lose connection to the Collection Service or SQL Diagnostic Manager Repository. Another reason is the lack of collection data points. On In new instances, file activity collection occurs once per hour by default. By increasing the length of time shown on the desktop client views, you may be able to see more data points. You can modify the timeframe of data displayed in SQL Diagnostic Manager by clicking Tools Image Added> Console Options while in the File Activity view and changing the Keep data for the last and Show data for the last values.

...

The File Activity panel displays results based on activity since the last refresh. You must have two collections to create a point on the graph, and three collections to create a line. By default, the database collection interval is set at one hour, which means that the File Activity panel does not show a point until an hour after adding the instance unless you perform a manual refresh. You can refresh and collect data by clicking the the  Refresh button in the SQL Diagnostic Manager Management Console menu bar.

...