Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nemohm
Yak Posting Veteran
69 Posts |
 Posted - 2003-05-29 : 11:38:17
|
| Hi Everybody,SQL Server Enterprise Manager Not Responding (this is the Task Manager info)SQL S 2k, W2k serverPeriodically EM gets slow and slow, to open something on the tree takes minutes.Finally EM doesn't respond at all!This is a development machine and only thing that helps so far is to reimage (ghost) the machine.Is there any other way to deal with degraded performance; Is it possible a partial reinstallation of EM only?Thx,Dobby |
|
|
Shastryv
Posting Yak Master
145 Posts |
Posted - 2003-05-29 : 12:36:21
|
| There could be several reasons for this. The one I encounter most is that if you have any problem with your IE installed on the server and if your database VIEW is set to TASK PAD you might want to check it to some thing else. Also open the Task manager and see is there any application is taking heavy resources. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-29 : 12:43:58
|
| When Enterprise Manager slow down or stops responding, what is it that it was doing? Was it opening large record sets? EM is resource intensive and should be used minimally, all SELECTs, INSERTs, UPDATEs, and DELETEs should be done in Query Analyzer. EM is a very handy tool because it allows you to get information quickly, but it is not designed to perform all that great. To figure out this problem so that you don't have to reimage the machine, you need to figure out what EM is doing when it occurs. I seldom have any problems with EM because I don't use it for DML.Tara |
|
|
|
|
|
|
SQL Server Enterprise Manager Not Responding