cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

instrumenting SQL server managed Stored procedures

srudolph
Guide

I found a web page where Andreas Grabner said back in 2005 or so that Dynatrace can instrumented SQL Server Managed stored procedures.

https://www.dynatrace.com/blog/instrumenting-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?

4 REPLIES 4

BabarQayyum
Leader

Hello Sam,

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:

https://answers.dynatrace.com/questions/171522/tra...

Regards,

Babar

srudolph
Guide

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.

BabarQayyum
Leader

Hello Sam,

The following limitations apply on the SQL Execution Plan:


  • Not supported for stored procedures. Statements that start with call, exec, {call or {exec should have the Show SQL Execution Plan option disabled.
  • If the DB cache has been cleared, prior execution plans are not available.
  • In order to request an execution plan the user must have the DB permission to view SQL statements and the AppMon one (Settings menu > Dynatrace Server > Settings item > Confidential Strings horizontal tab) to view confidential strings.
  • Using the jTDS driver for MSSQL enabling query preprocessing (JtdsStatement.setEscapeProcessing() method) may cause problems with looking up query execution plans as the query text will get modified.

Also check the following links:

https://community.dynatrace.com/community/display/...

https://community.dynatrace.com/community/display/...

Regards,

Babar

srudolph
Guide

Thanks ! We are going to be close to 90-95% stored procedures so the SQL agent probably won't help us much.