• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
  • Home /
  • Public Forums /
  • Application Monitoring & UEM /
  • AppMon & UEM Open Q&A /
avatar image
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

Comment

People who like this

0 Show 0
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

4 Replies

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image
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

Comment
David J.
Krzysztof R.

People who like this

2 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

avatar image 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.

avatar image
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)
Comment

People who like this

0 Show 3 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

avatar image 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)
avatar image 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

avatar image 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

avatar image

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

Comment
Krzysztof R.

People who like this

1 Show 0 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

avatar image

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

Comment

People who like this

0 Show 2 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

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

avatar image 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.

avatar image 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

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

12 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

Configuration for JUnit Test Perfomance View (Business Transaction, Measure, Sensor pack methods)

Data past a certain date is gone

Is there a way to pass a specific parameter in the request header of the PureLytics stream or the Business Transaction feed?

Customizing of transactions behind web requests

how to configure dashboard for Amount of HTTP 500 errors in certain period of time in particular server?

Forum Tags

dotnet mobile monitoring load iis 6.5 kubernetes mainframe rest api dashboard framework 7.0 appmon 7 health monitoring adk log monitoring services auto-detection uem webserver test automation license web performance monitoring ios nam probe collector migration mq web services knowledge sharing reports window java hybris javascript appmon sensors good to know extensions search 6.3+ server documentation easytravel web dashboard kibana system profile purelytics docker splunk 6.1 process groups account 7.2 rest dynatrace saas spa guardian appmon administration production user actions postgresql upgrade oneagent measures security Dynatrace Managed transactionflow technologies diagnostics user session monitoring unique users continuous delivery sharing configuration alerting NGINX splitting business transaction client 6.3 installation database scheduler apache mobileapp RUM php dashlet azure purepath agent 7.1 appmonsaas messagebroker nodejs 6.2 android sensor performance warehouse
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A