April 1, 2010 at 3:23 am
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
April 1, 2010 at 2:02 pm
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
April 1, 2010 at 5:13 pm
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.
April 15, 2010 at 12:42 am
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