July 12, 2003 at 10:33 pm
My Server Get hang continuously. Procedure related to application is already optimised.
If any one can give proper solution it would be highly appreciated.
July 14, 2003 at 7:37 am
Try this checklist (found at http://www.kempscaseworks.com/SUPPORT/SUPPORTLIBRARY/SQL/SQLInstall.htm#_Toc519050991:
When it "locks up" can you connect at all to SQL Server? Try connecting locally on the server using ISQL.EXE - ISQL -Usa -P<pwd> and see if it connects. This doesn't run any stored-procedures when it connects so any blocking going on (say in tempdb) won't affect it.
If you can connect what does a select * from sysprocesses and sp_lock show? Look for blocked spids or unusual wait-types.
If you can't connect to SQL Server are you able to make a network drive connection to the NT server itself? Are you able to ping its IP address?
Are there any errors in the SQL errorlog?
Are there any errors in the NT system/application event logs?
Do you have SMP=-1 and/or priority boost=1 set in sp_configure? If you do then SQL queries can monopolize your system at the expense of NT/network drivers. This can cause spasmodic lockups. Set SMP and Priority Boost to 0 (the default).
What does task manager/performance monitor show SQL Server doing? Is it using 100% CPU?
If you can't get to the bottom of the problem then you need to call Microsoft PSS (see MSPSS.TXT in the FAQ for more info) and give them details of the problem and the results of the above tests.
In the meantime if you need to stop/start SQL Server quickly then use the following (as normal service shutdown commands probably won't work - try them first anyway).
You can kill SQL Server with "KILL sqlservr.exe". The KILL command is in the NT resource kit. It can then be started with NET START MSSQLSERVER. ONLY do this if SQL Server does not respond to a normal shutdown or NET STOP MSSQLSERVER command. This will at least stop you from having to reboot NT.
All the best,
Dale
All the best,
Dale
Author: An Introduction to SQL Server 2005 Management Studio
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply