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
