October 18, 2007 at 5:04 am
[font="Courier New"]Hi,
Today our production server was hanged cos.....the number of current users was increasing and it was around 300+, but in normal case the number of users are around 30-35, I open the server through VNC and then tried to connect it through enterpirse manager and query analyzer but it gave network error it was something like
"Microsoft SQL server network error : check your network document"
I was physically working on the production server. I checked the services all were running fine I tried it for 10 mins but when I failed. I restarted both the Sql server and Sql server agent services and after that everything was fine and when I connected through enterprise manager their were around 10 process in the current activity that were showing as blocked by some other process, I manually killed those processes and everything was fine but my question is like how can I know the reason for this, so that I can take preventive measures to avoid it in future. This thing happened last months also and it people restarted the server and everything was fine.
Can anybody help in in this regard?
Thank You,
Rohit Paliwal[/font]
October 18, 2007 at 9:26 am
What was the blocking process? What processes were they blocking? Are they batch jobs or is someone manually submitting the jobs? You have to know these answers to make sure they don't get run at the same time again.
October 18, 2007 at 11:56 am
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply