Generating a report from perf data in Windows 2003 R2


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?

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I'm sure there are many solutions out there but I've found this one easy to setup and learn. It comes with much more then just reporting. E.g. Patch management, remote control, automated reporting, alerting, monitoring and more 

As far as I know you have to get it trough a partner because they don't sell it direct. If you want more information let me know...I could demo it to you as well.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mirdeAuthor Commented:
I was aiming at something free, that I can put or hack together to work, we are not really looking for a full blown out software, just some basic reports that get generated/emailed.

Seeing if someone out there has put something together like this for their current environment and that could point me to some useful resources to start looking at.
Considering that I did answer your question and that in your first post you did not mentioned that you wanted something for free I think this questions should not be deleted.
mirdeAuthor Commented:
You are correct, I will go ahead and give you the points.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2003

From novice to tech pro — start learning today.