I am looking to store information about performance/database information which can be derived from DMV's.
The point of this is to for example track the growth of database files, or look at i/o wait stats for databases for a long time, one option I can think of is using reporting services to query the respective database server and setup reports or subscription to the report information and get it to email the contents all the time or maybe store the result somewhere, so that I can gather archive/historic information.
I'm looking for ideas here.
Thanks.