Have you considered using the Management Data Warehouse feature available natively in SQL 2008 and higher?

http://msdn.microsoft.com/en-us/library/dd939169(v=SQL.100).aspx

We've found it to be quite useful for performance diagnostics, without the need for custom scripting. It's all built into SQL Server.

That said, we did build on Bill Ramos' excellent work to convert the reporting capability which ships with MDW to an SSRS based solution.