\u4f18\u5316SQL\u5fc5\u5907\uff1a<\/p>\n
SELECT
\nTOP 1000 ST. TEXT AS ‘\u6267\u884c\u7684SQL\u8bed\u53e5’,
\nQS.execution_count AS ‘\u6267\u884c\u6b21\u6570’,
\nQS.total_elapsed_time AS ‘\u8017\u65f6’,
\nQS.total_logical_reads AS ‘\u903b\u8f91\u8bfb\u53d6\u6b21\u6570’,
\nQS.total_logical_writes AS ‘\u903b\u8f91\u5199\u5165\u6b21\u6570’,
\nQS.total_physical_reads AS ‘\u7269\u7406\u8bfb\u53d6\u6b21\u6570’,
\nQS.creation_time AS ‘\u6267\u884c\u65f6\u95f4’
\nFROM
\nsys.dm_exec_query_stats QS CROSS APPLY sys.dm_exec_sql_text (QS.sql_handle) ST
\nWHERE
\nQS.creation_time BETWEEN ‘2019-10-10 15:00:00.000’
\nAND ‘2019-10-22 18:00:00.000’
\nORDER BY
\nQS.total_elapsed_time DESC;<\/p>\n","protected":false},"excerpt":{"rendered":"
\u4f18\u5316SQL\u5fc5\u5907\uff1a SELECT TOP 1000 ST. TEXT AS ‘\u6267\u884c\u7684SQL\u8bed\u53e5’, QS.execution_count AS ‘\u6267\u884c\u6b21\u6570’, QS.total_elapsed_time AS ‘\u8017\u65f6’, QS.total_logical_reads AS ‘\u903b\u8f91\u8bfb\u53d6\u6b21\u6570’, QS.total_logical_writes AS ‘\u903b\u8f91\u5199\u5165\u6b21\u6570’, QS.total_physical_reads AS ‘\u7269\u7406\u8bfb\u53d6\u6b21\u6570’, QS.creation_time AS ‘\u6267\u884c\u65f6\u95f4’ FROM sys.dm_exec_query_stats QS CROSS APPLY sys.dm_exec_sql_text (QS.sql_handle) ST WHERE QS.creation_time BETWEEN ‘2019-10-10 15:00:00.000’ AND ‘2019-10-22 18:00:00.000’ ORDER BY QS.total_elapsed_time DESC;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-329","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"_links":{"self":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts\/329","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=329"}],"version-history":[{"count":0,"href":"http:\/\/22pig.com\/index.php?rest_route=\/wp\/v2\/posts\/329\/revisions"}],"wp:attachment":[{"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=329"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=329"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/22pig.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=329"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}