November 5, 2008 at 1:13 pm
Has anyone ever experienced the following?
in sql server log:
2008-11-04 22:25:39.06 Server **Dump thread - spid = 0, PSS = 0x0000000000000000, EC = 0x0000000000000000
2008-11-04 22:25:39.15 Server ***Stack Dump being sent to X:\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\SQLDump0002.txt
2008-11-04 22:25:39.15 Server * *******************************************************************************
2008-11-04 22:25:39.17 Server *
2008-11-04 22:25:39.17 Server * BEGIN STACK DUMP:
2008-11-04 22:25:39.17 Server * 11/04/08 22:25:39 spid 0
2008-11-04 22:25:39.17 Server *
2008-11-04 22:25:39.17 Server * Non-yielding Resource Monitor
2008-11-04 22:25:39.17 Server *
2008-11-04 22:25:39.17 Server * *******************************************************************************
2008-11-04 22:25:39.17 Server * -------------------------------------------------------------------------------
2008-11-04 22:25:39.17 Server * Short Stack Dump
2008-11-04 22:25:40.39 Server Stack Signature for the dump is 0x000000000000024E
The SQLDump0002.txt shows:
=====================================================================
BugCheck Dump
=====================================================================
This file is generated by Microsoft SQL Server
version 9.00.3159.00
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 AT/AT COMPATIBLE.
Current time is 22:25:39 11/04/08.
8 Unknown CPU 9., 3167 Mhz processor (s).
Windows NT 5.2 Build 3790 CSD Service Pack 2.
Memory
MemoryLoad = 18%
Total Physical = 16381 MB
Available Physical = 13398 MB
Total Page File = 19036 MB
Available Page File = 14023 MB
Total Virtual = 8388607 MB
Available Virtual = 8371762 MB
**Dump thread - spid = 0, PSS = 0x0000000000000000, EC = 0x0000000000000000
***Stack Dump being sent to X:\Microsoft SQL Server\MSSQL.2\MSSQL\LOG\SQLDump0002.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 11/04/08 22:25:39 spid 0
*
* Non-yielding Resource Monitor
*
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
Please help!
November 12, 2008 at 11:48 am
Do you have CLR integration enabled and CLR objects being used in the database engine?
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
November 12, 2008 at 12:36 pm
No, CLR is not enabled.
November 12, 2008 at 1:01 pm
What is running when the stack dump generates? Non-yielding resources usually mean that something pre-emptive was executing which could be CLR, an XP, a OLE Automation Call, or it could be a real bug in SQL Server, that you've happened upon in your configuration. It is not impossible. You might read the PSS teams blog post on the non-yielding resource monitor:
http://blogs.msdn.com/psssql/archive/2008/03/28/how-it-works-non-yielding-resource-monitor.aspx">
http://blogs.msdn.com/psssql/archive/2008/03/28/how-it-works-non-yielding-resource-monitor.aspx
There is a whitepaper linked at the top of the post that has information on how to actually read the dump file with the debugger to determine what actually caused it to dump out. It gets really cryptic though, and support is likely your best avenue to a fix for this problem.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
November 12, 2008 at 1:51 pm
Jonathan Kehayias (11/12/2008)
What is running when the stack dump generates?
I could not tell what was running from any of the logs and it only happened once.
I will review the link you sent. Thanks.
May 7, 2010 at 2:55 am
I've just had the same problem on a SQL2005 Standard Edition SP2 box that's not very active.
The only other thing that has logged an issue at a similar time on that box was McAfee, giving a McLogEvent EventID 257. (I've checked - McAfee On Access Scan is set to exclude SQL Server processes and mdf/ldf/ndf/bak/trn files.)
I've had a look into this machine's history, and I see that it suffered the same issue a year or so earlier. unfortunately, there's no DBA around here now who was here then that I can ask about it - and I've only been here 6 weeks!
The server itself seems perfectly happy, so I'm going to let it run.
Thomas Rushton
blog: https://thelonedba.wordpress.com
May 17, 2010 at 3:50 am
Hi All,
I also had this error in my environment. I would like to know how it is related to this one (assuming anyone has a quick answer):
A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 395696, committed (KB): 11644184, memory utilization: 3%.
Br. Kenneth Igiri
https://kennethigiri.com
All nations come to my light, all kings to the brightness of my rising
June 14, 2012 at 12:42 am
Check the below articles to resolve the below messages in sql error log.. Basically add -T845 flag in sql server startup parameter and sql service account should have lock pages in memory permission.
-------------------------
A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 0 seconds. Working set (KB): 395696, committed (KB): 11644184, memory utilization: 3%.
---------------------
December 6, 2012 at 11:03 am
Another KB to look into would be http://support.microsoft.com/kb/2216485
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply