I found a web page where Andreas Grabner said back in 2005 or so that Dynatrace can instrumented SQL Server Managed stored procedures.
It has a link to download what is needed from the community but the link does not work for me.
Is this still available and does it work for SQL server 2016?
The link is too old, therefore, moved somewhere else.
As well as I read that dynaTrace can not see into the stored procedure as this is code executed on your Oracle Database. We see the SQL Statements being executed through JDBC. If you want to analyze the inner-workings of your stored procedure you need to use Oracle specific tools.
Check the following post:
Thanks but I am looking for a Microsoft SQL server solution, don't think Oracle tools will help.
SQL Server Managed Stored Procedures are .net code and run under the .net clr. So I hope it is still available... we are about to go into production with this Managed Stored Procedure setup.
The following limitations apply on the SQL Execution Plan:
JtdsStatement.setEscapeProcessing()method) may cause problems with looking up query execution plans as the query text will get modified.
Also check the following links: