The following query listout the Query which took long time, What time executed
SELECT R.[Text] 'Query Used',
((q.Last_Elapsed_Time/1000.)/1000.) 'Time Taken (Seconds)',
q.Last_Execution_Time 'Executed Time'
FROM sys.dm_exec_query_stats q
CROSS APPLY SYS.DM_EXEC_SQL_TEXT(q.Plan_Handle) R
ORDER BY q.Last_Elapsed_Time DESC