Excellent article Erin,
I've already watch your course about baseline on pluralsight and now I'm waiting for the rest of this series of articles.
Will you write about SSIS baseline?
I work with SSIS and I record some information about those process so that I can see if the process is taking more time to finish according to the number of records being processed, and other factors.
This are some measures that I usually record:
- Start time, end time and number of records of the extract process by SQL Server instance. This way I can see if the problem is with one particular SQL Server instance.
- Start time, end time and number of records of the load process by SQL Server instance. For the same reason as above. This works also when generating files on network locations.
- If I have all the above I know how much time the transformation time was spent end time of the extract and the start time of the load.
At the moment those are the measures that I'm recording, I was thinking of recording other performance counters related to CPU and memory so that I could check if there was any relationship about a performance drop and those counters. What do you think?