Post reply

SP Use

  • June 8, 2014 at 10:52 am

    #396879

    Hi,

    I am working in a particular application. My work is to tune the sp that are using by that particular application. First, I want to list out all Sprocs

    Is it possible to find that a particular Stored Procedure is using by which application?

    or

    List of name of the stored procedures that are using by a particular application in a db

  • June 9, 2014 at 1:54 am

    #1720008

    ramana3327 (6/8/2014)

    Hi,

    I am working in a particular application. My work is to tune the sp that are using by that particular application. First, I want to list out all Sprocs

    Is it possible to find that a particular Stored Procedure is using by which application?

    or

    List of name of the stored procedures that are using by a particular application in a db

    There are quite few examples around if you know what to look for, this should get you started.

    😎

    SELECT

    *

    FROM sys.dm_exec_connections EXCON

    INNER JOIN sys.dm_exec_sessions SESS

    ON EXCON.most_recent_session_id = SESS.session_id

    OUTER APPLY sys.dm_exec_sql_text(EXCON.most_recent_sql_handle) EXTXT

Viewing 2 posts - 1 through 1 (of 1 total)

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