cpu intensive queries

SQL Server Tuning: Find Slow running queries using the Reports in SSMS

March 12, 2017 parmsingla Performance Tuning

Find Slow running queries using the Reports in SSMS 1) High CPU consuming Queries: To run the report right click[…]

SQL Server Tuning : Top 10 CPU Intensive Queries

March 12, 2017 parmsingla Performance Tuning

Problem Statement: Script to find top 10 CPU intensive queries. Solution: SELECT TOP 10 Object_name(qt.objectid) AS ‘SP Name’, Substring(qt.text, ( qs.statement_start_offset / 2 ) + 1, ( ( CASE qs.statement_end_offset WHEN –1 THEN Datalength(qt.text) ELSE qs.statement_end_offset END – qs.statement_start_offset ) / 2 ) + 1)[…]