Business Transaction in MS SQL Structure

Question

Question by Krzysztof R. · Oct 21, 2015 at 10:24 AM · configuration business transaction server

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

0

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 1 · 2015-10-22T15:03:37Z

Best Answer

Answer by Martina R. · Oct 22, 2015 at 03:03 PM

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

2 Show 1 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

David J. · Oct 22, 2015 at 03:08 PM 0

Share

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.

Answer 2 · 2015-10-23T08:25:10Z

Best Answer

Answer by Martina R. · Oct 23, 2015 at 08:25 AM

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

autopurge.png (20.1 KiB)

topcontributors.png (18.9 KiB)

0 Show 3 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Krzysztof R. · Oct 23, 2015 at 08:42 AM 0

Share

Don't know why but I cannot select the measure suggested :/

measure-picer.png (47.6 KiB)

Martina R. Krzysztof R. · Oct 23, 2015 at 08:54 AM 0

Share

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

Krzysztof R. Martina R. · Oct 23, 2015 at 09:24 AM 0

Share

Yes, I does the job I was looking for :)

@Martina Resutikova@David Johnson

Thank you for all the support that you've provided !

.kr

Answer 3 · 2015-10-21T14:11:01Z

Answer by David J. · Oct 21, 2015 at 02:11 PM

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

1 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Answer 4 · 2015-10-22T15:37:12Z

Answer by Krzysztof R. · Oct 22, 2015 at 03:37 PM

@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

0 Show 2 · Share

10 |2000000 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

David J. · Oct 22, 2015 at 04:53 PM 0

Share

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.

Krzysztof R. David J. · Oct 23, 2015 at 07:16 AM 0

Share

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

Business Transaction in MS SQL Structure

4 Replies

How to get started:

NAM 2019 SP3 is available

LIVE WEBINAR

Follow this Question

Related Questions

Forum Tags