Post reply

How to find current activity through query analyzer?

  • April 25, 2007 at 3:37 am

    #118428

    Hi,

    I'm finding that I have some intermittent performance issues with an application I have inherited. Unfortunately as this is hosted externally I have no access to enterprise manager, so I was thinking that I would like to query the current activity through my web app. As just about everything else in enterprise manager can be achieved through stored procedures, are there any stored procs to query activity, locks etc?

    Thanks,

     

    Marcus

  • April 25, 2007 at 4:50 am

    #702327

    Marcus,

    You can probably use: sp_who2, sp_locks, DBCC INPUTBUFFER, DBCC OUTPUTBUFFER, the system tables/views and some of the SQL TRACE stored procedures (see BOL) to find how to use them..

    - James

    --
    James Moore
    Red Gate Software Ltd

  • April 25, 2007 at 4:56 am

    #702329

    There's a customised version of sp_who2 here:

    http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1144


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

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

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