I have been asked to create a automated report that will show statistics about our servers, kind of what is going on "under the hood" as a top-level view for Management.
The box in question is a Windows 2003 R2 Server with SQL Server 2005 SP2 installed.
Ideally, the counters I want to pull is..
OS: Disk I/O, Disk Size, Memory, CPU
Database: Size, Connections, I/O, Log Size
I know that most if not all of these counters are already built into Windows and SQL Server in WMI, anyone know of some software out there that can be used to create reports?