August 24, 2009 at 4:08 am
Hello I am trying to capture performance metrics across all our servers, eg cpu usage, ram usage for retrospective analysis. So that when a user says that they had a performance issue on server x a week ago, I can analysis the stats. Unfortunately we have no budget for third party tools, is there anyway to do this through something like power shell or by other means ? I have had a look at perfmon.msc and found that configuring this across multiple servers would be unscalable and very time consuming.
August 24, 2009 at 5:19 am
jabba (8/24/2009)
Hello I am trying to capture performance metrics across all our servers, eg cpu usage, ram usage for retrospective analysis. So that when a user says that they had a performance issue on server x a week ago, I can analysis the stats. Unfortunately we have no budget for third party tools, is there anyway to do this through something like power shell or by other means ? I have had a look at perfmon.msc and found that configuring this across multiple servers would be unscalable and very time consuming.
well powershell, requires certain rights to run, unless you can guarantee that you it will have those rights on all of the servers, then it is not an option. if also depends on what sort of metrics you are trying to capture. most people use permon normally, unless they have budget for other products.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
August 24, 2009 at 7:20 am
I agree Powershell would probably work, but I haven't tried it yet.
An alternative is SQLH2 Perfcollector. I have used it in the past to collect performance counter data and besides some initial configuration issues it usually worked just fine. http://sqlh2.codeplex.com/
[font="Verdana"]Markus Bohse[/font]
August 24, 2009 at 7:36 am
I've used SQLH2 in the past as well and for SQL 2000 and 2005 databases it's great. If it's a 2008 database then use the built in capabilities of CDC.
August 24, 2009 at 3:37 pm
keep it simple
set up your perf mon to fire off every 5-10 min and then set it save to cvs. Then you can just use EXCEL......after that you can refer to a few DMV out there....that we would any formation since the last reboot, restart of buffer flush
August 25, 2009 at 9:36 am
Check this article out:
http://www.sqlservercentral.com/links/599606/114781
I don't use it for historical, but in theory you could...free is free.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply