Monitoring Auditing Active Current Running Processes, TSQL queries in SQL Server using SYSPROCESSES and storing results in table
Submitted by manjunathcbhat on Mon, 06/16/2014 - 11:20So, we all know what sysprocesses and sp_who2 do. These gives us the current transactions/processes running on SQL Server Instance at a given moment of time.
Now, what if on a regular interval bases, I want to capture what all processes are running and what is the Query/Batch being running.