Sql Crash - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Sql Crash

Author

Topic

ph1long
Starting Member

16 Posts

Posted - 2013-05-06 : 18:17:36

Hi,

Every 1, my sql server crashes. Looking at my sql dump log I see this information below. It seems that it is running out of virtual memory. Is there anything I can configure to prevent this crash?

Current time is 09:30:16 05/04/13.
=====================================================================
BugCheck Dump
=====================================================================

This file is generated by Microsoft SQL Server
version 10.50.1600.1
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.

Computer type is Intel(R) Xeon(R) CPU X5675 @ 3.07GHz.
Bios Version is HP - 20120201
24 X64 level 8664, 2 Mhz processor (s).
Windows NT 6.1 Build 7600 CSD .

Memory
MemoryLoad = 98%
Total Physical = 16374 MB
Available Physical = 249 MB
Total Page File = 32748 MB
Available Page File = 11752 MB
Total Virtual = 8388607 MB
Available Virtual = 8370769 MB
**Dump thread - spid = 0, EC = 0x0000000000000000
***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\LOG\SQLDump0005.tx
t
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 05/04/13 09:30:16 spid 2188
*
* Non-yielding IOCP Listener
*
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2013-05-07 : 11:28:13

What is the result of SELECT @@VERSION

Non-yielding IOCP Listener was repaired with CU3 for SP2 (I think).

Also look for other I/O errors in Application Event Logs.

djj55
Constraint Violating Yak Guru

352 Posts

Posted - 2013-05-07 : 11:31:41

Have you set a maximum on your memory? SQL has unlimited out of the box which can cause problems.

djj

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources