Export (0) Print
Expand All
Expand Minimize
6 out of 6 rated this helpful - Rate this topic

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.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.