Troubleshooting Database Slowness and Blocking with sp who, sp who2 and sp WhoIsActive

Description:
This video is about Troubleshooting Database Slowness and Blocking with sp_who, sp_who2 and sp_WhoIsActive [HD].
You can refer complete Text Tutorial on my website: www.SQLServerLog.com
You can join me on social networks:
Facebook: / sqlserverlog
Linkedin: / sqlserverlog
Google+: www.google.com/+SQLServerLogs
Twitter: / sqlserverlog

[@KRANTHIKUMAR-ko2fe]

Sir you just awesome....explanation and examples everything crystal clear....

[@RomanPeralta]

Excellent explanation Manzoor. Great video still effective.

[@Mr04Ankitgupta]

Good stuff..Could you please also share a session on Xquery

[@5888aj]

Great tutorial..

[@P5toraskar1986]

How can we stop blocking and deadlock in ms SQL. Every time kill is not possible right.

[@TechandArt]

Grt
learning

[@5888aj]

I have a question...
How do we resolve LCK_M_S wait_type issue??

[@radatann7701]

Hi admin page, could you share me procedure "sp_WhoIsActive". I cannot download it. could you help to share it !

[@hardiktalwar7471]

that sp_whoisactive is not available in your website please update your website that would be helpful

[@noorhirjee2274]

I CANNOT RUN SP_WHOISACTIVE

[@SQLServerLogs]

@Noor, you need to download it from given link. please read the article.