Is it possible to create a measure to capture database time split by SQL?
Hi, I want to create a business transaction where I can trend out all my SQL calls (without bind values) over time. So, to do this, I believe I will need to create a BT that captures the timing for all DB calls, and then split it by SQL call. Is this possible to do?
Thanks Richard. Its just tough to do it individually b/c we have hundreds of stored procedures and I never know which one will get a new plan and start to perform badly. I was hoping I can just capture all DB calls and then split them by the SQL calls, then setup an alert if one of them starts deviating passed a certain threshold. Is this on the roadmap at all to enable split by SQL calls?
Hi Melanie,
Unfortunately not at this time. If you have particular calls you are interested in you can create measures (Server Side Performance -> Transaction based Measures -> Database -> Time) for those individually. While slightly more work, this method gives more useful results than a BT would anyway, since the BT result measures are aggregate per-transaction and the DB Time measure will actually give you the time for that individual query execution.
Hope that helps,
Rick B
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! 