SQL Server Performance

Is profiler Already On

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by danny123, Sep 20, 2010.

  1. danny123 New Member

    Hi there,
    Is there any way to find out if the profiler is already ON for a specific server?
    Thanks!
    danny123, Sep 20, 2010
    #2

  2. satya Moderator

    How many users have ADMIN privileges on that server?
    Did you check the active transactions on the server and see what is running?
    satya, Sep 20, 2010
    #3

  3. danny123 New Member

    Hi Satya,
    I am the only admin and but we have several projects which are outsourced. Lately the project went live and we are working on the production issue.
    So I want to make sure on my end that there is no other profiler running on the server.
    This is more of a general question.
    Thanks!
    danny123, Sep 20, 2010
    #4

  4. Luis Martin Moderator

    You should find Profiler in Task Manager if it is running.
    Luis Martin, Sep 20, 2010
    #5

  5. satya Moderator

    for such doubts you can obtain the current execution status on SQL server to see if there are PROFILER :
    SELECT * FROM sys.dm_exec_sessions where program_name like '%PROF%'
    satya, Sep 30, 2010
    #6

  6. ashish287 New Member

    as behind every profiler there is trace so you can use :-
    SELECT * FROM :: fn_trace_getinfo(default)
    ashish287, Sep 20, 2010
    #7

Share This Page