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 |
|
TonyTheDBA
Posting Yak Master
121 Posts |
 Posted - 2006-10-20 : 08:22:28
|
| Here is a funny one that has got me puzzled . . . And the suppliers come to that.We have a bespoke CRM solution that has a SQL Server db at the backend. I had a query from one of the admin users asking if there was a problem with the server, so being lazy I opened up current activity/process info in EM . . . Or rather attempted to all I got was an hour glass . . . . . and thats where it stayed. In the end I had to kill EM using task manager. Checked this in the test server and it worked fine, so its something on this box, and it appears that if you try and access tempdb the same thing happens.I really can't even begin to work out what has happened, ane even a reboot (Which copies model to tempdb replacing tempdb) doesn't fix the problem.-- RegardsTony The DBA |
|
|
TonyTheDBA
Posting Yak Master
121 Posts |
Posted - 2006-10-20 : 08:32:29
|
| Oh If I use SQL Management Studio, Everything Works OK . . . Go Figure-- RegardsTony The DBA |
 |
|
|
Luis Martin
Yak Posting Veteran
54 Posts |
Posted - 2006-10-20 : 18:05:08
|
| EM is the not good because gui. Use QA instead.All in Love is Fair Stevie Wonder |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-20 : 18:19:58
|
| Neither QA, EM, or Management Studio was the culprit of your problem. EM hanging is a symptom of a lot of locking going on which causes the Current Activity window to take quite a bit of time to come up. If you were to check out sp_who/sp_who2/sp_lock, you'd see just how bad it was during that time. Eventually, EM would have displayed the data. But it definitely wasn't the culprit of your problem. How do I know? Well, let's just say through a lot of experience at my last job.Tara Kizer |
|
|
|
TonyTheDBA
Posting Yak Master
121 Posts |
Posted - 2006-10-23 : 06:53:37
|
| Thanks Tara,Yeah I had noticed that there were a lot of locks being held . . . . In fact one of the problems that we have is that for some reason a lock gets held and not realeased . . . The suppliers have been unable to determine the cause . . . . I've tried leaving Profiler open and logging to see whats going on but no luck as its really intermittant. Still this is where we earn our money :)-- RegardsTony The DBA |
|
|
|
|
|
|
Accessing tempdb Hangs EM