Igor Micev (2/26/2013)
I want to enable trace flag 2371 for update statistics.The application generates a lot of queries. As enabling the trace flag withdraws recompilation of the queries, is this a good thing?
Share your experiences please.
This thread is a year old, but I'm looking into the same thing.
I asked Grant Fritchey in his presentation at SQL Saturday Cleveland last Saturday (2/8/2014) if there was a scenario where you wouldn't use trace flag 2371 and he said "No". He then clarified and said there could be a couple of scenarios, but he generally recommended it. I'm going to push to get this implemented in our environment.
HTH,
Rob