EM Freezing Up

Question

EM Freezing Up

Denis Wilkinson

Mr or Mrs. 500

Points: 569
More actions
August 2, 2004 at 4:41 am

#161294

Hi,
We have have a situation in SQL2000 where Enterprise Manager freezes up, or appears to. We have a number of databases on the same instance of SQL2000 which interface to a number of in-house Intranet applications mainly based on HTML/JavaScript (IE6). One of the applications freezes when retrieving a dataset, on trying to view the associated database table by clicking on tables (in EM) the hourglass sets and EM freezes. When the application in IE freezes I have tried to view the current activity to see if there are any locks, but the same result, the hourglass and EM freezes. We have been getting around it by restarting the instance of SQL, but there is something underlying that still needs solving. The server logs give no clues or indications.
Has anyone had a similar experience and what can I look for...

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 1

When EM freezes and/or the intranet application try and have one of the network/system engineers look at the server CPU's, memory and bandwidth usage. It may not be "freezing" but rather using up all its resources....

Good Hunting!

AJ Ahrens

webmaster@kritter.net

Steve Jones - SSC Editor SSC Guru Points: 736568 More actions · Answer 2

There are some times when EM is performing some actions, like reindex, etc. where it will freeze until the action is complete. I've seen this happen when connecting to a server if the communication gets interrupted somehow. When does it freeze? Always? How are you viewing the table?

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 3

Agreed. You may want to do some performance monitoring of the SQL Server to see if it is freezing like that. If it's not a processor/memory limitation, it may be another process/object is causing a hang. You can use something like Process Explorer from SysInternals to see what the SQL Server is waiting on. You'd have to run it on the server through Terminal Services or something.

Process Explorer from SysInternals

K. Brian Kelley
@kbriankelley

jack-64275 SSCrazy Points: 2017 More actions · Answer 4

have you tried to run sp_who2 or select * from sysprocesses in QA to see if there is any blocking?

Denis Wilkinson Mr or Mrs. 500 Points: 569 More actions · Answer 5

We have been monitoring it and have found it is a blocking issue. When it started happening last week we could not even open the Current Activity section of EM it was that frozen. I have narrowed it down to a particular stored procedure, although it has been running for the past 8 months with no problem...? It sometimes does it every time and at others not at all, so there must be something else that is causing it to block. We have checked the CPU and memory usage and they are all well under control.

thanks everyone for all the pointers.