cclark-1005023 (3/24/2010)
I like the thoughts in this, but we use a more general solution where we track similar information for all production jobs. Instead of using a manually configured time period for each job we calculate the standard deviation based on the historical job durations and report only when the current run time falls outside of 3 standard deviations. This alerts us to both jobs that run too long or too short, etc.
@david-2 Bird -- Nice article. Thanks. I haven't read the others in the series but definately will.
@cclark -- Great idea, I hadn't thought of that method.
This is why I love the discussions on articles. The discussions to me are like icing on the cake except sometimes the icing is vitimin packed.
---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum