SQL Server Performance

svchost (836) The database engine 5.02.3790.3959 started/stopped?

Discussion in 'General DBA Questions' started by To_DBA, Oct 30, 2007.

  1. To_DBA New Member

    Hi All
    does anyone see this message in your cluster SQL server 2000? we got a lot of " svchost (836) The database engine 5.02.3790.3959 started." or "svchost (836) The database engine 5.02.3790.3959 stopped.
    could anyone tell me what happen or anything is wrong in our system?
    thanks in advance.
    To_DBA, Oct 30, 2007
    #2

  2. techbabu303 New Member

    These are messages when the database engine was stopped or started manually for maintianence purposes.
    But do you see this messages without sombode restarting them ?
    Do you also see any other message before the engine stopped in event viewer ?
    Regards
    Sat
    techbabu303, Nov 2, 2007
    #3

  3. satya Moderator

    Remove AUTO_CLOSE on this database, this is not recommended on a production server.
    satya, Nov 2, 2007
    #4

  4. techbabu303 New Member

    Good one SIR about AUTO_CLOSE was not aware that could cause problems .
    Hope that fixes this one.
    Thx
    Sat
    techbabu303, Nov 4, 2007
    #5

  5. satya Moderator

    I thought it wouldn't but earlier we solved it by that way.
    SVCHost has importance in Windows servers, as its a critical service process, so the SQL Server service will communicate with it, the relevant PID of the Svchost.exe process can view from Task Manager.
    Relevant KBAs in this case:
    You may receive an error message when you try to install SQL Server on a
    computer that is running Windows Server 2003 Web Edition
    http://support.microsoft.com/default.aspx?scid=kb;en-us;819258&Product=sql2k

    PRB: Windows Server 2003 Support for SQL Server 2000
    http://support.microsoft.com/default.aspx?scid=kb;en-us;329329&Product=sql2k

    SQL Server 2000 Is Not Supported on Windows Server 2003 Terminal Server
    Application Server
    http://support.microsoft.com/default.aspx?scid=kb;en-us;327270&Product=sql2k


    satya, Nov 5, 2007
    #6

Share This Page