I am tired of a really annoying problem! If I use "activity monitor" in SSMS and the server is under heavy pressure, there is a Popup window with information about "timeout expired" that is placed in the backround. The popup window prevents me from working with the SSMS server (even minimize, maximize etc), and I cannot get focus on the popup window, unless i can get the SSMS window moved, and that is not an easy task with a window that cannot get focus. In worst case I have to close the window and hope everything is saved.
Anyone with a solution to this?
Answer by Laerte Junior ·
If your server is under pressure, I believe activity monitor in SSMS only will use more resource because the graphical interface. You can connect BY DAC and examine the wait stats to get an idea of the overall consumption of resources. Will have an idea of what is consuming more and move on to the more refined analysis. Good reading from Jimmy´s May Blog
Answer by sp_lock ·
Not sure why the popup goes to the back (have you tried ALT - TAB to try and bring the focus to the front?).
In addition to Activity Mon, have you tried sp_who2? Returns similar results.
This time out is normal (IMO) if SQL Server can not process the request within the time-out limit due to high demand?
You may want to trace the issue using profiler or using DBCC TRACEON