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?
Answer by Melanie Z. ·
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?
Answer by Rick B. ·
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
JANUARY 15, 3:00 PM GMT / 10:00 AM ET