Ab9145654904

SELECT

   t.text AS query_text,
   s.last_execution_time,
   s.execution_count,
   s.total_elapsed_time,
   s.total_logical_reads,
   s.total_logical_writes,
   s.max_logical_reads,
   s.max_logical_writes,
   s.creation_time,
   s.execution_type_desc,
   s.last_worker_time,
   s.last_elapsed_time,
   s.last_logical_reads,
   s.last_logical_writes,
   s.last_clr_time,
   s.last_physical_reads,
   s.last_rows_affected,
   s.last_rows_returned,
   s.last_rows_read,
   s.last_transaction_time,
   s.last_successful_execution_time,
   s.last_unsuccessful_execution_time,
   s.execution_result,
   s.is_cached

FROM sys.dm_exec_query_stats AS s CROSS APPLY sys.dm_exec_sql_text(s.sql_handle) AS t WHERE s.last_execution_time >= CONVERT(datetime, CONVERT(date, GETDATE()-1)) AND s.last_execution_time < CONVERT(datetime, CONVERT(date, GETDATE())) ORDER BY s.last_execution_time DESC