Sql 查询导致 MS CRM Dynamics 4.0 缓慢问题
我的 CRM 应用程序用户在一天中的特定时段面临缓慢问题，并且发现每天下午 1 点触发 SQL 查询（附在下面），导致相同的问题：
select count(*) from asyncoperationbase where RecurrencePattern is not null 并且 DeletionStateCode = 0 并消耗服务器资源。
请注意，由于某些限制，我无法清除表格。我唯一关心的是这个查询如何自行触发？它是否像 CRM 服务器触发的某些维护查询或例行查询？请建议。
My CRM application uers are facing slowness issue at a particular part of day and it has been found that a SQL query fires(attached below) at 1 PM daily causing the same:
select count(*) from asyncoperationbase where RecurrencePattern is not null
and DeletionStateCode = 0 and consuming server resources.
Pls note that due to some constarints I cannot purge the table. My only concern is how come this query triggers itself? Is it like some maintainance query or routine query as fired by CRM server? Pls suggest.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
在我看来，这可能与清理工作有关。它正在计算重复出现的异步操作。 Microsoft 的修复方法之一涉及定期清除表，如此处详述，并且有一个修补程序也可以修复该问题 - http://support.microsoft.com/kb/968520。这里有一篇类似的文章 - http://support.microsoft.com/kb/968755。如果您还没有升级到最新更新汇总，则应该升级到最新更新汇总，因为 UR 解决了这些问题。
Sounds to me like it might be related to a clean up job. It is counting the recurring async operations. One of Microsoft's fix involves purging the table on a regular basis as detailed here and there is a hotfix that may fix it as well - http://support.microsoft.com/kb/968520. There is a similar article here - http://support.microsoft.com/kb/968755. If you have not already, you should upgrade to the latest update rollup since the UR's address these issues.
我想了解你们的 CRM 应用程序的架构。在理想的情况下，应用程序服务器和数据库服务器必须位于单独的计算机上。这可能是架构问题
I want to know the architechture of your CRM Application. In an ideal scenario the Application server & databse server must be on separate machine. It could be a problem of Architecture