go to bottom

how to use SQL Server Profiler to find a process?



database:xxxx



tool
    SQL Server Profiler
    Profiler setting
        event select
        display all events
        display all column
            column frofiler: ClientProcessID=PID
            # how to get a PID
            # 1. Ctrl+Shift+ESC
            # 2. app.exe --> turn to process --> PID
            # 3. done



# copy TextData
execute dbo.proc_xx_xxxxxx;1 @rq1 = '2023.01.01', @rq2 = '2023.01.01'



# this is a process
proc_xx_xxxxxx




# enter xxxx
programing
    process
        profiler
            name incloud = xxxxxx
            ok



# edit xxxxxx


# done

back to top