SSMS 19.0.2 Active Monitor Always Pause

Xiaogang Zheng 0 Reputation points

I think it is not related to SSMS version (I used 17.9.1, 18.0.x ~18.12.1 etc). And now I am using SSMS 19.0.2. The Active Monitor always pause after it refresh even though I resume many times.

And I find out the Overview works fine if I don't expend the Processes window. Expend "Active Expensive Queries" works fine after I resume the paused monitoring.

I think SSMS still has bug to retrieve the processes information if there are too many

processes and make it timeout. Event though I set the "Refresh Interval" to longer time.

Is there any work around to see the latest Processes on SSMS?



SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
9,813 questions
Windows Performance Toolkit
Windows Performance Toolkit
A collection of Microsoft performance monitoring tools that produce in-depth performance profiles of Windows operating systems and applications.
45 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 5,551 Reputation points Microsoft Vendor

    Hi @Xiaogang Zheng

    I found a similar thread, maybe you can use it as a reference.

    Best regards,