Query the DMV of the slowest Query

select Top 100
Qs. total_elapsed_time/qs.exe cution_count/1000000.0 as average_seconds,
Qs. total_elapsed_time/1000000.0 as total_seconds,
qs.exe cution_count,
substring (QT. text, Qs. statement_start_offset/2,
(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 individual_query,
O. name as object_name,
db_name (QT. dbid) as database_name
from sys. dm_exec_query_stats QS
Cross apply sys. dm_exec_ SQL _text (Qs. SQL _handle) as QT
left Outer Join sys. objects o on QT. objectid = O. object_id
where QT. dbid = db_id ()

Order by average_seconds DESC;

For more query statements, refer to the original post:

Http://www.sqlservercentral.com/Forums/Topic619606-360-1.aspx