Business Transaction in MS SQL Structure
Hello all !
I'd like to know whether BT defined in DynaTrace is represented in any manner in MS SQL database ?
Is there and specific table in database structure that could show how many splittings were generated by each Business Transaction ?
Thanks,
.kr
Best Answer
Hi Krzysztof,
There is an alternative to using the measure health dashboard, you can execute the below SQL query to identify measures causing measure explosion:
select SYSTEMPROFILE.name as "systemprofilename", MEASURE.name as "measurename" ,count (DYNAMIC_MEASURE.id) as "instances" from MEASURE, SYSTEMPROFILE, DYNAMIC_MEASURE where SYSTEMPROFILE.id=DYNAMIC_MEASURE.SYSTEM_ID and MEASURE.SYSTEM_ID=SYSTEMPROFILE.id and MEASURE.id=DYNAMIC_MEASURE.CONF_ID and DYNAMIC_MEASURE.IS_DYNAMIC=1 group by DYNAMIC_MEASURE.CONF_ID,MEASURE.name,SYSTEMPROFILE.name order by count(*) DESC
Hope this helps.
Kind regards, Martina
Probably exactly what he's looking for Martina.
I suppose you can also add
MEASURE.name="your btname" and SYSTEMPROFILE.name="your sp name" to the where clause before the group by and just retrieve the one BT you want.
Best Answer
Hi Krzysztof,
If you have autopurge enabled, then your measures will be automatically purged after the duration of the medium resolution:
So if you have the default settings as above, your measures will be purged from PWH (DB) 2 months after you have deleted them.
It is not recommended to do manual changes in the PWH.
Is this acceptable for you?
Concerning the top contributors, you can chart the below measure from the dynaTrace Self-Monitoring system profile and perform desired filtering:
Please let us know if this is what you are looking to achieve.
Kind regards, Martina
Don't know why but I cannot select the measure suggested :/
Hi Krzysztof,
What role have you been assigned?
Can you try this workaround: open the measure health dashboard, copy the top contributors dashlet and paste it to a new dashboard.
Does this allow you to apply the filters and get the result you are looking for?
Kind regards, Martina
Yes, I does the job I was looking for :)
@Martina Resutikova @David Johnson
Thank you for all the support that you've provided !
.kr
At the very least you can open the "measure health" dashboard from start center (under monitoring) to see how many measurements are being generated from your BT's for the top contributors. The measure count should be relative to the splits.(likely not a 1:1 however).
@Martina Resutikova @David Johnson
Thank you for your input, it shows what I'd like to receive, but :)
please explain why there are also results from BT that I've already deleted kept in the Warehouse ?
As far as I understand I don't use this data for new BT I create. Is my understanding correct ?
If yes, is there any reason to kept this information in DB ?
Thanks,
.kr
To erase the DATA for those bt measures from the PW you can go to the measures section of the SP editor and find the business transaction, and right click and "erase data". Doing this ahead of the BT deletion can wipe that data out for you if you no longer need it.
David, as I check this only applies to the measures or BTs that are still present in DT. Is there anything I could do if I deleted them earlier ? :/
Btw, is it possible to chart "Top Contributors (Business Transactions)" only for selected BTs on separate (diferent from Measure Health) dashboard ?
Many thanks !
.kr
Welcome the
Dynatrace Community Forums
Check out the Forum User Guide and Forum Guidelines to learn how to get started.Community Member of the Month
August 2017
Announcing Dynatrace's Community Member of the Month for August 2017, Rick B.! Click here to read more! 
