In previous post I listed situations where your statistics might need some special attention (http://sqlblog.com/blogs/elisabeth_redei/archive/2009/03/01/lies-damned-lies-and-statistics-part-i.aspx). As I mentioned in that post, the symptoms are typically related to more or less random variations in duration that cannot be explained by resource contention or blocking. A quick recap of the various problems you can encounter: 1. Statistics is out-of-date 2. T...
|
1
kudos |
|
||||
No comments yet, be the first one to post comment.