I have some questions regarding running perfmon on production sql servers. I will be storing the perfrmon values to a sql database.
I have use pal but i have to open the reports side by side to compare against. so was hoping to use some process to compare perfmon values against the baseline on the same chart /report
What is a good sampling rate? Is the default of 15 secs ok?
How long to keep the data in the databases? I assume the database will be huge.
How do you compare against the baseline? Do I have to create scripts to compare data against baseline.
what is a good report tool (excel or ssrs) for this sort of perfmon comparisions?
Are there any examples on the net that have charts to procedures to compare against the baseline.