Best Way to Co-Relating Different Performance Monitoring Stats?
We r carrying out a Perf Test, but we r employing a silo approach, where we monitor the SQL Ser DB (Perf Mon), App server and the Network during the tests individually. Then I need to co-relate all the data. I am planning to use Excel, I am afraid that it might turn out to be tedious and time consuming.
R there any other tools (free / Evaluation) that I can use to co-relate my performance monitoring stats?
NOTE: We r not using any automated tools here.
Any advise would help.
Education is a progressive discovery of our own ignorance......Will Durant
Re: Best Way to Co-Relating Different Performance Monitoring Stats?
why not use a free (open source) database like MySQL
My client does not approve installing anything that is not on their allowed list.
Excel is, MySQL is not. SO I have learned to become really proficient with Excel.
In other situations, I have used any type of database I could lay my hands on as it makes great sense to put your result in a database.
My use of Excel does not automatically exclude use of a database.