November 16, 2016 at 4:26 am
I am seeing this error in the sql error log and we seem to be having a 'slow down'
'Resource Monitor Worker xxx appears to be non-yielding on node 0.Memory freed 59048kb. Last Wai:MISCELLANEOUS.Last clerk type CACHESTORE_OBJCP,name Object Plans. Approx CPU:Used:kernel 0ms, user 0ms, interval 4638609 '
What exactly is this error ?
There is also a mini dump file generated yesterday in the sql log folder. How do you open these files to read what is in them ?
I have googled this and people who manged to open the dump file also had messages about sql server paging out to disc so I wondering if this info will be contained within the dump file.
Thanks
November 16, 2016 at 9:58 am
Sounds like you're hitting this issue. Are you sure this is a SQL SErver 2012 instance?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
November 16, 2016 at 10:06 am
Hi Grant
Yes it is a sql server 2012.
SELECT @@VERSION
Microsoft SQL Server 2012 (SP1) - 11.0.3156.0 (X64)
May 4 2015 18:48:09
Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
November 16, 2016 at 12:30 pm
I'm not sure then.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply