系统函数 查看 query stats

 

                                        SELECT @@SERVERNAME AS server_name,
                                        SYSUTCDATETIME() AS collect_time,
                                        T.TEXT AS sql_statement,
                                        P.query_plan AS query_plan,
                                        sql_handle,
                                        statement_start_offset,
                                        statement_end_offset,
                                        plan_generation_num,
                                        plan_handle,
                                        creation_time,
                                        last_execution_time,
                                        execution_count,
                                        total_worker_time,
                                        last_worker_time,
                                        min_worker_time,
                                        max_worker_time,
                                        total_physical_reads,
                                        last_physical_reads,
                                        min_physical_reads,
                                        max_physical_reads,
                                        total_logical_writes,
                                        last_logical_writes,
                                        min_logical_writes,
                                        max_logical_writes,
                                        total_logical_reads,
                                        last_logical_reads,
                                        min_logical_reads,
                                        max_logical_reads,
                                        total_clr_time,
                                        last_clr_time,
                                        min_clr_time,
                                        max_clr_time,
                                        total_elapsed_time,
                                        last_elapsed_time,
                                        min_elapsed_time,
                                        max_elapsed_time,
                                        query_hash,
                                        query_plan_hash,
                                        1 AS IsLast
                                        FROM sys.dm_exec_query_stats S
                                        OUTER APPLY sys.dm_exec_sql_text(S.sql_handle) T
                                        OUTER APPLY sys.dm_exec_query_plan (S.plan_handle) P