SQL Server Performance

sql server stop

Discussion in 'SQL Server Clustering' started by mbuonfi, Nov 30, 2005.

  1. mbuonfi New Member

    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.
  2. satya Moderator

    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.
  3. mbuonfi New Member

    No, i installed only sql server 2000
  4. Argyle New Member

    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."

  5. ranjandba New Member

    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 ?
  6. Argyle New Member

    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.
  7. satya Moderator

    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.

Share This Page