Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
How to: Set the Activity Monitor Refresh Interval
Collapse the table of content
Expand the table of content

How to: Set the Activity Monitor Refresh Interval

Setting the refresh interval for Activity Monitor configures how often Activity Monitor obtains new information about instance activity. Activity Monitor runs queries on the monitored instance to obtain information for the Activity Monitor display panes. When the refresh interval is set to less than 10 seconds, the time that is used to run these queries can affect server performance.

To set the refresh interval

  1. Open Activity Monitor. For more information, see How to: Open Activity Monitor (SQL Server Management Studio).

  2. Right-click Overview, select Refresh Interval, and then select the interval in which Activity Monitor should obtain new instance information.

Community Additions

© 2015 Microsoft