October 13, 2009 at 4:47 pm
Hi,
We have SQL Server 2005 32 bit with SP3 on Windows 2003 Standard edition 32 bit with SP2. Its a development SQL Server and its a VIRTUAL MACHINE
We have only 2 GB of RAM and we are getting the below dump 3 times in last 2 weeks.
2009-10-10 18:10:39.72 Server **Dump thread - spid = 0, PSS = 0x00000000, EC = 0x00000000
2009-10-10 18:10:39.77 Server ***Stack Dump being sent to D:\Program Files\Microsoft SQL Server\MSSQL\LOG\SQLDump0002.txt
2009-10-10 18:10:39.77 Server * *******************************************************************************
2009-10-10 18:10:39.77 Server *
2009-10-10 18:10:39.77 Server * BEGIN STACK DUMP:
2009-10-10 18:10:39.77 Server * 10/04/09 18:10:39 spid 0
2009-10-10 18:10:39.77 Server *
2009-10-10 18:10:39.77 Server * Non-yielding Resource Monitor
2009-10-10 18:10:39.77 Server *
2009-10-10 18:10:39.77 Server * *******************************************************************************
2009-10-10 18:10:39.77 Server * -------------------------------------------------------------------------------
2009-10-10 18:10:39.77 Server * Short Stack Dump
2009-10-10 18:10:40.02 Server Stack Signature for the dump is 0x000002ED
2009-10-10 18:10:51.58 Server External dump process return code 0x20000001.
External dump process returned no errors. 2009-10-1018:10:51.59 Server Resource Monitor (0x914) Worker 0x03B0E0E8 appears to be non-yielding on Node 0. Memory freed: 21256 KB. Approx CPU Used: kernel 78 ms, user 0 ms, Interval: 60034.
2009-10-10 18:11:51.62 Server Resource Monitor (0x914) Worker 0x03B0E0E8 appears to be non-yielding on Node 0. Memory freed: 23160 KB. Approx CPU Used: kernel 125 ms, user 0 ms, Interval: 155993.
2009-10-10 18:11:55.69 spid54 DBCC CHECKDB (Mydb1) WITH no_infomsgs executed by NT AUTHORITY\SYSTEM found 0 errors and repaired 0 errors. Elapsed time: 0 hours 3 minutes 11 seconds.
2009-10-10 18:13:17.16 Server Resource Monitor (0x914) Worker 0x03B0E0E8 appears to be non-yielding on Node 0. Memory freed: 40936 KB. Approx CPU Used: kernel 31 ms, user 0 ms, Interval: 60003.
2009-10-10 18:13:17.73 spid54 DBCC CHECKDB (Mydb2) WITH no_infomsgs executed by NT AUTHORITY\SYSTEM found 0 errors and repaired 0 errors. Elapsed time: 0 hours 1 minutes 54 seconds.
and the below message occurring daily:
Resource Monitor (0x914) Worker 0x03B0E0E8 appears to be non-yielding on Node 0. Memory freed: 23160 KB. Approx CPU Used: kernel 125 ms, user 0 ms, Interval: 155993.
Is this indication of Memory Presuure?
Please clarify me
October 13, 2009 at 5:11 pm
Hi,
One thing I have noticed from the error log is "The below messages are occuring only on SUNDAYS when the INTEGRITY, REBUILD INDEXES & UPDATESTATISTICS maintenance jobs run"
External dump process returned no errors. 2009-10-1018:10:51.59 Server Resource Monitor (0x914) Worker 0x03B0E0E8 appears to be non-yielding on Node 0. Memory freed: 21256 KB. Approx CPU Used: kernel 78 ms, user 0 ms, Interval: 60034.
SQL Server has encountered 1 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [D:\Program Files\Microsoft SQL Server\MSSQL\data\tempdb.mdf] in database [tempdb] (2). The OS file handle is 0x00000548. The offset of the latest long I/O is: 0x000000001a0000
SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [D:\Mydb1\index\Mydb1.mdf] in database [Mydb1] (10). The OS file handle is 0x00000788. The offset of the latest long I/O is: 0x000000139d0000
please advice me
October 14, 2009 at 1:55 am
Your last post shows that your I/O subsystem is struggling to cope. with high disk usage you can see these messages.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 14, 2009 at 9:40 am
thank you,
Your last post shows that your I/O subsystem is struggling to cope. with high disk usage you can see these messages
Is that OK to have disk IO high while running INTEGRITY, REBUILD INDEXES & UPDATESTATISTICS maintenance jobs?
OR
Do I need to increase the RAM?
October 14, 2009 at 9:49 am
gmamata7 (10/14/2009)
thank you,Your last post shows that your I/O subsystem is struggling to cope. with high disk usage you can see these messages
Is that OK to have disk IO high while running INTEGRITY, REBUILD INDEXES & UPDATESTATISTICS maintenance jobs?
OR
Do I need to increase the RAM?
it is not unusual to have these messages while running certain jobs and you could try increasing the ram
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
October 14, 2009 at 1:48 pm
Did you set the max memory for SQL Server? If not, then you are starving the OS and SSIS which is causing these issues.
Set the max memory to 1024 (1GB) leaving the other 1GB to the O/S. If that solves the problems, increase the max memory by 256MB and continue to monitor. I would not recommend going above 1536MB for the max memory setting with only 2GB of memory available on the server.
The other option would be to increase the available memory on the server to 3GB. By default, SQL Server will not use more than 2GB of memory and this would allow that memory to be used by the O/S and SSIS.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply