SSMS 19.0.2 Active Monitor Always Pause

Xiaogang Zheng 0 Reputation points
2023-05-26T15:28:29.91+00:00

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?

Thanks,

Xiaogang

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,150 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.
111 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,446 Reputation points Microsoft Vendor
    2023-05-29T02:29:50.1766667+00:00

    Hi @Xiaogang Zheng

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

    https://stackoverflow.com/questions/51823868/activity-monitor-always-paused-in-ssms-17-8-1

    Best regards,

    Aniya


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.