SQL 2008 SP1 crashing almost daily

Posted by matijake on Server Fault See other posts from Server Fault or by matijake
Published on 2010-06-06T19:17:38Z Indexed on 2010/06/06 19:23 UTC
Read the original article Hit count: 347

Filed under:
|
|

Hey,

almost every day our new DB crashes. It is virtual server residing on same hardware as 5 other servers, two of them beeing identical MS SQL2008sp1 and two Oracle 11g's so I can pretty much rule out hardware issues.

Server has dedicated local LUN, 4vCPU and 8GB memory with 2GB windows swap file. It runs 4 instances. Primary instance is limited to 5GB memory and paralelism set to 4 running on MS SQL 2008 SP1 @ Windows Server 2008 Enterprise R2 x64.

Only that primary instance is crashing. After it crashes nothing can connect to it, it's even impossible to shut it down through service manager.

What I found in logs is:

***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\LOG\SQLDump0081.txt
SqlDumpExceptionHandler: Process 4788 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server i s terminating this process.
   

Whole log can be seen at: http://kabl.org/files/SQLDump0081.txt

second crash log made second later at: http://kabl.org/files/SQLDump0082.txt

I have analyzed mini crashdump with Microsoft tools, but no promising results. If it can help, here it is: http://kabl.org/files/SQLDump0081.mdmp

Any ideas are greatly welcome, since it is becoming quite a pain in the ass to restart server almost every day :)

Regrads, -Matija

© Server Fault or respective owner

Related posts about sql

Related posts about crash