sp_who and so_who2 stored procedures are used for activity monitoring in SQL Server.
In this video, I have explained the result set of these two stored procedures and what are the differences between them.
SP_WHO : Microsoft Documentation link
https://learn.microsoft.com/en-us/sql...
sp_who & sp_who2 doesn’t provide information on currently running SQL command such as start execution time, query execution duration, WAIT info and other information.
Adam Machanic (a Microsoft MVP) developed a stored procedure called “sp_whoisactive” to fill the gap between the actual needs of DBAs and the currently provided stored procedures (sp_who and sp_who2).
Download SP_WHOISACTIVE from the GitHub link pasted here
https://github.com/amachanic/sp_whois...
Watch video Difference between SP_WHO and SP_WHO2 in SQL Server | What is SP_WHOISACTIVE | SQL interview Q&A online without registration, duration hours minute second in high quality. This video was added by user Right to Learn @BK 02 September 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 762 once and liked it 54 people.