cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Performance warehouse db volume

cromero
Newcomer

Hi team,

do you have a query to identify volumes/rows in PWDB, sort by SP and resolution ?

thank you

Cédric

2 REPLIES 2

Have a look here and here. Regards, Rajesh

peter_karlhuber
Dynatrace Pro
Dynatrace Pro

Hi Cédric,

you could try

select sp.name as "System profile name", count(*) "Nr of high res measurements"  from measurement_high as mh, dynamic_measure as dm, systemprofile as sp where mh.measure_id = dm.id and sp.id = dm.system_id group by sp.name

(tested on postgres)

which would give you the amount of measurements for the "high" resolution (i.e. 1 aggregated value per minute) and repeat the statement slightly modified for measurement_mid (1 value per hour) and measurment_low (1 value per day).

No guarantees that our data structures are optimized for this, though, so if you want to execute this regularly on a larger system I don't know how it'll perform. Best regards,

Peter