June 12, 2009 at 5:15 pm
I have noticed in the below dump file in the error log. But it is happened 3 weeks ago and I did not notice at that time.
What this information means?
is there any memory or any other problems exist?
how can I diagnose this?
2009-05-20 09:50:22.46 Server Using 'dbghelp.dll' version '4.0.5'
2009-05-20 09:50:22.46 Server **Dump thread - spid = 0, PSS = 0x00000000, EC = 0x00000000
2009-05-20 09:50:22.46 Server ***Stack Dump being sent to D:\Program Files\Microsoft SQL Server\MSSQL\LOG\SQLDump0001.txt
2009-05-20 09:50:22.46 Server * *******************************************************************************
2009-05-20 09:50:22.46 Server *
2009-05-20 09:50:22.46 Server * BEGIN STACK DUMP:
2009-05-20 09:50:22.46 Server * 05/20/09 09:09:22 spid 0
2009-05-20 09:50:22.46 Server *
2009-05-20 09:50:22.46 Server * Non-yielding Resource Monitor
2009-05-20 09:50:22.46 Server *
2009-05-20 09:50:22.46 Server * *******************************************************************************
2009-05-20 09:50:22.46 Server * -------------------------------------------------------------------------------
2009-05-20 09:50:22.46 Server * Short Stack Dump
2009-05-20 09:50:35.37 Server Stack Signature for the dump is 0x000002ED
2009-05-20 09:50:35.00 Server External dump process return code 0x20000001.
External dump process returned no errors.
2009-05-20 09:50:36.01 Server Resource Monitor (0x9dc) Worker 0x03B0E0E8 appears to be non-yielding on Node 0. Memory freed: 2072 KB. Approx CPU Used: kernel 15 ms, user 0 ms, Interval: 60266.
and I'm getting the below message while weekly DBCC CHECKDB is running(I have noticed in the error log). What this message means?
Resource Monitor (0x9dc) Worker 0x03B0E0E8 appears to be non-yielding on Node 0. Memory freed: 56512 KB. Approx CPU Used: kernel 31 ms, user 0 ms, Interval: 60360.
June 12, 2009 at 6:04 pm
Looks like a memory leak or problem. Just to be sure, download and patch your MS-SQL instance if possible You can also check the memory usage and processes via Performance Monitor and SQL console.
June 12, 2009 at 6:10 pm
download and patch your MS-SQL instance
what should I download and patch the SQL Instance? Could you please explain me...
We have SQL Server 2005 Developer Edition with SP3.
Thanks
June 12, 2009 at 6:26 pm
rambilla4 (6/12/2009)
download and patch your MS-SQL instance
what should I download and patch the SQL Instance? Could you please explain me...
We have SQL Server 2005 Developer Edition with SP3.
Thanks
because sometimes, depending of your SQL version, a bug could be the reason for your error. It seems you're fine with SP3 but take a look on Microsoft site and see most recent hotfixes. If your instance is patched, check for memory leaks.
June 12, 2009 at 6:31 pm
Iam trying to setup performce counters from perfmon. When add the counters, it not showing the counters but some numbers.
I checked the event viewer and found below error. How can I rectify this and setup Perfmon counters and to is there any memory leak?
Event Type:Error
Event Source:Perflib
Event Category:None
Event ID:1008
Date:6/11/2009
Time:7:10:12 PM
User:N/A
Computer:SQL1
Description:
The Open Procedure for service "MSSQLSERVER" in DLL "C:\WINDOWS\system32\sqlctr90.dll" failed. Performance data for this service will not be available. The Status code returned is the first DWORD in the attached data.
is there ant other way to know the memory leak?
June 12, 2009 at 6:43 pm
How's your memory allocation? how much RAM you're using on your server and how much SQL is requesting?
Look at the following counters:
Process: Private Bytes - SQL Server - all committed memory for both "areas"
Process: Working Set - SQL Server - committed memory that is mapped to physical RAM
SQL Server Memory Manager: Total Server Memory - size of the bufferpool
This is a good article too : http://technet.microsoft.com/en-us/library/cc966540.aspx
June 15, 2009 at 5:00 pm
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply