April 2, 2009 at 3:47 am
Hi,
We are working in 24/7 production support. One day afternoon, we found that sql server was hangs.
We checked in the Windows Applicaton Event Viewer. It shows that "Hanging Application SQLWb.exe". Users are unable to connect the servers between 1 to 2 PM. Then we restarted the server services. Now it is working fine.
When we checked the SQL Server Error Log, some of the data is missing on that hanging period time.
Can you please tell what could be reason for data missing in the SQL SErver Log file.
Reagrds,
Bala
April 2, 2009 at 4:05 am
sbvenkatesh77 (4/2/2009)
We are working in 24/7 production support. One day afternoon, we found that sql server was hangs.We checked in the Windows Applicaton Event Viewer. It shows that "Hanging Application SQLWb.exe".
That's not SQL Server. SQLWb is Management Studio. If users couldn't connect it will be because of some problem within SQL Server itself, not a hanging management tool.
When we checked the SQL Server Error Log, some of the data is missing on that hanging period time.
Define missing. What's not there that should be there and how do you know it should be there?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 2, 2009 at 4:17 am
Users says server was not available between 1 to 2 PM. Server owner restarted the server services at 2 14 PM.
When i checked the latest error log, the data's are available after 2.14 PM of that day.
When i checked the second latest log, it shows upto 1.13 PM time. In between 1.14 PM to 2.13 PM data'sa are missing.
Regards,
Bala
April 2, 2009 at 7:08 am
Probably means that SQL went down or hung at 1:13.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 2, 2009 at 7:13 pm
SQL is in hung stage from 1.13 PM, we noticed at 1.55 PM, then server owner restarted at 2.14 PM. In between there is no information in the server log.
April 2, 2009 at 7:39 pm
sbvenkatesh77 (4/2/2009)
SQL is in hung stage from 1.13 PM
Does that mean you were not able to connect to the SQL server? So, your server doesn't come back online until you restart it?
what type operations you perform during that period and also what operations were run against the server just before the SQL server got stuck?
April 2, 2009 at 7:46 pm
Hi,
We received a request to grant read only access one of the db users. At that time i tried to connec the server, i am able to connect the server through Remote Desktop, but i am not able to connect Management Studio. Then i informed the users, He said, "I also informed that users are not able to access" he checked iin the server services and noticed that server is in stopped stage, then immediately he restarted the server.
I checked with the job, there is no job schedule at the period, and also server owner confirmed, there is no patch or backup (Tape) job run on that time.
April 2, 2009 at 8:02 pm
sbvenkatesh77 (4/2/2009)
Hi,We received a request to grant read only access one of the db users. At that time i tried to connec the server, i am able to connect the server through Remote Desktop, but i am not able to connect Management Studio. Then i informed the users, He said, "I also informed that users are not able to access" he checked iin the server services and noticed that server is in stopped stage, then immediately he restarted the server.
I checked with the job, there is no job schedule at the period, and also server owner confirmed, there is no patch or backup (Tape) job run on that time.
Is there anything in the windows event log or application log please? and also what permissions have you got on the server?
April 2, 2009 at 8:07 pm
In the Application Event Viewer " Hanging Application SQLWB.exe" only alert is there.
I have sysadmin priviledges on that server.
One more question.
When i checked now in the output of SP_WHO2 active it shows the following
Checkpoing is in suspended status in the Master db from the time of Restarted the server (27th March 2.14 PM).
Can you please explain about this also
April 2, 2009 at 8:24 pm
sbvenkatesh77 (4/2/2009)
In the Application Event Viewer " Hanging Application SQLWB.exe" only alert is there.
I think there could be blocking issues on your server.
Checkpoing is in suspended status in the Master db from the time of Restarted the server (27th March 2.14 PM).
This means that Checkpoint is waiting on a resource could be a lock or I/O.
I would start tracing the server. Focus on blocking and deadlocking on your server, that's what I think.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply