[Orca-users] Charting Procallator Collected data

[Joe Munson]

I only did this once to see if it would be useful. I configured and ODBC
SystemDSN for perfmon and configured perfmon to log to MSSQL (so it
would create the needed tables), then I used relog to move the .TSV
files into the MSSQL database.

 

I followed the steps at this site to make pivot tables and graphs in
Excel that use the SQL database:
http://www.sql-server-performance.com/gv_baselining_tips.asp

 

The big advantage that is has over an RRD graph is that you can drill
down into specific start and end dates pretty easily. The setup and
automation was overly complicated, so I gave up and used the Orca script
to make snapshots of the HTML/PNG directories instead.

 

Hope that helps

 

--Joe

 

________________________________

From: orca-users-bounces+joe.munson=swc.com at orcaware.com
[mailto:orca-users-bounces+joe.munson=swc.com at orcaware.com] On Behalf Of
csarid
Sent: Thursday, January 25, 2007 1:17 PM
To: orca-users at orcaware.com
Subject: [Orca-users] Charting Procallator Collected data

 

Hello Everyone,

 

 

I am looking for information on using collected procallator data in
excel for charting. Has anyone tried this? and if so, can you please
provide any information or point me to a site that may have this info. 

 

Thanks Very much!

  

________________________________

Don't be flakey. Get Yahoo! Mail for Mobile
<http://us.rd.yahoo.com/evt=43909/*http:/mobile.yahoo.com/mail>  and 
always stay connected
<http://us.rd.yahoo.com/evt=43909/*http:/mobile.yahoo.com/mail>  to
friends.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/orca-users/attachments/20070126/b1013ea8/attachment-0002.html>