Realizar consulta que liste os procedimentos mais lentos(demorados) que ocorrem dentro do banco de dados SQL Server SELECT TOP 20 GETDATE() AS ‘Collection Date’, qs.execution_count AS ‘Execution Count’, SUBSTRING(qt.text,qs.statement_start_offset/2 +1, (CASE WHEN qs.statement_end_offset = -1 THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2 ELSE qs.statement_end_offset END -qs.statement_start_offset)/2 ) AS ‘Query Text’, DB_NAME(qt.dbid) AS ‘DB Name’, qs.total_worker_time AS ‘Total […]