![SP_WhoIsActive is a Superior Alternative to sp_who on SQL Server | Rob Kraft's Software Development Blog SP_WhoIsActive is a Superior Alternative to sp_who on SQL Server | Rob Kraft's Software Development Blog](https://csharpdeveloper.files.wordpress.com/2012/08/spwhoisactive.png)
SP_WhoIsActive is a Superior Alternative to sp_who on SQL Server | Rob Kraft's Software Development Blog
![SQL Server - Using SP WhoIsActive to Identify Locks, Blocks, Slow Queries, Running Queries, and More - Dirceu Resende SQL Server - Using SP WhoIsActive to Identify Locks, Blocks, Slow Queries, Running Queries, and More - Dirceu Resende](https://dirceuresende.com/wp-content/uploads/2016/06/SQL-Server-sp_WhoIsActive-format_output.png)
SQL Server - Using SP WhoIsActive to Identify Locks, Blocks, Slow Queries, Running Queries, and More - Dirceu Resende
![SQL Server - Using SP WhoIsActive to Identify Locks, Blocks, Slow Queries, Running Queries, and More - Dirceu Resende SQL Server - Using SP WhoIsActive to Identify Locks, Blocks, Slow Queries, Running Queries, and More - Dirceu Resende](https://dirceuresende.com/wp-content/uploads/2016/06/SQL-Server-sp_WhoIsActive-show_own_pid-show_system_spids-show_sleeping_spids.png)
SQL Server - Using SP WhoIsActive to Identify Locks, Blocks, Slow Queries, Running Queries, and More - Dirceu Resende
![execution plan - Lots of "FETCH API_CURSOR0000..." on sp_WhoIsActive ( SQL Server 2008 R2 ) - Database Administrators Stack Exchange execution plan - Lots of "FETCH API_CURSOR0000..." on sp_WhoIsActive ( SQL Server 2008 R2 ) - Database Administrators Stack Exchange](https://i.stack.imgur.com/he5sV.png)
execution plan - Lots of "FETCH API_CURSOR0000..." on sp_WhoIsActive ( SQL Server 2008 R2 ) - Database Administrators Stack Exchange
![SQL Server - Using SP WhoIsActive to Identify Locks, Blocks, Slow Queries, Running Queries, and More - Dirceu Resende SQL Server - Using SP WhoIsActive to Identify Locks, Blocks, Slow Queries, Running Queries, and More - Dirceu Resende](https://dirceuresende.com/wp-content/uploads/2016/06/SQL-Server-sp_WhoIsActive-destination_table.png)
SQL Server - Using SP WhoIsActive to Identify Locks, Blocks, Slow Queries, Running Queries, and More - Dirceu Resende
![SQL Server - Using SP WhoIsActive to Identify Locks, Blocks, Slow Queries, Running Queries, and More - Dirceu Resende SQL Server - Using SP WhoIsActive to Identify Locks, Blocks, Slow Queries, Running Queries, and More - Dirceu Resende](https://dirceuresende.com/wp-content/uploads/2016/06/SQL-Server-sp_WhoIsActive-delta_interval.png)