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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Sql Crash
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

16 Posts

Posted - 05/06/2013 :  18:17:36  Show Profile  Reply with Quote

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 .

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
* *******************************************************************************
* 05/04/13 09:30:16 spid 2188
* Non-yielding IOCP Listener
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump


5072 Posts

Posted - 05/07/2013 :  11:28:13  Show Profile  Visit russell's Homepage  Reply with Quote
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.

Edited by - russell on 05/07/2013 11:28:54
Go to Top of Page

Constraint Violating Yak Guru

352 Posts

Posted - 05/07/2013 :  11:31:41  Show Profile  Reply with Quote
Have you set a maximum on your memory? SQL has unlimited out of the box which can cause problems.

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000