Damon Wilson (4/14/2008)
Bill,Thanks for taking the time to write this article. I have implemented a similar process in my environment. To collect the majority of my data, I use a modified version of David Bird's SQL Overview SSIS Package.
SQL Overview Part 1
By David Bird, 2008/01/07
http://www.sqlservercentral.com/articles/Integration+Services/61621/
SQL Overview SSIS Package II - Retrieving SQL Error Log
By David Bird, 2008/01/14
http://www.sqlservercentral.com/articles/Integration+Services/61714/
SQL Overview SSIS Package III - Full Package
By David Bird, 2008/01/22
http://www.sqlservercentral.com/articles/Integration+Services/61774/
Using David's articles and SSIS code, I have customized it for the uniqueness of the systems which I am responsible for. Your idea of printing everything out and storing in a binder with signatures, will be a a topic for discussion with my next planning meeting with my boss. I look forward to your future SSC postings.
Regards,
I also use the SQL Overview package from David. It is a great help to minitor the SQL infrastructure.