如何安装sp_whoisactive存储过程

1. 下载sp_whoisactive存储过程的脚本文件，可以从SQLSkills网站或GitHub下载。例如，可以使用以下命令在SQL Server Management Studio（SSMS）中下载脚本：

EXEC sp_helptext 'sp_whoisactive'

2. 打开脚本并将其复制到新查询窗口。然后执行该脚本以创建存储过程。
3. 在需要使用sp_whoisactive存储过程的数据库中，使用以下语句授权并创建存储过程：

USE [database_name]
GRANT EXECUTE ON [dbo].[sp_whoisactive] TO [user_name]
GO

CREATE PROCEDURE [dbo].[sp_whoisactive]
  @filter sysname = NULL,
  @filter_type NVARCHAR(128) = 'session',
  @not_filter sysname = NULL,
  @not_filter_type NVARCHAR(128) = 'session',
  @show_own_spid BIT = 0,
  @show_system_spids BIT = 0,
  @show_sleeping_spids BIT = 0,
  @show_outer_sessions BIT = 0,
  @show_system_processes BIT = 0,
  @show_activity_spid BIT = 0,
  @get_full_inner_text BIT = 0,
  @get_plans BIT = 0,
  @xml BIT = 0,
  @get_task_info BIT = 0,
  @find_block_leaders BIT = 0,
  @delta_interval INT = NULL,
  @output_column_list NVARCHAR(MAX) = NULL,
  @sort_order NVARCHAR(60) = '[start_time] ASC',
  @output_column_list_header BIT = 1,
  @verbose BIT = 0,
  @find_block_leaders_timeout INT = 2,
  @destination_table VARCHAR(4) = NULL,
  @refresh_interval INT = NULL,
  @schema VARCHAR(128) = 'dbo',
  @help BIT = 0,
  @delay INT = 0
AS
... 

4. 您可以使用以下语句来运行存