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

This product reached the end of support date on March 31, 2021.

how to get data from performance warehouse directly (from databse) ?

dynatrace2
Helper
 
11 REPLIES 11

JamesKitson
Dynatrace Leader
Dynatrace Leader

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?

James

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.

https://community.dynatrace.com/community/display/DOCDT65/Realtime+Streaming

dynatrace2
Helper

Btw. What is the difference between these tables ?






















NAME TYPE CATALOG
MEASUREMENT_HIGH TABLE DYNATRACE
MEASUREMENT_LOW TABLE DYNATRACE
MEASUREMENT_MID TABLE DYNATRACE

Babar_Qayyum
DynaMight Leader
DynaMight Leader

Hello @Andrey S.,

Due to performance reasons the measurement data is held in the following different resolutions:


  • High resolution: All data received within a minute is aggregated to a single data point
  • Mid resolution: All data received within an hour is aggregated to a single data point
  • Low resolution: All data received within a day is aggregated to a single data point

Due to the different nature of percentiles, the data is held only in the two following different resolutions:


  • High resolution: All data received within an hour is used for calculating the percentile
  • Low resolution: All data received within a day is used for calculating the percentile

Note: AppMon calculates and stores minimum, maximum, and average values for the aggregation interval in a single data point.

Regards,

Babar

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 ?


































COLUMN_NAME DATA_TYPE PK NULLABLE DEFAULT AUTOINCREMENT COMPUTED REMARKS JDBC Type SCALE/SIZE PRECISION POSITION
TIMESTAMP NUMBER(20) YES NO NO NO

Hello Andrey,

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:

https://community.dynatrace.com/community/display/DOCDT62/FAQ+-+Measures+and+Charting#FAQ-MeasuresandCharting-DynamicMeasuredef

Regards,

Babar

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)?

Babar_Qayyum
DynaMight Leader
DynaMight Leader

Hello Andrey,

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):


  • measurement_temp1
  • measurement_temp2
  • measurement_high
  • measurement_mid
  • measurement_low
  • percentiles_high (hourly inserts)
  • percentiles_low (daily inserts)
  • incidentrecords
  • dynamic_measure
  • test_expectation (for usage of Test Automation Explained only)

Regards,

Babar

dynatrace2
Helper

Could you be so kind to tell me where to find documented information about tables etc ..."Check the following documented information about the tables and indexes."

Babar_Qayyum
DynaMight Leader
DynaMight Leader

Hello Andrey,

The following link is for the 'Performance Warehouse Administration'.

https://community.dynatrace.com/community/display/...

Regards,

Babar