SQL Server Tuning – Top 10 high memory consuming Queries

Problem Statement: Script to find top 10 high memory consuming 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[…]

Read more