Hey Luis,
the problem with collecting workload statistics over several days (e.g. whole
week in your case) is that averages computed over several days may be
very misleading when the workload changes considerably over that same period of
time.
I prefer the approach of Christian Antognini that he describes in his TOP book
(http://www.apress.com/9781430257585) on page 197/198.
Best Regards
Stefan Koehler
Freelance Oracle performance consultant and researcher
Homepage: http://www.soocs.de
Twitter: @OracleSK
Luis Santos <lsantos@xxxxxxxxx> hat am 2. September 2016 um 15:46 geschrieben:--
I ever been in doubt for how long should we collect system stats. The
majority of our system don´t have an OLTP vs DSS period. So the common
approach for collect system stats (and store the for later reuse) for OLTP
and DSS periods sounds no reasonable to me.
My current approach is collect for a full week period.
Can others please add his/her experiences on this subject?
--
Att
Luis Santos