Charting Perfmon counters
-
Hi all,
Is there any way to capture the outpup of Perfmon and create a chart (perhaps in Excel?) for a single period of time?
Thanks,
Jaybee.
-
There is a third-party tool tool that can do these for you. Check for tools in sites like quest or red-gate they have plenty of tools and cn be used with ease.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com -
Hi Jay Bee,
You can set up perfmon counter logs to be written to the native binary file (the default) or you can use other formats.
You can log to CSV, tab-delimited, and even SQL server. This option is set on the "Log Files" tab of the counter logs properties
From there you can use your favorite charting tool (Excel, perhaps) to read the logs and present them however you want.
-
What Jeff says can be done but it will take yup some of your time but sure that you will learn stuff with using excel and maipulating data using excel.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com -
If you have values already stored in a binary log format, you can use relog to convert them.
Description of the Windows XP Logman.exe, Relog.exe, and Typeperf.exe Tools (303133)
K. Brian Kelley
@kbriankelley -
Excel has long been a passion of mine but one I never had time to indulge!!
Jaybee.
-
Then go ahead play with it you can do lot of things with excel 2003 or later.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com -
This tool has been around for awhile but I still use it. SQLH2 uses Reporting Services so it helps to be familiar with that. I just export the perfmon charts to EXCEL and print them out as needed. The canned reports saved me some work.
Regards,
Phoenix DBA
-
If you are interested in just SQL Server counters, you can query the sysperfinfo table. However, you will want to do a little research as some of the values in sysperfinfo are accumulated values and not point in time values. However, I have used this approach quite successfully in the past for generating SQL Server metrics.
Gordon Pollokoff
"Wile E. is my reality, Bugs Bunny is my goal" - Chuck Jones
-
Not sure about what your goal is, but if it is just to visualize the data better. Try the new Performance Reports from MS. http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply