You can technically query it like any other database but the details about the tables and such of the performance warehouse aren't detailed in any documentation as I don't believe it's generally recommended/supported to be querying it directly except in cases where it is recommended by support as part of working on an issue.
Is there any reason in particular you're looking to access it directly?
Hi James, first of all, existing web dashboards does not meet our requarements. In this case i want to use data collected by dynatrace to distpay it in different grapfical visualisation platforms.
I understand that but I would recommend looking into some of the realtime streaming options prior to attempting this. In addition there is a REST interface you can use to call and pull back measures from existing dashboards into a report in a format such as XML you can use to display in other systems.
Hello @Andrey S.,
Due to performance reasons the measurement data is held in the following different resolutions:
Due to the different nature of percentiles, the data is held only in the two following different resolutions:
Note: AppMon calculates and stores minimum, maximum, and average values for the aggregation interval in a single data point.
Thanks Babar. Do you have idea about TIMESTAMP column in MEASUREMENT_HIGH table for example 1489735500000 what is it in format DD:MM:YYYY HH24:MI:SS ?
Timeformat: hh:mm:ss or mm:ss (h: hours, m: minutes, s: seconds). The fixed size for a month (= 30 days) and a year (= 365 days).
Check the folloiwng link for the complete information:
Hello Babar. On Dynatrace Dashboard we got the following measure collected at 13:22 with count 4 (Screen 2.jpg). But maximum TIMESTAMP 2017-03-20 13:21:00 (Selected 13:26 from MEASUREMENT_TEMP2 Screen 1.jpg). The main question is: Where our measure at 13:22 with count 4 stored in database (in wich table)?
Check the following documented information about the tables and indexes.
Data is periodically (once per minute) inserted in one of the measurement_temp tables. AppMon inserts in a temp table for 30 minutes, then switches and moves the data for the now inactive temp table to the measurement_high table.
We recommend you keep the statistics (and indexes) up to date for the following tables (for databases other than embedded):