July 20, 2009 at 12:24 pm
I have to do some baselining on a db application with an asp.net front end.
This project was brought about due to a need to monitor the space usage over time of the server, so we can predict in advance when we will need more storage space and order in advance.
While monitoring this, I was also planning to monitor things like:
I/O activity on each disk.
CPU usage by sql server.
overall CPU usage.
Can you please advise what other perfmon counters I should record that will be usefull to monitor over time? I need a few more items to monitor, so as to justify the time spent setting up the recording of the data and creation of a few reports in reporting services to display the data neatly.
Thanks all.
July 20, 2009 at 1:11 pm
Honestly - if you are not sure what this might hit, making an assumption might be dangerous.
Start easy. Use something like the freely downloadable SQL Health and History utility, and grab as much as you can. Once you can tell what it is NOT hitting, then turn some things off.....
SQLH2 is downloadable from Microsoft's site at this link
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
July 21, 2009 at 6:57 am
Matt's advice is definitely good.
Here's a local article: http://www.sqlservercentral.com/articles/Administration/performancemonitoringbasiccounters/1348/[/url]
There are others. Just do a search in the box at the top of the screen.
I don't usually try to plug my book in the forums like this, but I've got a couple of chapters on establishing baselines, including suggested counters and possible problem points. It's an option.
"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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply