Difference between SP_WHO and SP_WHO2 in SQL Server | What is SP_WHOISACTIVE | SQL interview Q&A

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/relational-databases/system-stored-procedures/sp-who-transact-sql?view=sql-server-ver16

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_whoisactive/releases

Тэги:

#sp_who #sp_who2 #what_is_sp_who #what_is_sp_who2 #sp_who2_in_sql_server

Скачать видео