sp_who2

Kill–use this weapon carefully in SQL SERVER . TIP #90

When we heard “Kill” then first impression of this word is very bad. We always scare with this word. In real world we never want this action  from anyone but in SQL Server case it is very helpful and help us many times. This feature we can use but very carefully. It is something like …

Easy way to diagnose SQL Server “sp_Who2” TIP #84

  Why the SQL Server is running slow ? What are the processes running currently on SQL SERVER instance ? Many other like the above which might help us to understand our current SQL Server instance health can be answered by a simple command “sp_who2”. “sp_Who2”  is an Undocumented command. You can utilize this command …