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, 2009 at 04:37 AM in Default

avatar image

Håkan Winther
16.5k 36 45 57

(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, 2009 at 06:05 AM

avatar image

Laerte Junior
488 2 4

(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, 2009 at 05:50 AM

avatar image

sp_lock
10.5k 27 37 37

(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.

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:

x2076
x152
x20

asked: Oct 30, 2009 at 04:37 AM

Seen: 2482 times

Last Updated: Jan 28, 2010 at 10:06 PM

Copyright 2016 Redgate Software. Privacy Policy