Post reply

SQL Profiler JTDS

  • January 26, 2010 at 2:15 am

    #142012

    Hi , I have system that when I profile I get lots of long runnig quireis which seemed to follow this format

    "exe jdts14343 'parm1','pram2'"

    Is here any way i can find out what that query actual is?

    Many thanks

  • January 26, 2010 at 3:39 am

    #1108542

    Not sure if I am missing something - would you simply look in

    [dbName] >>> Programmability >>> Stored Procedures

    through the ssms object explorer??

  • January 26, 2010 at 5:00 am

    #1108566

    sorry a missed out a #

    the textdata of the SQL profile trace shows

    "exec #jtds232232 'parm1'"

    #jtds id not alwasy followed by the same numbers. this is not a stored procedure, but something coming in over a java conection.

    Many thanks

  • January 26, 2010 at 5:30 am

    #1108580

    Pretty sure that would be a temporary sp - so would be stored in the tempdb...

    guessing - but could it be that the app is creating the sp as part of its call ??

  • January 26, 2010 at 6:36 am

    #1108616

    HI thanks I will run another profile and see if I can find the SP's in temp. Many thanks

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

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