\u67e5\u770bsql\u8bb0\u5f55
use master;
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’ ,
QS.*
FROM sys.dm_exec_query_stats QS
CROSS APPLY
sys.dm_exec_sql_text(QS.sql_handle) ST
WHERE QS.creation_time >’2020-08-18′
ORDER BY
QS.total_elapsed_time DESC<\/p>\n\n\n\n
<\/p>\n\n\n\n
\u67e5\u8be2\u5de5\u5355\uff1a<\/p>\n\n\n\n
use SHCZ;
select SGMRAA.*,
A.DBA002 as RAA004C,DAA002 as RAA005C, DEA002,DEA003,IBB013,IBA004,DFA002,B.DBA002 AS RAA037C,IBB005 AS IBB005C,RAA018 AS RAA018C,DEA057 from SGMRAA left join TPADBA AS A on A.DBA001=RAA004 left join TPADAA on DAA001=RAA005 left join TPADEA on DEA001=RAA015 left join DCSIBB on ( IBB001=RAA011) and ( IBB002=RAA012) and ( RAA010=’32’) left join DCSIBA on ( IBA001=IBB001) left join TPADFA on DFA001=IBA004 left join TPADBA AS B on B.DBA001=RAA037 where ( SGMRAA.RAA003 >= ‘20221011’ ) order by SGMRAA.RAA001<\/p>\n\n\n\n
<\/p>\n\n\n\n
RAA001 \u5355\u53f7<\/p>\n\n\n\n
RAA002 \u6027\u8d28<\/p>\n\n\n\n
RAA003 \u5f00\u5355\u65e5\u671f<\/p>\n\n\n\n
RAA004 \u7ecf\u529e\u4eba<\/p>\n\n\n\n
RAA005 \u90e8\u95e8<\/p>\n\n\n\n
RAA006 \u9884\u8ba1\u5f00\u5de5\u65e5\u671f<\/p>\n\n\n\n
RAA007 \u9884\u8ba1\u5b8c\u5de5\u65e5\u671f<\/p>\n\n\n\n
RAA008 \u5b9e\u9645\u5f00\u5de5\u65e5\u671f<\/p>\n\n\n\n
RAA009 \u5b9e\u9645\u5b8c\u5de5\u65e5\u671f<\/p>\n\n\n\n
RAA010 \u672a\u77e5<\/p>\n\n\n\n
RAA011 RAA012 \u524d\u7f6e\u5355\u636e<\/p>\n\n\n\n
RAA015 \u4e3b\u4ef6\u54c1\u53f7<\/p>\n\n\n\n
RAA018 \u751f\u4ea7\u6570\u91cf<\/p>\n\n\n\n
RAA019 \u5df2\u751f\u4ea7\u91cf<\/p>\n\n\n\n
RAA020 \u5e94\u8be5\u662f \u5b8c\u5de5\u7801-\u5df2\u5b8c\u5de5<\/p>\n\n\n\n
RAA026 RAA027 \u9700\u6c42\u8ba1\u5212<\/p>\n\n\n\n
RAA005C \u90e8\u95e8<\/p>\n\n\n\n
DEA002 \u4ea7\u54c1\u540d\u79f0<\/p>\n\n\n\n
DEA003 \u5355\u4f4d<\/p>\n\n\n\n
IBB013 \u9884\u4ea4\u8d27\u65e5<\/p>\n\n\n\n
IBA004 \u5ba2\u6237\u7f16\u7801<\/p>\n\n\n\n
DFA002 <\/p>\n\n\n\n
<\/p>\n\n\n\n
<\/p>\n\n\n\n
\u751f\u4ea7\u8ba1\u5212 (\u4f3c\u4e4e\u65e0\u7528)<\/p>\n\n\n\n
use SHCZ;
Select SGMSAA.*,A.DBA002 as SAA004C,DAA002 as SAA005C,B.DBA002 as SAA014C from SGMSAA left join TPADBA A on A.DBA001=SAA004 left join TPADAA on DAA001=SAA005 left join TPADBA B on B.DBA001=SAA014 where ( SGMSAA.SAA003 >= ‘20221011’ ) order by SGMSAA.SAA001<\/p>\n\n\n\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
\u67e5\u770bsql\u8bb0\u5f55 use master;SELECT TOP 1000 ST.text AS ‘\u6267\u884c […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/www.aymoo.com\/index.php?rest_route=\/wp\/v2\/posts\/69"}],"collection":[{"href":"http:\/\/www.aymoo.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.aymoo.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.aymoo.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.aymoo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=69"}],"version-history":[{"count":4,"href":"http:\/\/www.aymoo.com\/index.php?rest_route=\/wp\/v2\/posts\/69\/revisions"}],"predecessor-version":[{"id":80,"href":"http:\/\/www.aymoo.com\/index.php?rest_route=\/wp\/v2\/posts\/69\/revisions\/80"}],"wp:attachment":[{"href":"http:\/\/www.aymoo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=69"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.aymoo.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=69"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.aymoo.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=69"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}