SQL 2008 SP1 crashing almost daily
- by matijake
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
