I need to be able to gather generic information regarding I/O. I want to know the number of reads & writes by database/table that occur on the SQL Server.
When I need to trouble-shoot the system, I can then in turn compare the I/O table read/writes with information from Perfmon to figure out which tables are the hot spots of the application.
This information could be used to create different drive arrays, and place tables into new filegroups pointing to these arrays.
Another benefit would trend analyses by database/table for historical gathering.