SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

ph1long
Starting Member

16 Posts

Posted - 05/06/2013 :  18:17:36  Show Profile  Reply with Quote
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

USA
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

djj55
Constraint Violating Yak Guru

USA
308 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.

djj
Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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