Hi! I have windows Server 2003 with SP2 i have install SQL Server 2000 with SP4 it was working fine last few days back, but now i am getting SQL Server hang, all websites without SQL Server working fine but the website which using SQL Server not working also when trying to restart SQL server service its also not working checking from event logs there is nothing to show why it has hang, can someone help me in this netter.


Thanks


Tahir Atique

...

What does the task manager show SQL Server doing? What is the CPU usage? I mean what percent?

...

surprising there is NO over CPU usage RAM usage nothing shows in Task Manager :( but SQL Server not responding

...

Problem is that the list of possible problems is quite long. Have you got all fixes from Microsoft installed?

...

hmmm! i will try to do this.

Are you able to connect SQL server locally with management studio?

nothing shows in Task Manager :(
Do you mean no process shows up in task manager? I would worry if that's the case.

YES but now its panic condition to us SQL server hanged on daily basis. while all static websites and other things working fine.

...

Okay, now I am wondering about a few things!

I took "nothing" in that earlier response to mean nothing of importance, because if the system is running in any form and the Task Manager itself is running then I don't see how it's possible that no processes are showing in Task Manager. I've never heard of that. Of course, I don't know it all, so I'm ready to learn.

As for this bit about panic, let's be cool okay. When troubleshooting, panic is the worst thing to do.

I would like an answer to the question of whether all your Microsoft fixes are up-to-date? That has to be one of the first steps in the step-by-step process to figure out what's going on.

The next thing is to please provide some detail as to what exactly is happening. You know, like at what point does the system hang? Does it always hang at that same point?

Forget that panic business, please. It just ain't gonna help.

By the way, I completely agree that if there are zero processes showing in the Task Manager, that's really, really strange.

...

Dear Friend,

Thank you for your reply and advice we have investigate deeply and fund that a query which cause CPU over load that why SQL Server hang, we did not fund anything in task manage because when we go to investigate at task manage SQL Server was hang and our server working smoothly thats why was unable to troubleshoot, now are checking our query in last Thanks for your all prompt replies.

Thanks

Tahir Atique

I think you need a databasase administrator to log on the server and troubleshoot the issue.
Asking for advice/suggestion like this is not gonna help.

ask your database administrator to checkout for this issue

Dear All,

Thank you for your replies, we have found the actual problem and ask our DB Admin to resolve this.

Thanks

Tahir Atique

We have removed Problem database but my SQL Server is not working properly, it stoped responding we got given error when trying to open SQL server with management console Error 1069

I would try SQL Server 2008 for 2008 for now.