x

Timeout Expire Window placed in backround...

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?

more ▼

asked Oct 30 '09 at 04:37 AM in Default

Håkan Winther gravatar image

Håkan Winther
15.5k 33 37 48

(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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

Wait Stats by Joe Sack

more ▼

answered Oct 30 '09 at 06:05 AM

Laerte Junior gravatar image

Laerte Junior
488 2

My problem is that IF i use activity monitor, the SSMS will not be accessible due to the modal window in the backround. And yes, i can get the most of the information from other resources, but activity monitor gives you a lot very quick.
Oct 30 '09 at 08:52 AM Håkan Winther
Well I do not like to use graphical interface in "normal" server .. under pressure worst (but its is for me). If this case is for the windows and graphical user interface , that unfortunately I can not give a correct answer because I do not use activity monitor graphical interface..Im sorry, I think I do not understand the question !!!
Oct 30 '09 at 09:48 AM Laerte Junior
(comments are locked)
10|1200 characters needed characters left

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

more ▼

answered Oct 30 '09 at 05:50 AM

sp_lock gravatar image

sp_lock
9k 24 27 30

I have tried ALT-TAB, minimize, maximize, show desktop, etc, without success. Sometimes i use sp_who2, but when Activtiy monitor in SQL 2008 gives you a lot more information, and yes, I can get the same info by using the dynamic management views.
Oct 30 '09 at 08:48 AM Håkan Winther
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1816
x123
x18

asked: Oct 30 '09 at 04:37 AM

Seen: 2037 times

Last Updated: Jan 28 '10 at 10:06 PM