Notifications
Announcements
No record found.
How to get rid of these warning messages :"Query execution time of xx.xx seconds exceeded the threshold of xx seconds"
*This post is locked for comments
There are few things you may check here as this might be the result of the overall performance in CRM database
•Run the sp_who2 and check for any blocking sessions
•If there are any blocking make sure that RCSI for the CRM database is set to 1
•MDOP should not be set to default value if there is no reason of just keeping this value to Zero
•Take any select query from the warning messages and then execute that query directly from the SSMS, and see how much time it is taking.
•If the SQL query is taking long time check for the large size table in CRM database
•If you are finding large size tables do cleanup if there is any KR article available to perform the cleanup on that table
•Also check the CRM 2011 OOB maintenance jobs (specifically ReIndex All and Deletion Service Job) and make sure that last status is successful. You may use the CRM 2011 job editor tool which is available at crmjobeditor.codeplex.com
•If you are using the SQL Standard maintenance jobs, please make sure that SQL maintenance jobs are running fine
•You might want to run the SQL Diag and then Analyze the Results with the help of the SQL nexus for any index recommendations for the large sized table
•After Doing above optimization you might see these query execution but with much less frequency and for that you may finally increase the OLEADB time out settings : support.microsoft.com/.../918609
Thanks,
Hi,
CRM 2011 (Rollup 11) we are getting lots of Timeout warning messages. Some are even exceeding 100seconds. When i run the same query directly on SQL, it does not take more than a second.
As suggested in the post by Mohammad Atif(earlier post), i now see that "Deletion Service" has failed the last time it has run.
Please would anyone suggest as how to proceed on from here.
Note: These time out issues occur mainly for the CRM 2007 Webservice Calls. I have some ASP.NET webservices which have reference to the CRM 2007 webservice. Timeout issue occurs mainly in these calls.
Many Thanks
you might want to look into the Async log after re-initiating the failed job in off business hours and see where the job is failing actually.
Mohammad
Thank you for the reply Mohammad. This is the error i can see in the logs when i run the "Deletion Service" job.
"Caller <Service account> is not an owner for SubscriptionId 5faf7c12-78c4-de11-8a4c-00155d0f3502 "
And this is the error displayed in the Job Editor : "Last job run failed with resultcode: 1"
Was there ever any input for a solution provided for this scenario? I have exactly the same issue occurring.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
SA-08121319-0 4
Calum MacFarlane 4
Alex Fun Wei Jie 2
