if exists (select * from sys.objects where object_id = object_id(N'[dbo].[get_statements_from_waiter_list]’) and OBJECTPROPERTY(object_id, N’IsProcedure’) = 1) drop procedure [dbo].[get_statements_from_waiter_list] go create proc get_statements_from_waiter_list (@wait_type nvarchar(60)=NULL) as select r.wait_type ,r.wait_time ,SUBSTRING(qt.text,r.statement_start_offset/2, (case when r.statement_end_offset = -1 then len(convert(nvarchar(max), qt.text)) * 2 else r.statement_end_offset end -r.statement_start_offset)/2) as query_text ,qt.dbid, dbname=db_name(qt.dbid) ,qt.objectid ,r.sql_handle ,(SELECT query_plan FROM sys.dm_exec_query_plan (r.plan_handle)) as […]