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...
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...
Смотрите видео Difference between SP_WHO and SP_WHO2 in SQL Server | What is SP_WHOISACTIVE | SQL interview Q&A онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Right to Learn @BK 02 Сентябрь 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 762 раз и оно понравилось 54 людям.