sql server stop | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

sql server stop

I installed SQLServer 2000 Service pack4 active/passive mode on windows 2003 enterprise edition, but every 10h the sql server stop whitout reason, first sopt agent then stop sql server whit this message:
[sqsrvres] OnlineThread: asked to terminate while waiting for QP. In this moment there isn’t no database in sql server, could this the reason? sorry for my bad english, i am italia.
thank a lot.
What kind of other software installed on the Server where SQL is installed?
Any anti-virus software or anti-spyware software?
Check for any viruses in the system. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
No, i installed only sql server 2000
Check that you have no other programs or batches on the system that stops the sql service. Could be a monitoring or backup program or something else. What are the last few entries in the sql server log? Do you see a message like this:
"SQL Server is terminating due to ‘stop’ request from Service Control Manager."
There could be a chance if you’er disks are full you may experience this kind of abnormal sqlserver stop issue. Eventhough there is no concrete evidence for this issue (lack of disk space and sql server stop) but i did notice the similarity after making sure there aer enough storage space i didn’t notice this proble. Argyle : Could you let me know – If there is a mssg seen like you mentioned
"SQL Server is terminating due to ‘stop’ request from Service Control Manafer" what it means and what is the remedy ?
It’s a standard stop message. It means that someone stopped the sql server manually via control panel->admin tools->services or the service manager or that an external program did it say during install of service pack. It also shows when you reboot the server etc. In other words it was not a fatal error with sql server itself that caused the stop.
Or may be any other process or software that is attempting to reboot the server and tried to stop all the services. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>