But when I am trying to execute the script on SQL Server 2005 with sysadmin rights, it's giving me below error on "CROSS APPLY sys.dm_exec_sql_text(Blocking.most_recent_sql_handle) AS BlockingSQL" line.

Error : Incorrect...

hi Rajib, Thanks for sharing a useful script.. Is this applicable for SQL Server 2008 and above?/

Thanks Dave...

One more question:

Will this query (Finding queries to tune) be executed in Master DB only???

Thanks for useful queries and suggestions.. I am writing for the first time on SQL Server Central.

I am trying to execute the query on Microsoft SQL Server 2008 R2...