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!
  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?
  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!
  4. Luis Martin Moderator

    You should find Profiler in Task Manager if it is running.
  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%'
  6. ashish287 New Member

    as behind every profiler there is trace so you can use :-
    SELECT * FROM :: fn_trace_getinfo(default)

Share This Page