千磨万击还坚劲,任尔东西南北风。这篇文章主要讲述SQL Server-Resource Monitor worker appears to be non-yielding on Node 0相关的知识,希望能为你提供帮助。
Refer to
https://support.microsoft.com/it-it/help/2216485/fix-resource-monitor-enters-a-non-yielding-condition-on-a-server-that?spid=1044&
sid=1229%3Fspid%3D1044&
sid=1229
【SQL Server-Resource Monitor worker appears to be non-yielding on Node 0】
Cause
In SQL Server 2008 and SQL Server 2008 R2, the Resource Monitor task wakes up periodically to listen to and notify subscribers of low, high, or steady memory events. These memory events may be external to SQL Server (notifications that are system-wide from the operating system) or internal to SQL Server (notifications that are process-wide from the buffer pool). When such notifications occur, various memory consumers trim their memory usage.
Note
Consumers can be memory clerks that are cache stores, user stores, or object stores.
If certain memory consumers use a large amount of memory, the trimming that the consumers perform may take a long time to finish.
The Scheduler Monitor task that runs every five seconds checks whether Resource Monitor has moved from one consumer to another in the past 60 seconds. When the Scheduler Monitor detects that the Resource Monitor has not moved past a consumer for 60 seconds, the Schedule Monitor interprets this as the Resource Monitor entering a non-yielding state, and then the Schedule Monitor logs the error message that is mentioned in the "Symptoms" section.
These messages are also raised if the rate at which the Resource Monitor frees memory is less than 2 MB every five seconds.
These messages are only an indication that the Resource Monitor is busy cleaning up large consumers, and these messages do not necessarily indicate a problem with the Resource Monitor itself.Resolution
Starting with Microsoft SQL Server 2008 Service Pack 2 and Microsoft SQL Server 2008 R2 Service Pack 1, the non-yielding Resource Monitor message was extended to easily isolate the memory clerk that leads to the non-yielding condition.
The new message will resemble the following:Resource Monitor (0x9b0) Worker 0x0000000003A2C1C0 appears to be non-yielding on Node
Node_#. Memory freed: 0 KB. Last wait: lastwaittype.
Last clerk: type
clerk_type, name
clerk_name. Approx CPU Used: kernel 0 ms, user 0 ms, Interval:
Interval_value.The following are descriptions of the various fields that are used in this message:
- Memory freed: This is how much memory is freed by Resource Monitor for the specified interval as measured in kilobytes. If the rate at which the memory is freed does not exceed 2 MB every five seconds, the Scheduler Monitor detects this condition as a non-yielding condition.
- Last wait: This is the last wait type for the Resource Monitor thread. You can use this field together with theApprox CPU Used field to identify whether the Resource Monitor thread is running or waiting for a significant part of the interval.
- Last clerk: This is the type and name of the memory clerk that was trimming its memory when the non-yielding condition occurred.
- Approx CPU Used: This is the kernel and user time that is used by Resource Monitor as measured in milliseconds. You can use this together with other fields to verify that Resource Monitor is making progress during the specified interval.
- Interval: This is the time that elapsed since the last clerk was notified as measured in milliseconds.
For more information about how to interpret the RING_BUFFER_RESOURCE MONITOR. visit the following MSDN blog: How It Works: What are the RING_BUFFER_RESOURCE_MONITOR telling me?For more information about how SQL Server listens and responds to memory notifications and about the Resource Monitor task and troubleshooting memory-related performance issues in SQL Server, refer to the following MSDN blog articles:
推荐阅读
- MyBatis mapper文件中的变量引用方式#{}与${}的差别
- .NET环境下Configuration 与ConfigurationManager/ AppSettings 与 ConfigSections探讨
- Android项目引入actionbarsherlock作为library后混淆之后的异常
- webapp部署到tomcat服务器
- winxp系统如何安装格式工厂软件|winxp系统安装格式工厂工具的办法
- xp纯净版系统无法打开txt文本文档的处理办法
- xp系统qq邮箱下载附件打开不了如何处理
- 番茄花园xp系统怎样提升宽带连接速度|xp系统提升宽带连接速度的技巧
- win xp系统下如何设置QQ气泡|win xp系统下设置QQ气泡的办法