June 29, 2009 at 10:38 am
We have a Windows 2003\sql 2005 install that we are considering upgrading. Throughout the day I take perfmon screenshots of the CPU, Disk, memory utilization. The idea is to get a picture of how the server currently is being utilized. The screenshot approach gets old fast. Can you recommend any monitoring tools that present a "historical" overview of server utilization (i.e. Windows and Sql utilization) and don't require a PhD to understand!
TIA,
barkingdog
June 29, 2009 at 11:59 am
The question is, how much money do you want to spend. The two tools that I use to do this are System Center Operations Manager from Microsoft and SQL Diagnostic Manager from Idera. Great tools that will do what you need.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 2, 2009 at 10:21 pm
SCOM 2007 would be a great choice...
July 3, 2009 at 2:26 am
Hi Tia,
You can roll your own solution if you are prepared to invest a little time into developing and setting it up.
For example, you can store and record the results of Windows Performance Monitor, directly to a SQL Server database. From here, you can then slice and dice the data as you see fit.
Brent Ozar, has a series of posts and podcasts on his site explain how to go about this. Visit:
http://www.brentozar.com/sql-server-performance-tuning/[/url]
Hope this helps.
July 3, 2009 at 4:51 pm
Kudos to everyone for good ideas. I'll try to roll my own, and if I come to my senses, I'll look at Idera.
Barkingdog
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply