Analyzing Perfmon data with the SQL 2008 data mining tools.
In our particular example, we can see that Category 8 is the highest TempDB load. Innnnteresting - earlier, I’d discarded categories over 5 because they represented a low amount of time, but it looks like we’ll have to go back and revisit category 8. Category 8 was Friday mornings from midnight to 4am, so we might have something going on then.
No comments:
Post a Comment