Nadrek (1/23/2013)

---

If you're going to capture per-file data in the first place, I'd highly recommend also capturing sys.dm_io_virtual_file_stats() data - then you can see which files/databases/disks are most "used" by...

heb1014 (11/28/2012)

---

Thanks, this is helpful!

I started working today to add the collection and reporting of configuration data. I created a query that will report all changes within...

Bennett Scharf (11/27/2012)

---

Hey Erin,

This is great - especially the idea of baselining your configuration data!

On a related note, I log and analyze my performance counters through Performance Monitor, mainly...

Del Lee (11/27/2012)

---

I've seen or heard a number of times about the importance of collecting baseline information, but this is the first time I've seen some specific suggestions as to...

I'm very glad it was helpful for you!

Thanks for the feedback 🙂 The second article should be published tomorrow (2012-11-27), I don't have a date for the remaining two yet, but will try to remember to...

Thanks Mike! I appreciate the feedback. This was just the intro article and the next three articles will have code samples to get you started with data capture...

Ohhh, that's a good question. I don't have any current plans to write about SSIS baselines, but that's an excellent idea. I'm not a SSIS guru so I...

What I really recommend is documenting your requirements, then doing trials of the applications which seem to fit what you need. Most if not all of the vendors offer...

Thanks for the comments all! There are more articles to come, and I'm looking forward to seeing how other admins and devs capture this data. Thanks for reading!

I work for a software company, and one of the primary responsibilities of my job is helping with customer support issues that involve the database. As you might guess,...