SQL server restarted automatically

  • Hi All,

    Our SQL Server started automatically. below is the error message

    "

    04/01/2010 14:41:17,spid7s,Unknown,Starting up database 'master'.

    04/01/2010 14:41:15,Server,Unknown,Node configuration: node 0: CPU mask: 0x000000000000000f Active CPU mask: 0x000000000000000f. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.

    04/01/2010 14:41:13,Server,Unknown,Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.

    04/01/2010 14:41:13,Server,Unknown,Using locked pages for buffer pool.

    04/01/2010 14:41:12,Server,Unknown,Detected 4 CPUs. This is an informational message; no user action is required.

    04/01/2010 14:41:12,Server,Unknown,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.

    04/01/2010 14:41:12,Server,Unknown,Registry startup parameters: <nl/> -d C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf<nl/> -e C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG<nl/> -l C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf

    04/01/2010 14:41:12,Server,Unknown,This instance of SQL Server last reported using a process ID of 1668 at 4/1/2010 2:33:32 PM (local) 4/1/2010 9:03:32 AM (UTC). This is an informational message only; no user action is required.

    04/01/2010 14:41:12,Server,Unknown,Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'.

    04/01/2010 14:41:12,Server,Unknown,Authentication mode is MIXED.

    04/01/2010 14:41:12,Server,Unknown,System Manufacturer: 'Microsoft Corporation'<c/> System Model: 'Virtual Machine'.

    04/01/2010 14:41:12,Server,Unknown,Server process ID is 5032.

    04/01/2010 14:41:12,Server,Unknown,All rights reserved.

    04/01/2010 14:41:12,Server,Unknown,(c) 2005 Microsoft Corporation.

    04/01/2010 14:41:12,Server,Unknown,Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (X64) <nl/>Jul 9 2008 14:17:44 <nl/>Copyright (c) 1988-2008 Microsoft Corporation<nl/>Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) (VM)

    "

    After doing some research I found this is becuase of max connection limit for the SQL node. and the siginificant part of sql memory has been paged out, which caz sql server to restart.

    Max memory allocation= 2147483647

    Min memory allocation = 0

    RAM = 4 GB

    How can i debug & resolve the issue please help. Let me know if naymore information required

    Abhijit - http://abhijitmore.wordpress.com

  • Abhijit More (4/1/2010)


    Hi All,

    After doing some research I found this is becuase of max connection limit for the SQL node. and the siginificant part of sql memory has been paged out, which caz sql server to restart.

    Does this mean you have resolved your issue?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Sounds like you found the issue. Without knowing your system I would recommend limiting max memory for SQL to something around 3GB so it doesn't consume all the available memory on the machine.

  • for a while it was solved but i guess it's not. I have only 2 GB of memory available on the server.

    Abhijit - http://abhijitmore.wordpress.com

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply