Perfmon - SQL Server - Baseline


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.
LVL 13
WizillingAsked:
Who is Participating?
 
AnujConnect With a Mentor SQL Server DBACommented:
PAL can do all this for you...

-- What is a good sampling rate? Is the default of 15 secs ok?
Default of 15 sec is okay unless you have not integrated your SQLProfiler trace with Windows perfmonitor log.

-- How long to keep the data in the databases? I assume the database will be huge.
If you are using PAL you don't need to load this data to database.

-- How do you compare against the baseline? Do I have to create scripts to compare data against baseline.
In PAL provide option to define your own baseline or threshold so the Performance data will be compared against the your threshold values.

--what is a good report tool (excel or ssrs) for this sort of perfmon comparisions?
I prefer SSRS, but again PAL gives you graphical reports too.



0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.