Post reply

Profiler:Tracing an encrypted Stored Procedure

  • March 18, 2005 at 4:16 pm

    #152368

    I was wondering if there was any way to identify\trace what an encrypted stored procedure is executing to help troubleshoot performance issues. I do not have access to the code before it was encrypted.

     

    Thanks,

    KatM

  • March 21, 2005 at 3:16 am

    #547965

    You could always just decrypt the SP to see what it's doing.

    I'm sure you'l find something usefull in the link below

    http://www.sqlsecurity.com/DesktopDefault.aspx?tabid=26

     

  • March 21, 2005 at 7:13 am

    #547993

    Monitor the query plan.

    Even thou the stored procedure is encrypted you may look at its execution (query) plan and find problematic operations.


    Andrey

  • March 21, 2005 at 7:21 am

    #547996

    I'd agree with that, but if you really want to get in depth with what should be indexed as opposed with what is currently being done then you'll also need to get your hands on the actual TSQL too.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply