Expensive Queries of a database
Expensive Queries of a database Following Query will find the expensive queries on specific database on SQL Instance. select DB_NAME(s.dbid) DBNAME , t.Text, spid from sysprocesses s CROSS APPLY sys.dm_exec_sql_text( s.sql_handle ) t where DB_NAME(s.dbid) like ‘Database_Name%’ Thank you for giving your valuable time… Read More