MSSQLWIKI

Karthick P.K on SQL Server

«
»

How to find all the profiler traces running on my SQL Server

Posted by Karthick P.K on April 26, 2010

select

      [Status] =

      case tr.[status]

            when 1 THEN 'Running'

            when 0 THEN 'Stopped'

      end

      ,[Default] =

            case tr.is_default

                  when 1 THEN 'System TRACE'

                  when 0 THEN 'User TRACE'

            end

       ,[login_name] = coalesce(se.login_name,se.login_name,'No reader spid')

      ,[Trace Path] = coalesce(tr.[Path],tr.[Path],'OLE DB Client Side Trace')

      from sys.traces tr

            left join sys.dm_exec_sessions se on tr.reader_spid = se.session_id

This entry was posted on April 26, 2010 at 1:42 PM and is filed under SQL Query. Tagged: , , . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

4 Responses to “How to find all the profiler traces running on my SQL Server”

  1. Query optimization « MSSQLWIKI said

    November 15, 2012 at 10:30 AM

    […] SQL Trace: Stop all the profiler traces running on the server. Identify the traces which are running on the server using the query in This Link […]

    Reply

  2. Top SQL Server blogs from MSSQLWIKI « MSSQLWIKI said

    January 11, 2014 at 12:59 PM

    […] How to find all the profiler traces running on my SQL Server […]

    Reply

  3. Shalanda Tanouye said

    May 28, 2018 at 5:52 AM

    How to find all the profiler traces running on my SQL Server

    […]It’s pure to have a few of these signs after a harmful occasion.[…]

    Reply

  4. April said

    March 15, 2020 at 12:11 AM

    Somebody please help explain this to me my husband locked me out of the phone and I don’t know what to do I need help in real life

    Reply

Leave a comment

«
»