I need to know how to store session details in SQL Server, storing the time of data collection, hostname, username, query and information if it is blocking other sessions.
I would like to be able to see in the selected time range all the queries that were captured. I don't know if it is possible to collect that data and bring it using sp_who2 or sp_whoisactive
I would like to be able to see in the selected time range all the queries that were captured. I don't know if it is possible to collect that data and bring it using sp_who2 or sp_whoisactive