Thursday, March 29, 2012

Back to the .....

My bug hunting days are almost over and in April getting back to the darkside. I must say it was very interesting experience and to see and join the MS Support way of life.

Nevertheless,not much will change I will still need to solve those issues and also good to be back at the other side and continue integration, migration and implementing CRM.

Of course also time to spam you again with my blog post and also working on some new articles for MS Dynamicsworld

Keep on coming and reading.. don't be afraid.. we have cookies :)

exceeded the threshold of 10 seconds?

As you should know by now in case of mysterious CRM bugs always check the event viewer. It is the source of all kinds of events like: information, warning and our fav "errors".

Guess, the common one is the printer, yes we do not install those on servers. Nevertheless the event viewer logs are often overlooked and especially the warnings might give you some nice clues.

You might have seen something like "Query execution time of 10.6 seconds exceeded the threshold of 10 seconds." and also mentions your CRM database. In my case and think also others still might wondering, where the *&^% we can change those 10 seconds.

My first guess would be "treshold" settings in MS SQL server, but this is something completely different. It is some cursor stuff (stalk your dba). Hmmm what other settings we might have the most important are described in the following post:

http://blogs.msdn.com/b/crminthefield/archive/2011/06/13/microsoft-dynamics-crm-timeout-settings.aspx

Nevertheless, nothing mentioning those 10 secs....

My latest information about this famous 10 secs is, that it is internal warning of CRM. The warning is automatically send after, yes indeed an query exceeded the 10 seconds. It is just warning that some of your processes are taking too long, duh :)

Your best guess for the cause is in the use of fetch xml and accompied by database locks. To prevent this add the 'no lock' feature.

Happy threshold hunting