What, When, Where, How, Who2
Some background on sp_who2 from Jason Brimhall and a dive into the inner workings of how to find current activity on an SQL instance.
2010-06-14
12,108 reads
sp_who2
View connection and Locking Information
This script combines sp_who2 and sp_lock to get meaning full info that includes host Ip address
2010-05-17 (first published: 2009-06-23)
2,460 reads
usp_SQL_In_sp_who2
Ammends the sp_who2 procedure with the input buffer contents, ususally the SQL statement for that SPID
2009-04-24 (first published: 2009-03-27)
1,217 reads
Indepth SPID information
This SP gives you most of the detail you need on a long running query. Simply pass the SPID.
2009-01-09 (first published: 2008-12-31)
2,013 reads
Blogs
Why I am running for the PASS Board in 2020
By HamishWatson
This blog post lists the reasons why I felt the need to run for...
Blog Refresh – Growing Readers
By gbargsley
Happy Tuesday everyone… In early 2017 I started blogging on this site in hopes...
Daily Coping 27 Oct 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Question about Data Warehouse
Hello. I just rejoined SQL Server Central. I'm here because I'm a solo reports...
Help Writing a Udf that get Number of "Years in a row"
Hello. I have a table (say orderlines) with orderrows, There is a column...
SSIS 2017 stopped running, not status is Pending Execution
We have 3 sql agent jobs that are running SSIS packages. Until this past...
Ask SSC