[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 678
  • Last Modified:

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.
0
Wizilling
Asked:
Wizilling
1 Solution
 
AnujCommented:
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

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now