{"id":44391,"date":"2025-06-18T17:18:01","date_gmt":"2025-06-18T09:18:01","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/44391.html"},"modified":"2025-06-18T17:18:01","modified_gmt":"2025-06-18T09:18:01","slug":"sql-server-%e6%95%b0%e6%8d%ae%e5%ba%93%e6%95%85%e9%9a%9c%e4%b8%8e%e6%80%a7%e8%83%bd%e9%ab%98%e6%95%88%e5%ae%9e%e6%97%b6%e7%9b%91%e6%b5%8b%e6%8a%80%e6%9c%af%e6%b7%b1%e5%ba%a6%e8%a7%a3%e6%9e%90","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/44391.html","title":{"rendered":"SQL Server \u6570\u636e\u5e93\u6545\u969c\u4e0e\u6027\u80fd\u9ad8\u6548\u5b9e\u65f6\u76d1\u6d4b\u6280\u672f\u6df1\u5ea6\u89e3\u6790"},"content":{"rendered":"

\"\u5728\u8fd9\u91cc\u63d2\u5165\u56fe\u7247\u63cf\u8ff0\"<\/p>\n

\u5173\u952e\u8bcd： SQL Server \u6545\u969c\u4e0e\u6027\u80fd\u76d1\u63a7\u3001\u6570\u636e\u5e93\u76d1\u6d4b\u3001\u5b9e\u65f6\u76d1\u63a7\u3001\u6027\u80fd\u8c03\u4f18<\/p>\n

\n

📋 \u6587\u7ae0\u76ee\u5f55<\/h3>\n

1. \u5f15\u8a00\u4e0e\u76d1\u63a7\u91cd\u8981\u6027<\/h4>\n

2. SQL Server \u76d1\u63a7\u57fa\u7840\u67b6\u6784<\/h4>\n

3. \u6545\u969c\u76d1\u6d4b\u6280\u672f\u6df1\u5ea6\u89e3\u6790<\/h4>\n

4. \u6027\u80fd\u76d1\u63a7\u6838\u5fc3\u6280\u672f<\/h4>\n

5. \u5b9e\u65f6\u76d1\u6d4b\u5de5\u5177\u4e0e\u89e3\u51b3\u65b9\u6848<\/h4>\n

6. \u76d1\u63a7\u6700\u4f73\u5b9e\u8df5\u4e0e\u6848\u4f8b<\/h4>\n

7. \u603b\u7ed3\u4e0e\u5c55\u671b<\/h4>\n
\n

1. \u5f15\u8a00\u4e0e\u76d1\u63a7\u91cd\u8981\u6027<\/h3>\n

\u5728\u5f53\u4eca\u6570\u636e\u9a71\u52a8\u7684\u5546\u4e1a\u73af\u5883\u4e2d，SQL Server\u6570\u636e\u5e93\u4f5c\u4e3a\u4f01\u4e1a\u6838\u5fc3\u6570\u636e\u5b58\u50a8\u548c\u5904\u7406\u5e73\u53f0，\u5176\u7a33\u5b9a\u6027\u548c\u6027\u80fd\u76f4\u63a5\u5f71\u54cd\u4e1a\u52a1\u8fde\u7eed\u6027\u3002\u636e\u7edf\u8ba1，\u6570\u636e\u5e93\u6545\u969c\u9020\u6210\u7684\u4e1a\u52a1\u635f\u5931\u6bcf\u5c0f\u65f6\u53ef\u8fbe\u6570\u4e07\u81f3\u6570\u767e\u4e07\u5143，\u56e0\u6b64\u5efa\u7acb\u9ad8\u6548\u7684\u5b9e\u65f6\u76d1\u6d4b\u4f53\u7cfb\u81f3\u5173\u91cd\u8981\u3002<\/p>\n

1.1 \u76d1\u63a7\u7684\u6838\u5fc3\u4ef7\u503c<\/h4>\n

\u9884\u9632\u6027\u7ef4\u62a4： \u901a\u8fc7\u6301\u7eed\u76d1\u63a7，\u5728\u95ee\u9898\u53d1\u751f\u524d\u8bc6\u522b\u6f5c\u5728\u98ce\u9669 \u5feb\u901f\u54cd\u5e94： \u5b9e\u65f6\u544a\u8b66\u673a\u5236\u786e\u4fdd\u6545\u969c\u7b2c\u4e00\u65f6\u95f4\u88ab\u53d1\u73b0\u548c\u5904\u7406 \u6027\u80fd\u4f18\u5316： \u57fa\u4e8e\u76d1\u63a7\u6570\u636e\u8fdb\u884c\u6027\u80fd\u8c03\u4f18，\u63d0\u5347\u7cfb\u7edf\u6548\u7387 \u5bb9\u91cf\u89c4\u5212： \u901a\u8fc7\u5386\u53f2\u6570\u636e\u5206\u6790，\u5408\u7406\u89c4\u5212\u8d44\u6e90\u6269\u5bb9<\/p>\n

1.2 \u76d1\u63a7\u6311\u6218\u4e0e\u89e3\u51b3\u601d\u8def<\/h4>\n

#mermaid-svg-GUt2ce4jZoP7CWCu {font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;fill:#333;}#mermaid-svg-GUt2ce4jZoP7CWCu .error-icon{fill:#552222;}#mermaid-svg-GUt2ce4jZoP7CWCu .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-GUt2ce4jZoP7CWCu .edge-thickness-normal{stroke-width:2px;}#mermaid-svg-GUt2ce4jZoP7CWCu .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-GUt2ce4jZoP7CWCu .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-GUt2ce4jZoP7CWCu .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-GUt2ce4jZoP7CWCu .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-GUt2ce4jZoP7CWCu .marker{fill:#333333;stroke:#333333;}#mermaid-svg-GUt2ce4jZoP7CWCu .marker.cross{stroke:#333333;}#mermaid-svg-GUt2ce4jZoP7CWCu svg{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-GUt2ce4jZoP7CWCu .label{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;color:#333;}#mermaid-svg-GUt2ce4jZoP7CWCu .cluster-label text{fill:#333;}#mermaid-svg-GUt2ce4jZoP7CWCu .cluster-label span{color:#333;}#mermaid-svg-GUt2ce4jZoP7CWCu .label text,#mermaid-svg-GUt2ce4jZoP7CWCu span{fill:#333;color:#333;}#mermaid-svg-GUt2ce4jZoP7CWCu .node rect,#mermaid-svg-GUt2ce4jZoP7CWCu .node circle,#mermaid-svg-GUt2ce4jZoP7CWCu .node ellipse,#mermaid-svg-GUt2ce4jZoP7CWCu .node polygon,#mermaid-svg-GUt2ce4jZoP7CWCu .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-GUt2ce4jZoP7CWCu .node .label{text-align:center;}#mermaid-svg-GUt2ce4jZoP7CWCu .node.clickable{cursor:pointer;}#mermaid-svg-GUt2ce4jZoP7CWCu .arrowheadPath{fill:#333333;}#mermaid-svg-GUt2ce4jZoP7CWCu .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-GUt2ce4jZoP7CWCu .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-GUt2ce4jZoP7CWCu .edgeLabel{background-color:#e8e8e8;text-align:center;}#mermaid-svg-GUt2ce4jZoP7CWCu .edgeLabel rect{opacity:0.5;background-color:#e8e8e8;fill:#e8e8e8;}#mermaid-svg-GUt2ce4jZoP7CWCu .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-GUt2ce4jZoP7CWCu .cluster text{fill:#333;}#mermaid-svg-GUt2ce4jZoP7CWCu .cluster span{color:#333;}#mermaid-svg-GUt2ce4jZoP7CWCu div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#mermaid-svg-GUt2ce4jZoP7CWCu :root{–mermaid-font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;} <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

\u76d1\u63a7\u6311\u6218 <\/p>\n

\u6570\u636e\u91cf\u5e9e\u5927 <\/p>\n

\u5b9e\u65f6\u6027\u8981\u6c42\u9ad8 <\/p>\n

\u591a\u7ef4\u5ea6\u76d1\u63a7 <\/p>\n

\u544a\u8b66\u7cbe\u51c6\u6027 <\/p>\n

\u91c7\u6837\u7b56\u7565\u4f18\u5316 <\/p>\n

\u6d41\u5f0f\u5904\u7406\u6280\u672f <\/p>\n

\u7edf\u4e00\u76d1\u63a7\u5e73\u53f0 <\/p>\n

\u667a\u80fd\u544a\u8b66\u7b97\u6cd5 <\/p>\n

\u9ad8\u6548\u76d1\u63a7\u89e3\u51b3\u65b9\u6848 <\/p>\n

\n

2. SQL Server \u76d1\u63a7\u57fa\u7840\u67b6\u6784<\/h3>\n

2.1 \u76d1\u63a7\u67b6\u6784\u6982\u89c8<\/h4>\n

\u4e00\u4e2a\u5b8c\u6574\u7684SQL Server\u76d1\u63a7\u7cfb\u7edf\u5e94\u8be5\u5305\u542b\u6570\u636e\u6536\u96c6\u3001\u5b58\u50a8\u3001\u5206\u6790\u548c\u5c55\u793a\u56db\u4e2a\u6838\u5fc3\u5c42\u6b21：<\/p>\n

#mermaid-svg-Rr6bR3RZQhezg1qZ {font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;fill:#333;}#mermaid-svg-Rr6bR3RZQhezg1qZ .error-icon{fill:#552222;}#mermaid-svg-Rr6bR3RZQhezg1qZ .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-Rr6bR3RZQhezg1qZ .edge-thickness-normal{stroke-width:2px;}#mermaid-svg-Rr6bR3RZQhezg1qZ .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-Rr6bR3RZQhezg1qZ .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-Rr6bR3RZQhezg1qZ .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-Rr6bR3RZQhezg1qZ .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-Rr6bR3RZQhezg1qZ .marker{fill:#333333;stroke:#333333;}#mermaid-svg-Rr6bR3RZQhezg1qZ .marker.cross{stroke:#333333;}#mermaid-svg-Rr6bR3RZQhezg1qZ svg{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-Rr6bR3RZQhezg1qZ .label{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;color:#333;}#mermaid-svg-Rr6bR3RZQhezg1qZ .cluster-label text{fill:#333;}#mermaid-svg-Rr6bR3RZQhezg1qZ .cluster-label span{color:#333;}#mermaid-svg-Rr6bR3RZQhezg1qZ .label text,#mermaid-svg-Rr6bR3RZQhezg1qZ span{fill:#333;color:#333;}#mermaid-svg-Rr6bR3RZQhezg1qZ .node rect,#mermaid-svg-Rr6bR3RZQhezg1qZ .node circle,#mermaid-svg-Rr6bR3RZQhezg1qZ .node ellipse,#mermaid-svg-Rr6bR3RZQhezg1qZ .node polygon,#mermaid-svg-Rr6bR3RZQhezg1qZ .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-Rr6bR3RZQhezg1qZ .node .label{text-align:center;}#mermaid-svg-Rr6bR3RZQhezg1qZ .node.clickable{cursor:pointer;}#mermaid-svg-Rr6bR3RZQhezg1qZ .arrowheadPath{fill:#333333;}#mermaid-svg-Rr6bR3RZQhezg1qZ .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-Rr6bR3RZQhezg1qZ .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-Rr6bR3RZQhezg1qZ .edgeLabel{background-color:#e8e8e8;text-align:center;}#mermaid-svg-Rr6bR3RZQhezg1qZ .edgeLabel rect{opacity:0.5;background-color:#e8e8e8;fill:#e8e8e8;}#mermaid-svg-Rr6bR3RZQhezg1qZ .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-Rr6bR3RZQhezg1qZ .cluster text{fill:#333;}#mermaid-svg-Rr6bR3RZQhezg1qZ .cluster span{color:#333;}#mermaid-svg-Rr6bR3RZQhezg1qZ div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#mermaid-svg-Rr6bR3RZQhezg1qZ :root{–mermaid-font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;} <\/p>\n

\u5c55\u793a\u5206\u6790\u5c42 <\/p>\n

\u6570\u636e\u5904\u7406\u5c42 <\/p>\n

\u6570\u636e\u6536\u96c6\u5c42 <\/p>\n

\u6570\u636e\u6e90\u5c42 <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

\u5b9e\u65f6\u4eea\u8868\u677f <\/p>\n

\u5386\u53f2\u62a5\u8868 <\/p>\n

\u544a\u8b66\u901a\u77e5 <\/p>\n

\u79fb\u52a8\u7aef\u76d1\u63a7 <\/p>\n

\u6570\u636e\u6e05\u6d17 <\/p>\n

\u805a\u5408\u8ba1\u7b97 <\/p>\n

\u5f02\u5e38\u68c0\u6d4b <\/p>\n

\u544a\u8b66\u5f15\u64ce <\/p>\n

DMV\u67e5\u8be2 <\/p>\n

\u6269\u5c55\u4e8b\u4ef6 <\/p>\n

\u6027\u80fd\u76d1\u89c6\u5668 <\/p>\n

PowerShell\u6536\u96c6\u5668 <\/p>\n

SQL Server\u5b9e\u4f8b <\/p>\n

Windows\u6027\u80fd\u8ba1\u6570\u5668 <\/p>\n

\u4e8b\u4ef6\u65e5\u5fd7 <\/p>\n

\u81ea\u5b9a\u4e49\u76d1\u63a7\u811a\u672c <\/p>\n

2.2 \u6838\u5fc3\u76d1\u63a7\u6307\u6807\u4f53\u7cfb<\/h4>\n

2.2.1 \u7cfb\u7edf\u7ea7\u6307\u6807<\/h5>\n\n\u6307\u6807\u7c7b\u522b\u5173\u952e\u6307\u6807\u6b63\u5e38\u8303\u56f4\u544a\u8b66\u9608\u503c<\/tr>\n\n\n\n\n\n
CPU\u4f7f\u7528\u7387<\/td>\n%Processor Time<\/td>\n< 70%<\/td>\n> 80%<\/td>\n<\/tr>\n
\u5185\u5b58\u4f7f\u7528<\/td>\nAvailable Memory<\/td>\n> 2GB<\/td>\n< 1GB<\/td>\n<\/tr>\n
\u78c1\u76d8I\/O<\/td>\nDisk Queue Length<\/td>\n< 2<\/td>\n> 4<\/td>\n<\/tr>\n
\u7f51\u7edc<\/td>\nNetwork Utilization<\/td>\n< 50%<\/td>\n> 80%<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
2.2.2 \u6570\u636e\u5e93\u7ea7\u6307\u6807<\/h5>\n\n\u6307\u6807\u7c7b\u522b\u5173\u952e\u6307\u6807\u76d1\u63a7\u9891\u7387\u91cd\u8981\u7ea7\u522b<\/tr>\n\n\n\n\n\n
\u8fde\u63a5\u6570<\/td>\nUser Connections<\/td>\n\u5b9e\u65f6<\/td>\n\u9ad8<\/td>\n<\/tr>\n
\u9501\u7b49\u5f85<\/td>\nLock Waits\/sec<\/td>\n\u5b9e\u65f6<\/td>\n\u9ad8<\/td>\n<\/tr>\n
\u9875\u9762\u8bfb\u5199<\/td>\nPage Reads\/sec<\/td>\n1\u5206\u949f<\/td>\n\u4e2d<\/td>\n<\/tr>\n
\u7f13\u51b2\u547d\u4e2d\u7387<\/td>\nBuffer Cache Hit Ratio<\/td>\n5\u5206\u949f<\/td>\n\u4e2d<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\n

3. \u6545\u969c\u76d1\u6d4b\u6280\u672f\u6df1\u5ea6\u89e3\u6790<\/h3>\n

3.1 \u6545\u969c\u7c7b\u578b\u5206\u7c7b\u4e0e\u76d1\u6d4b\u7b56\u7565<\/h4>\n

#mermaid-svg-S2rjTF0CLhF4AaEf {font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;fill:#333;}#mermaid-svg-S2rjTF0CLhF4AaEf .error-icon{fill:#552222;}#mermaid-svg-S2rjTF0CLhF4AaEf .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-S2rjTF0CLhF4AaEf .edge-thickness-normal{stroke-width:2px;}#mermaid-svg-S2rjTF0CLhF4AaEf .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-S2rjTF0CLhF4AaEf .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-S2rjTF0CLhF4AaEf .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-S2rjTF0CLhF4AaEf .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-S2rjTF0CLhF4AaEf .marker{fill:#333333;stroke:#333333;}#mermaid-svg-S2rjTF0CLhF4AaEf .marker.cross{stroke:#333333;}#mermaid-svg-S2rjTF0CLhF4AaEf svg{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-S2rjTF0CLhF4AaEf .label{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;color:#333;}#mermaid-svg-S2rjTF0CLhF4AaEf .cluster-label text{fill:#333;}#mermaid-svg-S2rjTF0CLhF4AaEf .cluster-label span{color:#333;}#mermaid-svg-S2rjTF0CLhF4AaEf .label text,#mermaid-svg-S2rjTF0CLhF4AaEf span{fill:#333;color:#333;}#mermaid-svg-S2rjTF0CLhF4AaEf .node rect,#mermaid-svg-S2rjTF0CLhF4AaEf .node circle,#mermaid-svg-S2rjTF0CLhF4AaEf .node ellipse,#mermaid-svg-S2rjTF0CLhF4AaEf .node polygon,#mermaid-svg-S2rjTF0CLhF4AaEf .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-S2rjTF0CLhF4AaEf .node .label{text-align:center;}#mermaid-svg-S2rjTF0CLhF4AaEf .node.clickable{cursor:pointer;}#mermaid-svg-S2rjTF0CLhF4AaEf .arrowheadPath{fill:#333333;}#mermaid-svg-S2rjTF0CLhF4AaEf .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-S2rjTF0CLhF4AaEf .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-S2rjTF0CLhF4AaEf .edgeLabel{background-color:#e8e8e8;text-align:center;}#mermaid-svg-S2rjTF0CLhF4AaEf .edgeLabel rect{opacity:0.5;background-color:#e8e8e8;fill:#e8e8e8;}#mermaid-svg-S2rjTF0CLhF4AaEf .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-S2rjTF0CLhF4AaEf .cluster text{fill:#333;}#mermaid-svg-S2rjTF0CLhF4AaEf .cluster span{color:#333;}#mermaid-svg-S2rjTF0CLhF4AaEf div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#mermaid-svg-S2rjTF0CLhF4AaEf :root{–mermaid-font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;} <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

SQL Server\u6545\u969c <\/p>\n

\u786c\u4ef6\u6545\u969c <\/p>\n

\u8f6f\u4ef6\u6545\u969c <\/p>\n

\u7f51\u7edc\u6545\u969c <\/p>\n

\u4eba\u4e3a\u6545\u969c <\/p>\n

\u78c1\u76d8\u6545\u969c <\/p>\n

\u5185\u5b58\u6545\u969c <\/p>\n

CPU\u6545\u969c <\/p>\n

\u6570\u636e\u5e93\u635f\u574f <\/p>\n

\u670d\u52a1\u5f02\u5e38 <\/p>\n

\u914d\u7f6e\u9519\u8bef <\/p>\n

\u8fde\u63a5\u8d85\u65f6 <\/p>\n

\u7f51\u7edc\u4e2d\u65ad <\/p>\n

\u5e26\u5bbd\u4e0d\u8db3 <\/p>\n

\u8bef\u64cd\u4f5c <\/p>\n

\u6743\u9650\u914d\u7f6e <\/p>\n

\u7ef4\u62a4\u9519\u8bef <\/p>\n

3.2 \u6269\u5c55\u4e8b\u4ef6(Extended Events)\u76d1\u63a7<\/h4>\n

\u6269\u5c55\u4e8b\u4ef6\u662fSQL Server 2008\u4ee5\u540e\u7248\u672c\u63d0\u4f9b\u7684\u8f7b\u91cf\u7ea7\u76d1\u63a7\u6846\u67b6，\u76f8\u6bd4SQL Trace\u5177\u6709\u66f4\u4f4e\u7684\u6027\u80fd\u5f00\u9500\u3002<\/p>\n

3.2.1 \u521b\u5efa\u6545\u969c\u76d1\u63a7\u4f1a\u8bdd<\/h5>\n

— \u521b\u5efa\u6b7b\u9501\u76d1\u63a7\u4f1a\u8bdd<\/span>
\nCREATE<\/span> EVENT SESSION<\/span> [<\/span>DeadlockMonitor]<\/span> ON<\/span> SERVER
\nADD<\/span> EVENT sqlserver.<\/span>xml_deadlock_report(<\/span>
\n ACTION<\/span>(<\/span>sqlserver.<\/span>client_app_name,<\/span>
\n sqlserver.<\/span>database_id,<\/span>
\n sqlserver.<\/span>username)<\/span>
\n)<\/span>,<\/span>
\nADD<\/span> EVENT sqlserver.<\/span>lock_deadlock_chain(<\/span>
\n ACTION<\/span>(<\/span>sqlserver.<\/span>client_app_name,<\/span>
\n sqlserver.<\/span>database_id,<\/span>
\n sqlserver.<\/span>username)<\/span>
\n)<\/span>
\nADD<\/span> TARGET package0.<\/span>event_file(<\/span>
\n SET<\/span> filename=<\/span>N'D:\\\\Logs\\\\DeadlockMonitor.xel'<\/span>,<\/span>
\n max_file_size=<\/span>(<\/span>100<\/span>)<\/span>,<\/span>
\n max_rollover_files=<\/span>(<\/span>10<\/span>)<\/span>
\n)<\/span>
\nWITH<\/span> (<\/span>MAX_MEMORY=<\/span>4096<\/span> KB,<\/span>
\n EVENT_RETENTION_MODE=<\/span>ALLOW_SINGLE_EVENT_LOSS,<\/span>
\n MAX_DISPATCH_LATENCY=<\/span>30<\/span> SECONDS,<\/span>
\n MAX_EVENT_SIZE=<\/span>0<\/span> KB,<\/span>
\n MEMORY_PARTITION_MODE=<\/span>NONE,<\/span>
\n TRACK_CAUSALITY=<\/span>OFF<\/span>,<\/span>
\n STARTUP_STATE=<\/span>ON<\/span>)<\/span>;<\/span><\/p>\n

— \u542f\u52a8\u4f1a\u8bdd<\/span>
\nALTER<\/span> EVENT SESSION<\/span> [<\/span>DeadlockMonitor]<\/span> ON<\/span> SERVER STATE =<\/span> START<\/span>;<\/span><\/p>\n

3.2.2 \u963b\u585e\u76d1\u63a7\u4f1a\u8bdd<\/h5>\n

— \u521b\u5efa\u963b\u585e\u76d1\u63a7\u4f1a\u8bdd<\/span>
\nCREATE<\/span> EVENT SESSION<\/span> [<\/span>BlockingMonitor]<\/span> ON<\/span> SERVER
\nADD<\/span> EVENT sqlserver.<\/span>blocked_process_report(<\/span>
\n ACTION<\/span>(<\/span>sqlserver.<\/span>client_app_name,<\/span>
\n sqlserver.<\/span>database_id,<\/span>
\n sqlserver.<\/span>sql_text,<\/span>
\n sqlserver.<\/span>username)<\/span>
\n WHERE<\/span> duration ><\/span> 5000<\/span> — \u963b\u585e\u8d85\u8fc75\u79d2<\/span>
\n)<\/span>,<\/span>
\nADD<\/span> EVENT sqlserver.<\/span>lock_timeout(<\/span>
\n ACTION<\/span>(<\/span>sqlserver.<\/span>client_app_name,<\/span>
\n sqlserver.<\/span>database_id,<\/span>
\n sqlserver.<\/span>sql_text)<\/span>
\n)<\/span>
\nADD<\/span> TARGET package0.<\/span>ring_buffer(<\/span>
\n SET<\/span> max_memory =<\/span> 8192<\/span>
\n)<\/span>;<\/span><\/p>\n

3.3 Always On\u53ef\u7528\u6027\u7ec4\u76d1\u63a7<\/h4>\n

#mermaid-svg-CKBSnOH3ctT11Qhl {font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;fill:#333;}#mermaid-svg-CKBSnOH3ctT11Qhl .error-icon{fill:#552222;}#mermaid-svg-CKBSnOH3ctT11Qhl .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-CKBSnOH3ctT11Qhl .edge-thickness-normal{stroke-width:2px;}#mermaid-svg-CKBSnOH3ctT11Qhl .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-CKBSnOH3ctT11Qhl .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-CKBSnOH3ctT11Qhl .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-CKBSnOH3ctT11Qhl .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-CKBSnOH3ctT11Qhl .marker{fill:#333333;stroke:#333333;}#mermaid-svg-CKBSnOH3ctT11Qhl .marker.cross{stroke:#333333;}#mermaid-svg-CKBSnOH3ctT11Qhl svg{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-CKBSnOH3ctT11Qhl .label{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;color:#333;}#mermaid-svg-CKBSnOH3ctT11Qhl .cluster-label text{fill:#333;}#mermaid-svg-CKBSnOH3ctT11Qhl .cluster-label span{color:#333;}#mermaid-svg-CKBSnOH3ctT11Qhl .label text,#mermaid-svg-CKBSnOH3ctT11Qhl span{fill:#333;color:#333;}#mermaid-svg-CKBSnOH3ctT11Qhl .node rect,#mermaid-svg-CKBSnOH3ctT11Qhl .node circle,#mermaid-svg-CKBSnOH3ctT11Qhl .node ellipse,#mermaid-svg-CKBSnOH3ctT11Qhl .node polygon,#mermaid-svg-CKBSnOH3ctT11Qhl .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-CKBSnOH3ctT11Qhl .node .label{text-align:center;}#mermaid-svg-CKBSnOH3ctT11Qhl .node.clickable{cursor:pointer;}#mermaid-svg-CKBSnOH3ctT11Qhl .arrowheadPath{fill:#333333;}#mermaid-svg-CKBSnOH3ctT11Qhl .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-CKBSnOH3ctT11Qhl .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-CKBSnOH3ctT11Qhl .edgeLabel{background-color:#e8e8e8;text-align:center;}#mermaid-svg-CKBSnOH3ctT11Qhl .edgeLabel rect{opacity:0.5;background-color:#e8e8e8;fill:#e8e8e8;}#mermaid-svg-CKBSnOH3ctT11Qhl .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-CKBSnOH3ctT11Qhl .cluster text{fill:#333;}#mermaid-svg-CKBSnOH3ctT11Qhl .cluster span{color:#333;}#mermaid-svg-CKBSnOH3ctT11Qhl div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#mermaid-svg-CKBSnOH3ctT11Qhl :root{–mermaid-font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;} <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

Always On\u76d1\u63a7 <\/p>\n

\u4e3b\u526f\u672c\u76d1\u63a7 <\/p>\n

\u8f85\u52a9\u526f\u672c\u76d1\u63a7 <\/p>\n

\u6570\u636e\u540c\u6b65\u76d1\u63a7 <\/p>\n

\u4e3b\u526f\u672c\u5065\u5eb7\u72b6\u6001 <\/p>\n

\u65e5\u5fd7\u751f\u6210\u901f\u5ea6 <\/p>\n

\u672a\u53d1\u9001\u65e5\u5fd7\u5927\u5c0f <\/p>\n

\u526f\u672c\u8fde\u63a5\u72b6\u6001 <\/p>\n

\u6570\u636e\u540c\u6b65\u72b6\u6001 <\/p>\n

\u6545\u969c\u8f6c\u79fb\u5c31\u7eea\u72b6\u6001 <\/p>\n

\u53d1\u9001\u961f\u5217\u5927\u5c0f <\/p>\n

\u91cd\u505a\u961f\u5217\u5927\u5c0f <\/p>\n

\u6570\u636e\u4e22\u5931\u65f6\u95f4 <\/p>\n

3.3.1 \u53ef\u7528\u6027\u7ec4\u5065\u5eb7\u68c0\u67e5\u811a\u672c<\/h5>\n

— Always On\u53ef\u7528\u6027\u7ec4\u72b6\u6001\u76d1\u63a7<\/span>
\nSELECT<\/span>
\n ag.<\/span>name AS<\/span> AvailabilityGroup,<\/span>
\n r.<\/span>replica_server_name AS<\/span> ServerName,<\/span>
\n r.<\/span>availability_mode_desc AS<\/span> AvailabilityMode,<\/span>
\n r.<\/span>failover_mode_desc AS<\/span> FailoverMode,<\/span>
\n rs.<\/span>role_desc AS<\/span> ReplicaRole,<\/span>
\n rs.<\/span>connected_state_desc AS<\/span> ConnectionState,<\/span>
\n rs.<\/span>synchronization_health_desc AS<\/span> SyncHealth,<\/span>
\n drs.<\/span>database_name AS<\/span> DatabaseName,<\/span>
\n drs.<\/span>synchronization_state_desc AS<\/span> SyncState,<\/span>
\n drs.<\/span>log_send_queue_size AS<\/span> LogSendQueueKB,<\/span>
\n drs.<\/span>redo_queue_size AS<\/span> RedoQueueKB,<\/span>
\n drs.<\/span>last_commit_time AS<\/span> LastCommitTime
\nFROM<\/span> sys.<\/span>availability_groups ag
\nINNER<\/span> JOIN<\/span> sys.<\/span>availability_replicas r ON<\/span> ag.<\/span>group_id =<\/span> r.<\/span>group_id
\nINNER<\/span> JOIN<\/span> sys.<\/span>dm_hadr_availability_replica_states rs ON<\/span> r.<\/span>replica_id =<\/span> rs.<\/span>replica_id
\nLEFT<\/span> JOIN<\/span> sys.<\/span>dm_hadr_database_replica_states drs ON<\/span> rs.<\/span>replica_id =<\/span> drs.<\/span>replica_id
\nORDER<\/span> BY<\/span> ag.<\/span>name,<\/span> r.<\/span>replica_server_name,<\/span> drs.<\/span>database_name;<\/span><\/p>\n

\n

4. \u6027\u80fd\u76d1\u63a7\u6838\u5fc3\u6280\u672f<\/h3>\n

4.1 \u67e5\u8be2\u6027\u80fd\u76d1\u63a7\u4f53\u7cfb<\/h4>\n

#mermaid-svg-S4OidMiWNcWWo60F {font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;fill:#333;}#mermaid-svg-S4OidMiWNcWWo60F .error-icon{fill:#552222;}#mermaid-svg-S4OidMiWNcWWo60F .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-S4OidMiWNcWWo60F .edge-thickness-normal{stroke-width:2px;}#mermaid-svg-S4OidMiWNcWWo60F .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-S4OidMiWNcWWo60F .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-S4OidMiWNcWWo60F .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-S4OidMiWNcWWo60F .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-S4OidMiWNcWWo60F .marker{fill:#333333;stroke:#333333;}#mermaid-svg-S4OidMiWNcWWo60F .marker.cross{stroke:#333333;}#mermaid-svg-S4OidMiWNcWWo60F svg{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-S4OidMiWNcWWo60F .label{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;color:#333;}#mermaid-svg-S4OidMiWNcWWo60F .cluster-label text{fill:#333;}#mermaid-svg-S4OidMiWNcWWo60F .cluster-label span{color:#333;}#mermaid-svg-S4OidMiWNcWWo60F .label text,#mermaid-svg-S4OidMiWNcWWo60F span{fill:#333;color:#333;}#mermaid-svg-S4OidMiWNcWWo60F .node rect,#mermaid-svg-S4OidMiWNcWWo60F .node circle,#mermaid-svg-S4OidMiWNcWWo60F .node ellipse,#mermaid-svg-S4OidMiWNcWWo60F .node polygon,#mermaid-svg-S4OidMiWNcWWo60F .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-S4OidMiWNcWWo60F .node .label{text-align:center;}#mermaid-svg-S4OidMiWNcWWo60F .node.clickable{cursor:pointer;}#mermaid-svg-S4OidMiWNcWWo60F .arrowheadPath{fill:#333333;}#mermaid-svg-S4OidMiWNcWWo60F .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-S4OidMiWNcWWo60F .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-S4OidMiWNcWWo60F .edgeLabel{background-color:#e8e8e8;text-align:center;}#mermaid-svg-S4OidMiWNcWWo60F .edgeLabel rect{opacity:0.5;background-color:#e8e8e8;fill:#e8e8e8;}#mermaid-svg-S4OidMiWNcWWo60F .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-S4OidMiWNcWWo60F .cluster text{fill:#333;}#mermaid-svg-S4OidMiWNcWWo60F .cluster span{color:#333;}#mermaid-svg-S4OidMiWNcWWo60F div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#mermaid-svg-S4OidMiWNcWWo60F :root{–mermaid-font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;} <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

\u67e5\u8be2\u6027\u80fd\u76d1\u63a7 <\/p>\n

\u6267\u884c\u8ba1\u5212\u5206\u6790 <\/p>\n

\u7b49\u5f85\u7edf\u8ba1\u5206\u6790 <\/p>\n

I\/O\u7edf\u8ba1\u5206\u6790 <\/p>\n

\u8d44\u6e90\u6d88\u8017\u5206\u6790 <\/p>\n

\u7d22\u5f15\u4f7f\u7528\u60c5\u51b5 <\/p>\n

\u64cd\u4f5c\u7b26\u6210\u672c <\/p>\n

\u5e76\u884c\u5ea6\u5206\u6790 <\/p>\n

\u9501\u7b49\u5f85 <\/p>\n

I\/O\u7b49\u5f85 <\/p>\n

CPU\u7b49\u5f85 <\/p>\n

\u903b\u8f91\u8bfb\u53d6 <\/p>\n

\u7269\u7406\u8bfb\u53d6 <\/p>\n

\u9875\u9762\u5206\u5272 <\/p>\n

CPU\u65f6\u95f4 <\/p>\n

\u6267\u884c\u65f6\u95f4 <\/p>\n

\u5185\u5b58\u6388\u6743 <\/p>\n

4.1.1 \u67e5\u8be2\u5b58\u50a8(Query Store)\u914d\u7f6e<\/h5>\n

— \u542f\u7528\u67e5\u8be2\u5b58\u50a8<\/span>
\nALTER<\/span> DATABASE<\/span> [<\/span>YourDatabase]<\/span>
\nSET<\/span> QUERY_STORE =<\/span> ON<\/span> (<\/span>
\n OPERATION_MODE =<\/span> READ_WRITE,<\/span>
\n CLEANUP_POLICY =<\/span> (<\/span>STALE_QUERY_THRESHOLD_DAYS =<\/span> 30<\/span>)<\/span>,<\/span>
\n DATA_FLUSH_INTERVAL_SECONDS =<\/span> 900<\/span>,<\/span>
\n INTERVAL_LENGTH_MINUTES =<\/span> 60<\/span>,<\/span>
\n MAX_STORAGE_SIZE_MB =<\/span> 1024<\/span>,<\/span>
\n QUERY_CAPTURE_MODE =<\/span> AUTO,<\/span>
\n SIZE_BASED_CLEANUP_MODE =<\/span> AUTO
\n)<\/span>;<\/span><\/p>\n

— \u67e5\u8be2\u6027\u80fd\u56de\u9000\u7684SQL<\/span>
\nSELECT<\/span>
\n qsq.<\/span>query_id,<\/span>
\n qsqt.<\/span>query_sql_text,<\/span>
\n qsrs.<\/span>count_executions,<\/span>
\n qsrs.<\/span>avg_duration \/<\/span> 1000<\/span> AS<\/span> avg_duration_ms,<\/span>
\n qsrs.<\/span>avg_cpu_time \/<\/span> 1000<\/span> AS<\/span> avg_cpu_time_ms,<\/span>
\n qsrs.<\/span>avg_logical_io_reads,<\/span>
\n qsrs.<\/span>avg_physical_io_reads
\nFROM<\/span> sys.<\/span>query_store_query qsq
\nINNER<\/span> JOIN<\/span> sys.<\/span>query_store_query_text qsqt ON<\/span> qsq.<\/span>query_text_id =<\/span> qsqt.<\/span>query_text_id
\nINNER<\/span> JOIN<\/span> sys.<\/span>query_store_plan qsp ON<\/span> qsq.<\/span>query_id =<\/span> qsp.<\/span>query_id
\nINNER<\/span> JOIN<\/span> sys.<\/span>query_store_runtime_stats qsrs ON<\/span> qsp.<\/span>plan_id =<\/span> qsrs.<\/span>plan_id
\nWHERE<\/span> qsrs.<\/span>last_execution_time >=<\/span> DATEADD(<\/span>day<\/span>,<\/span> –<\/span>7<\/span>,<\/span> GETUTCDATE(<\/span>)<\/span>)<\/span>
\n AND<\/span> qsrs.<\/span>avg_duration ><\/span> 10000<\/span> — \u5e73\u5747\u6267\u884c\u65f6\u95f4\u8d85\u8fc710\u79d2<\/span>
\nORDER<\/span> BY<\/span> qsrs.<\/span>avg_duration DESC<\/span>;<\/span><\/p>\n

4.2 \u7d22\u5f15\u6027\u80fd\u76d1\u63a7<\/h4>\n

4.2.1 \u7f3a\u5931\u7d22\u5f15\u5206\u6790<\/h5>\n

— \u5206\u6790\u7f3a\u5931\u7d22\u5f15\u5efa\u8bae<\/span>
\nSELECT<\/span>
\n migs.<\/span>avg_total_user_cost *<\/span> (<\/span>migs.<\/span>avg_user_impact \/<\/span> 100.0<\/span>)<\/span> *<\/span> (<\/span>migs.<\/span>user_seeks +<\/span> migs.<\/span>user_scans)<\/span> AS<\/span> improvement_measure,<\/span>
\n 'CREATE INDEX [IX_'<\/span> +<\/span> OBJECT_NAME(<\/span>mid.<\/span>object_id)<\/span> +<\/span> '_'<\/span> +<\/span>
\n REPLACE<\/span>(<\/span>REPLACE<\/span>(<\/span>REPLACE<\/span>(<\/span>ISNULL(<\/span>mid.<\/span>equality_columns,<\/span>''<\/span>)<\/span>,<\/span> ', '<\/span>,<\/span> '_'<\/span>)<\/span>,<\/span> '['<\/span>,<\/span> ''<\/span>)<\/span>,<\/span> ']'<\/span>,<\/span> ''<\/span>)<\/span> +<\/span>
\n CASE<\/span> WHEN<\/span> mid.<\/span>inequality_columns IS<\/span> NOT<\/span> NULL<\/span> THEN<\/span> '_'<\/span> +<\/span>
\n REPLACE<\/span>(<\/span>REPLACE<\/span>(<\/span>REPLACE<\/span>(<\/span>mid.<\/span>inequality_columns,<\/span> ', '<\/span>,<\/span> '_'<\/span>)<\/span>,<\/span> '['<\/span>,<\/span> ''<\/span>)<\/span>,<\/span> ']'<\/span>,<\/span> ''<\/span>)<\/span>
\n ELSE<\/span> ''<\/span> END<\/span> +<\/span> ']'<\/span> +<\/span>
\n ' ON '<\/span> +<\/span> mid.<\/span>statement +<\/span>
\n ' ('<\/span> +<\/span> ISNULL (<\/span>mid.<\/span>equality_columns,<\/span>''<\/span>)<\/span> +<\/span>
\n CASE<\/span> WHEN<\/span> mid.<\/span>equality_columns IS<\/span> NOT<\/span> NULL<\/span> AND<\/span> mid.<\/span>inequality_columns IS<\/span> NOT<\/span> NULL<\/span> THEN<\/span> ','<\/span> ELSE<\/span> ''<\/span> END<\/span> +<\/span>
\n ISNULL (<\/span>mid.<\/span>inequality_columns,<\/span> ''<\/span>)<\/span> +<\/span> ')'<\/span> +<\/span>
\n ISNULL (<\/span>' INCLUDE ('<\/span> +<\/span> mid.<\/span>included_columns +<\/span> ')'<\/span>,<\/span> ''<\/span>)<\/span> AS<\/span> create_index_statement,<\/span>
\n migs.<\/span>*<\/span>,<\/span> mid.<\/span>database_id,<\/span> mid.<\/span>[<\/span>object_id]<\/span>
\nFROM<\/span> sys.<\/span>dm_db_missing_index_groups mig
\nINNER<\/span> JOIN<\/span> sys.<\/span>dm_db_missing_index_group_stats migs ON<\/span> migs.<\/span>group_handle =<\/span> mig.<\/span>index_group_handle
\nINNER<\/span> JOIN<\/span> sys.<\/span>dm_db_missing_index_details mid ON<\/span> mig.<\/span>index_handle =<\/span> mid.<\/span>index_handle
\nWHERE<\/span> migs.<\/span>avg_total_user_cost *<\/span> (<\/span>migs.<\/span>avg_user_impact \/<\/span> 100.0<\/span>)<\/span> *<\/span> (<\/span>migs.<\/span>user_seeks +<\/span> migs.<\/span>user_scans)<\/span> ><\/span> 10<\/span>
\nORDER<\/span> BY<\/span> migs.<\/span>avg_total_user_cost *<\/span> migs.<\/span>avg_user_impact *<\/span> (<\/span>migs.<\/span>user_seeks +<\/span> migs.<\/span>user_scans)<\/span> DESC<\/span>;<\/span><\/p>\n

4.2.2 \u7d22\u5f15\u788e\u7247\u76d1\u63a7<\/h5>\n

— \u7d22\u5f15\u788e\u7247\u5206\u6790<\/span>
\nSELECT<\/span>
\n OBJECT_SCHEMA_NAME(<\/span>ips.<\/span>object_id)<\/span> AS<\/span> schema_name,<\/span>
\n OBJECT_NAME(<\/span>ips.<\/span>object_id)<\/span> AS<\/span> object_name,<\/span>
\n i.<\/span>name AS<\/span> index_name,<\/span>
\n ips.<\/span>index_type_desc,<\/span>
\n ips.<\/span>avg_fragmentation_in_percent,<\/span>
\n ips.<\/span>page_count,<\/span>
\n CASE<\/span>
\n WHEN<\/span> ips.<\/span>avg_fragmentation_in_percent ><\/span> 30<\/span> THEN<\/span> 'REBUILD'<\/span>
\n WHEN<\/span> ips.<\/span>avg_fragmentation_in_percent ><\/span> 10<\/span> THEN<\/span> 'REORGANIZE'<\/span>
\n ELSE<\/span> 'NO ACTION'<\/span>
\n END<\/span> AS<\/span> recommended_action
\nFROM<\/span> sys.<\/span>dm_db_index_physical_stats(<\/span>DB_ID(<\/span>)<\/span>,<\/span> NULL<\/span>,<\/span> NULL<\/span>,<\/span> NULL<\/span>,<\/span> 'LIMITED'<\/span>)<\/span> ips
\nINNER<\/span> JOIN<\/span> sys.<\/span>indexes i ON<\/span> ips.<\/span>object_id =<\/span> i.<\/span>object_id AND<\/span> ips.<\/span>index_id =<\/span> i.<\/span>index_id
\nWHERE<\/span> ips.<\/span>avg_fragmentation_in_percent ><\/span> 10<\/span>
\n AND<\/span> ips.<\/span>page_count ><\/span> 1000<\/span> — \u53ea\u5173\u6ce8\u5927\u4e8e1000\u9875\u7684\u7d22\u5f15<\/span>
\nORDER<\/span> BY<\/span> ips.<\/span>avg_fragmentation_in_percent DESC<\/span>;<\/span><\/p>\n

4.3 \u5185\u5b58\u4f7f\u7528\u76d1\u63a7<\/h4>\n

#mermaid-svg-X3xkmkfEnlwvmAvT {font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;fill:#333;}#mermaid-svg-X3xkmkfEnlwvmAvT .error-icon{fill:#552222;}#mermaid-svg-X3xkmkfEnlwvmAvT .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-X3xkmkfEnlwvmAvT .edge-thickness-normal{stroke-width:2px;}#mermaid-svg-X3xkmkfEnlwvmAvT .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-X3xkmkfEnlwvmAvT .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-X3xkmkfEnlwvmAvT .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-X3xkmkfEnlwvmAvT .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-X3xkmkfEnlwvmAvT .marker{fill:#333333;stroke:#333333;}#mermaid-svg-X3xkmkfEnlwvmAvT .marker.cross{stroke:#333333;}#mermaid-svg-X3xkmkfEnlwvmAvT svg{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-X3xkmkfEnlwvmAvT .label{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;color:#333;}#mermaid-svg-X3xkmkfEnlwvmAvT .cluster-label text{fill:#333;}#mermaid-svg-X3xkmkfEnlwvmAvT .cluster-label span{color:#333;}#mermaid-svg-X3xkmkfEnlwvmAvT .label text,#mermaid-svg-X3xkmkfEnlwvmAvT span{fill:#333;color:#333;}#mermaid-svg-X3xkmkfEnlwvmAvT .node rect,#mermaid-svg-X3xkmkfEnlwvmAvT .node circle,#mermaid-svg-X3xkmkfEnlwvmAvT .node ellipse,#mermaid-svg-X3xkmkfEnlwvmAvT .node polygon,#mermaid-svg-X3xkmkfEnlwvmAvT .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-X3xkmkfEnlwvmAvT .node .label{text-align:center;}#mermaid-svg-X3xkmkfEnlwvmAvT .node.clickable{cursor:pointer;}#mermaid-svg-X3xkmkfEnlwvmAvT .arrowheadPath{fill:#333333;}#mermaid-svg-X3xkmkfEnlwvmAvT .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-X3xkmkfEnlwvmAvT .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-X3xkmkfEnlwvmAvT .edgeLabel{background-color:#e8e8e8;text-align:center;}#mermaid-svg-X3xkmkfEnlwvmAvT .edgeLabel rect{opacity:0.5;background-color:#e8e8e8;fill:#e8e8e8;}#mermaid-svg-X3xkmkfEnlwvmAvT .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-X3xkmkfEnlwvmAvT .cluster text{fill:#333;}#mermaid-svg-X3xkmkfEnlwvmAvT .cluster span{color:#333;}#mermaid-svg-X3xkmkfEnlwvmAvT div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#mermaid-svg-X3xkmkfEnlwvmAvT :root{–mermaid-font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;} <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

SQL Server\u5185\u5b58 <\/p>\n

\u7f13\u51b2\u6c60 <\/p>\n

\u8ba1\u5212\u7f13\u5b58 <\/p>\n

\u9501\u5185\u5b58 <\/p>\n

\u5176\u4ed6\u5185\u5b58 <\/p>\n

\u6570\u636e\u9875\u7f13\u5b58 <\/p>\n

\u7d22\u5f15\u9875\u7f13\u5b58 <\/p>\n

\u7f13\u5b58\u547d\u4e2d\u7387 <\/p>\n

\u5b58\u50a8\u8fc7\u7a0b\u8ba1\u5212 <\/p>\n

\u5373\u5e2d\u67e5\u8be2\u8ba1\u5212 <\/p>\n

\u8ba1\u5212\u91cd\u7528\u7387 <\/p>\n

\u9501\u7ba1\u7406\u5668 <\/p>\n

\u6b7b\u9501\u76d1\u89c6\u5668 <\/p>\n

\u8fde\u63a5\u5185\u5b58 <\/p>\n

\u5de5\u4f5c\u7a7a\u95f4\u5185\u5b58 <\/p>\n

4.3.1 \u5185\u5b58\u538b\u529b\u76d1\u63a7\u811a\u672c<\/h5>\n

— \u5185\u5b58\u538b\u529b\u76d1\u63a7<\/span>
\nSELECT<\/span>
\n counter_name,<\/span>
\n cntr_value,<\/span>
\n CASE<\/span> counter_name
\n WHEN<\/span> 'Buffer cache hit ratio'<\/span> THEN<\/span>
\n CASE<\/span> WHEN<\/span> cntr_value <<\/span> 90<\/span> THEN<\/span> 'WARNING: Low buffer cache hit ratio'<\/span>
\n WHEN<\/span> cntr_value <<\/span> 95<\/span> THEN<\/span> 'CAUTION: Consider memory optimization'<\/span>
\n ELSE<\/span> 'OK'<\/span>
\n END<\/span>
\n WHEN<\/span> 'Page life expectancy'<\/span> THEN<\/span>
\n CASE<\/span> WHEN<\/span> cntr_value <<\/span> 300<\/span> THEN<\/span> 'CRITICAL: Very low page life expectancy'<\/span>
\n WHEN<\/span> cntr_value <<\/span> 600<\/span> THEN<\/span> 'WARNING: Low page life expectancy'<\/span>
\n ELSE<\/span> 'OK'<\/span>
\n END<\/span>
\n WHEN<\/span> 'Free Memory (KB)'<\/span> THEN<\/span>
\n CASE<\/span> WHEN<\/span> cntr_value <<\/span> 1048576<\/span> THEN<\/span> 'WARNING: Low free memory'<\/span>
\n ELSE<\/span> 'OK'<\/span>
\n END<\/span>
\n END<\/span> AS<\/span> status<\/span>
\nFROM<\/span> sys.<\/span>dm_os_performance_counters
\nWHERE<\/span> counter_name IN<\/span> (<\/span>
\n 'Buffer cache hit ratio'<\/span>,<\/span>
\n 'Page life expectancy'<\/span>,<\/span>
\n 'Free Memory (KB)'<\/span>,<\/span>
\n 'Total Server Memory (KB)'<\/span>,<\/span>
\n 'Target Server Memory (KB)'<\/span>
\n)<\/span>
\nAND<\/span> object_name LIKE<\/span> '%Memory Manager%'<\/span>
\n OR<\/span> object_name LIKE<\/span> '%Buffer Manager%'<\/span>;<\/span><\/p>\n

\n

5. \u5b9e\u65f6\u76d1\u6d4b\u5de5\u5177\u4e0e\u89e3\u51b3\u65b9\u6848<\/h3>\n

5.1 \u76d1\u63a7\u5de5\u5177\u751f\u6001\u5bf9\u6bd4<\/h4>\n\n\u5de5\u5177\u7c7b\u578b\u4ee3\u8868\u4ea7\u54c1\u4f18\u52bf\u9002\u7528\u573a\u666f<\/tr>\n\n\n\n\n\n
\u539f\u751f\u5de5\u5177<\/td>\nSSMS\u6d3b\u52a8\u76d1\u89c6\u5668<\/td>\n\u514d\u8d39\u3001\u96c6\u6210\u5ea6\u9ad8<\/td>\n\u5c0f\u89c4\u6a21\u73af\u5883<\/td>\n<\/tr>\n
\u7b2c\u4e09\u65b9\u5de5\u5177<\/td>\nSolarWinds DPA<\/td>\n\u529f\u80fd\u5168\u9762\u3001\u754c\u9762\u53cb\u597d<\/td>\n\u4f01\u4e1a\u7ea7\u73af\u5883<\/td>\n<\/tr>\n
\u5f00\u6e90\u65b9\u6848<\/td>\nGrafana + InfluxDB<\/td>\n\u81ea\u5b9a\u4e49\u6027\u5f3a\u3001\u6210\u672c\u4f4e<\/td>\n\u6280\u672f\u56e2\u961f\u5f3a<\/td>\n<\/tr>\n
\u4e91\u7aef\u76d1\u63a7<\/td>\nAzure Monitor<\/td>\n\u6258\u7ba1\u670d\u52a1\u3001\u81ea\u52a8\u5316<\/td>\n\u4e91\u73af\u5883<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

5.2 \u81ea\u5efa\u76d1\u63a7\u5e73\u53f0\u67b6\u6784<\/h4>\n

#mermaid-svg-JsaJ2qsqkBNYFKaG {font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;fill:#333;}#mermaid-svg-JsaJ2qsqkBNYFKaG .error-icon{fill:#552222;}#mermaid-svg-JsaJ2qsqkBNYFKaG .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-JsaJ2qsqkBNYFKaG .edge-thickness-normal{stroke-width:2px;}#mermaid-svg-JsaJ2qsqkBNYFKaG .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-JsaJ2qsqkBNYFKaG .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-JsaJ2qsqkBNYFKaG .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-JsaJ2qsqkBNYFKaG .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-JsaJ2qsqkBNYFKaG .marker{fill:#333333;stroke:#333333;}#mermaid-svg-JsaJ2qsqkBNYFKaG .marker.cross{stroke:#333333;}#mermaid-svg-JsaJ2qsqkBNYFKaG svg{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-JsaJ2qsqkBNYFKaG .label{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;color:#333;}#mermaid-svg-JsaJ2qsqkBNYFKaG .cluster-label text{fill:#333;}#mermaid-svg-JsaJ2qsqkBNYFKaG .cluster-label span{color:#333;}#mermaid-svg-JsaJ2qsqkBNYFKaG .label text,#mermaid-svg-JsaJ2qsqkBNYFKaG span{fill:#333;color:#333;}#mermaid-svg-JsaJ2qsqkBNYFKaG .node rect,#mermaid-svg-JsaJ2qsqkBNYFKaG .node circle,#mermaid-svg-JsaJ2qsqkBNYFKaG .node ellipse,#mermaid-svg-JsaJ2qsqkBNYFKaG .node polygon,#mermaid-svg-JsaJ2qsqkBNYFKaG .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-JsaJ2qsqkBNYFKaG .node .label{text-align:center;}#mermaid-svg-JsaJ2qsqkBNYFKaG .node.clickable{cursor:pointer;}#mermaid-svg-JsaJ2qsqkBNYFKaG .arrowheadPath{fill:#333333;}#mermaid-svg-JsaJ2qsqkBNYFKaG .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-JsaJ2qsqkBNYFKaG .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-JsaJ2qsqkBNYFKaG .edgeLabel{background-color:#e8e8e8;text-align:center;}#mermaid-svg-JsaJ2qsqkBNYFKaG .edgeLabel rect{opacity:0.5;background-color:#e8e8e8;fill:#e8e8e8;}#mermaid-svg-JsaJ2qsqkBNYFKaG .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-JsaJ2qsqkBNYFKaG .cluster text{fill:#333;}#mermaid-svg-JsaJ2qsqkBNYFKaG .cluster span{color:#333;}#mermaid-svg-JsaJ2qsqkBNYFKaG div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#mermaid-svg-JsaJ2qsqkBNYFKaG :root{–mermaid-font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;} <\/p>\n

\u5c55\u793a\u5c42 <\/p>\n

\u5206\u6790\u5904\u7406 <\/p>\n

\u6570\u636e\u5b58\u50a8 <\/p>\n

\u6d88\u606f\u961f\u5217 <\/p>\n

\u6570\u636e\u6536\u96c6\u5c42 <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

Grafana\u4eea\u8868\u677f <\/p>\n

Web\u7ba1\u7406\u754c\u9762 <\/p>\n

\u79fb\u52a8\u7aefAPP <\/p>\n

\u544a\u8b66\u901a\u77e5 <\/p>\n

\u5b9e\u65f6\u6d41\u5904\u7406 <\/p>\n

\u5f02\u5e38\u68c0\u6d4b\u7b97\u6cd5 <\/p>\n

\u544a\u8b66\u89c4\u5219\u5f15\u64ce <\/p>\n

InfluxDB\u65f6\u5e8f\u6570\u636e\u5e93 <\/p>\n

Elasticsearch\u65e5\u5fd7\u5b58\u50a8 <\/p>\n

SQL Server\u5143\u6570\u636e <\/p>\n

Redis\u961f\u5217 <\/p>\n

RabbitMQ <\/p>\n

PowerShell\u6536\u96c6\u5668 <\/p>\n

T-SQL\u76d1\u63a7\u811a\u672c <\/p>\n

\u6027\u80fd\u8ba1\u6570\u5668\u91c7\u96c6 <\/p>\n

5.3 PowerShell\u81ea\u52a8\u5316\u76d1\u63a7\u811a\u672c<\/h4>\n

5.3.1 \u7cfb\u7edf\u6027\u80fd\u6570\u636e\u6536\u96c6<\/h5>\n

# SQL Server\u6027\u80fd\u6570\u636e\u6536\u96c6\u811a\u672c<\/span>
\nparam<\/span>(<\/span>
\n [string]<\/span>$ServerInstance<\/span> = "localhost"<\/span>,<\/span>
\n [string]<\/span>$Database<\/span> = "master"<\/span>,<\/span>
\n [string]<\/span>$OutputPath<\/span> = "C:\\\\MonitoringData"<\/span>
\n)<\/span><\/p>\n

# \u5bfc\u5165SQL Server\u6a21\u5757<\/span>
\nImport-Module<\/span> SqlServer –<\/span>ErrorAction SilentlyContinue<\/p>\n

# \u5b9a\u4e49\u76d1\u63a7\u67e5\u8be2<\/span>
\n$MonitoringQueries<\/span> = @{<\/span>
\n "WaitStats"<\/span> = @"
\n SELECT
\n wait_type,
\n waiting_tasks_count,
\n wait_time_ms,
\n max_wait_time_ms,
\n signal_wait_time_ms,
\n GETDATE() as collection_time
\n FROM sys.dm_os_wait_stats
\n WHERE wait_type NOT IN (
\n 'BROKER_EVENTHANDLER', 'BROKER_RECEIVE_WAITFOR',
\n 'BROKER_TASK_STOP', 'BROKER_TO_FLUSH',
\n 'BROKER_TRANSMITTER', 'CHECKPOINT_QUEUE',
\n 'CHKPT', 'CLR_AUTO_EVENT', 'CLR_MANUAL_EVENT'
\n )
\n"<\/span>@<\/p>\n

"CPUUsage"<\/span> = @"
\n SELECT
\n SQLProcessUtilization,
\n SystemIdle,
\n 100 – SystemIdle – SQLProcessUtilization as OtherProcessUtilization,
\n GETDATE() as collection_time
\n FROM (
\n SELECT record.value('(.\/Record\/@id)[1]', 'int') as record_id,
\n record.value('(.\/Record\/SchedulerMonitorEvent\/SystemHealth\/SystemIdle)[1]', 'int') as SystemIdle,
\n record.value('(.\/Record\/SchedulerMonitorEvent\/SystemHealth\/ProcessUtilization)[1]', 'int') as SQLProcessUtilization
\n FROM (
\n SELECT TOP 1 CONVERT(xml, record) AS record
\n FROM sys.dm_os_ring_buffers
\n WHERE ring_buffer_type = N'RING_BUFFER_SCHEDULER_MONITOR'
\n AND record LIKE '%<SystemHealth>%'
\n ORDER BY timestamp DESC
\n ) AS x
\n ) AS y
\n"<\/span>@<\/p>\n

"DatabaseSizes"<\/span> = @"
\n SELECT
\n DB_NAME(database_id) as DatabaseName,
\n type_desc as FileType,
\n name as FileName,
\n size * 8 \/ 1024 as SizeMB,
\n max_size * 8 \/ 1024 as MaxSizeMB,
\n growth as Growth,
\n is_percent_growth,
\n GETDATE() as collection_time
\n FROM sys.master_files
\n WHERE database_id > 4 — \u6392\u9664\u7cfb\u7edf\u6570\u636e\u5e93
\n"<\/span>@
\n}<\/span><\/p>\n

# \u6267\u884c\u67e5\u8be2\u5e76\u4fdd\u5b58\u7ed3\u679c<\/span>
\nforeach<\/span> (<\/span>$QueryName<\/span> in $MonitoringQueries<\/span>.<\/span>Keys)<\/span> {<\/span>
\n try<\/span> {<\/span>
\n $Results<\/span> = Invoke-Sqlcmd<\/span> –<\/span>ServerInstance $ServerInstance<\/span> –<\/span>Database $Database<\/span> –<\/span>Query $MonitoringQueries<\/span>[<\/span>$QueryName<\/span>]<\/span><\/p>\n

$OutputFile<\/span> = Join-Path<\/span> $OutputPath<\/span> "$QueryName_<\/span>$(<\/span>Get-Date<\/span> –<\/span>Format 'yyyyMMdd_HHmmss'<\/span>)<\/span><\/span>.json"<\/span>
\n $Results<\/span> |<\/span> ConvertTo-Json<\/span> |<\/span> Out-File<\/span> –<\/span>FilePath $OutputFile<\/span> –<\/span>Encoding UTF8<\/p>\n

Write-Host<\/span> "\u2713 $QueryName<\/span> data collected: $OutputFile<\/span>"<\/span> –<\/span>ForegroundColor Green
\n }<\/span>
\n catch<\/span> {<\/span>
\n Write-Error<\/span> "Failed to collect $QueryName<\/span> data: $(<\/span>$_<\/span>.<\/span>Exception.<\/span>Message)<\/span><\/span>"<\/span>
\n }<\/span>
\n}<\/span><\/p>\n

5.4 \u544a\u8b66\u914d\u7f6e\u4e0e\u7ba1\u7406<\/h4>\n

5.4.1 \u667a\u80fd\u544a\u8b66\u89c4\u5219<\/h5>\n

— \u521b\u5efa\u544a\u8b66\u914d\u7f6e\u8868<\/span>
\nCREATE<\/span> TABLE<\/span> MonitoringAlerts (<\/span>
\n AlertID int<\/span> IDENTITY<\/span>(<\/span>1<\/span>,<\/span>1<\/span>)<\/span> PRIMARY<\/span> KEY<\/span>,<\/span>
\n AlertName nvarchar(<\/span>100<\/span>)<\/span> NOT<\/span> NULL<\/span>,<\/span>
\n MetricName nvarchar(<\/span>50<\/span>)<\/span> NOT<\/span> NULL<\/span>,<\/span>
\n ThresholdType varchar<\/span>(<\/span>10<\/span>)<\/span> CHECK<\/span> (<\/span>ThresholdType IN<\/span> (<\/span>'>'<\/span>,<\/span> '<'<\/span>,<\/span> '='<\/span>,<\/span> '>='<\/span>,<\/span> '<='<\/span>)<\/span>)<\/span>,<\/span>
\n WarningThreshold decimal<\/span>(<\/span>18<\/span>,<\/span>2<\/span>)<\/span>,<\/span>
\n CriticalThreshold decimal<\/span>(<\/span>18<\/span>,<\/span>2<\/span>)<\/span>,<\/span>
\n IsEnabled bit<\/span> DEFAULT<\/span> 1<\/span>,<\/span>
\n NotificationMethod varchar<\/span>(<\/span>20<\/span>)<\/span> DEFAULT<\/span> 'Email'<\/span>,<\/span>
\n CreatedDate datetime2 DEFAULT<\/span> GETDATE(<\/span>)<\/span>
\n)<\/span>;<\/span><\/p>\n

— \u63d2\u5165\u9ed8\u8ba4\u544a\u8b66\u89c4\u5219<\/span>
\nINSERT<\/span> INTO<\/span> MonitoringAlerts (<\/span>AlertName,<\/span> MetricName,<\/span> ThresholdType,<\/span> WarningThreshold,<\/span> CriticalThreshold)<\/span>
\nVALUES<\/span>
\n (<\/span>'CPU\u4f7f\u7528\u7387\u8fc7\u9ad8'<\/span>,<\/span> 'CPUUtilization'<\/span>,<\/span> '>'<\/span>,<\/span> 70.0<\/span>,<\/span> 85.0<\/span>)<\/span>,<\/span>
\n (<\/span>'\u5185\u5b58\u4f7f\u7528\u7387\u8fc7\u9ad8'<\/span>,<\/span> 'MemoryUtilization'<\/span>,<\/span> '>'<\/span>,<\/span> 80.0<\/span>,<\/span> 90.0<\/span>)<\/span>,<\/span>
\n (<\/span>'\u78c1\u76d8\u7a7a\u95f4\u4e0d\u8db3'<\/span>,<\/span> 'DiskSpaceUsed'<\/span>,<\/span> '>'<\/span>,<\/span> 75.0<\/span>,<\/span> 90.0<\/span>)<\/span>,<\/span>
\n (<\/span>'\u963b\u585e\u4f1a\u8bdd\u8fc7\u591a'<\/span>,<\/span> 'BlockedProcessCount'<\/span>,<\/span> '>'<\/span>,<\/span> 5.0<\/span>,<\/span> 10.0<\/span>)<\/span>,<\/span>
\n (<\/span>'\u6b7b\u9501\u9891\u7387\u8fc7\u9ad8'<\/span>,<\/span> 'DeadlocksPerMinute'<\/span>,<\/span> '>'<\/span>,<\/span> 1.0<\/span>,<\/span> 3.0<\/span>)<\/span>,<\/span>
\n (<\/span>'\u7f13\u5b58\u547d\u4e2d\u7387\u8fc7\u4f4e'<\/span>,<\/span> 'BufferCacheHitRatio'<\/span>,<\/span> '<'<\/span>,<\/span> 95.0<\/span>,<\/span> 90.0<\/span>)<\/span>;<\/span><\/p>\n

\n

6. \u76d1\u63a7\u6700\u4f73\u5b9e\u8df5\u4e0e\u6848\u4f8b<\/h3>\n

6.1 \u76d1\u63a7\u7b56\u7565\u6700\u4f73\u5b9e\u8df5<\/h4>\n

6.1.1 \u5206\u5c42\u76d1\u63a7\u7b56\u7565<\/h5>\n

#mermaid-svg-UGdGiem90ygCCnn5 {font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;fill:#333;}#mermaid-svg-UGdGiem90ygCCnn5 .error-icon{fill:#552222;}#mermaid-svg-UGdGiem90ygCCnn5 .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-UGdGiem90ygCCnn5 .edge-thickness-normal{stroke-width:2px;}#mermaid-svg-UGdGiem90ygCCnn5 .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-UGdGiem90ygCCnn5 .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-UGdGiem90ygCCnn5 .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-UGdGiem90ygCCnn5 .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-UGdGiem90ygCCnn5 .marker{fill:#333333;stroke:#333333;}#mermaid-svg-UGdGiem90ygCCnn5 .marker.cross{stroke:#333333;}#mermaid-svg-UGdGiem90ygCCnn5 svg{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-UGdGiem90ygCCnn5 .label{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;color:#333;}#mermaid-svg-UGdGiem90ygCCnn5 .cluster-label text{fill:#333;}#mermaid-svg-UGdGiem90ygCCnn5 .cluster-label span{color:#333;}#mermaid-svg-UGdGiem90ygCCnn5 .label text,#mermaid-svg-UGdGiem90ygCCnn5 span{fill:#333;color:#333;}#mermaid-svg-UGdGiem90ygCCnn5 .node rect,#mermaid-svg-UGdGiem90ygCCnn5 .node circle,#mermaid-svg-UGdGiem90ygCCnn5 .node ellipse,#mermaid-svg-UGdGiem90ygCCnn5 .node polygon,#mermaid-svg-UGdGiem90ygCCnn5 .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-UGdGiem90ygCCnn5 .node .label{text-align:center;}#mermaid-svg-UGdGiem90ygCCnn5 .node.clickable{cursor:pointer;}#mermaid-svg-UGdGiem90ygCCnn5 .arrowheadPath{fill:#333333;}#mermaid-svg-UGdGiem90ygCCnn5 .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-UGdGiem90ygCCnn5 .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-UGdGiem90ygCCnn5 .edgeLabel{background-color:#e8e8e8;text-align:center;}#mermaid-svg-UGdGiem90ygCCnn5 .edgeLabel rect{opacity:0.5;background-color:#e8e8e8;fill:#e8e8e8;}#mermaid-svg-UGdGiem90ygCCnn5 .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-UGdGiem90ygCCnn5 .cluster text{fill:#333;}#mermaid-svg-UGdGiem90ygCCnn5 .cluster span{color:#333;}#mermaid-svg-UGdGiem90ygCCnn5 div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#mermaid-svg-UGdGiem90ygCCnn5 :root{–mermaid-font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;} <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

<\/span> <\/p>\n

\u5206\u5c42\u76d1\u63a7\u7b56\u7565 <\/p>\n

\u57fa\u7840\u8bbe\u65bd\u5c42 <\/p>\n

\u6570\u636e\u5e93\u5b9e\u4f8b\u5c42 <\/p>\n

\u5e94\u7528\u5c42 <\/p>\n

\u4e1a\u52a1\u5c42 <\/p>\n

\u670d\u52a1\u5668\u786c\u4ef6\u76d1\u63a7 <\/p>\n

\u64cd\u4f5c\u7cfb\u7edf\u76d1\u63a7 <\/p>\n

\u7f51\u7edc\u76d1\u63a7 <\/p>\n

SQL Server\u670d\u52a1 <\/p>\n

\u6570\u636e\u5e93\u6027\u80fd <\/p>\n

\u5b58\u50a8\u76d1\u63a7 <\/p>\n

\u5e94\u7528\u8fde\u63a5\u6c60 <\/p>\n

\u67e5\u8be2\u6267\u884c <\/p>\n

\u4e8b\u52a1\u5904\u7406 <\/p>\n

\u5173\u952e\u4e1a\u52a1\u6307\u6807 <\/p>\n

\u7528\u6237\u4f53\u9a8c <\/p>\n

SLA\u5408\u89c4\u6027 <\/p>\n

6.1.2 \u76d1\u63a7\u6570\u636e\u751f\u547d\u5468\u671f\u7ba1\u7406<\/h5>\n

— \u76d1\u63a7\u6570\u636e\u4fdd\u7559\u7b56\u7565<\/span>
\nCREATE<\/span> PROCEDURE<\/span> sp_CleanupMonitoringData
\nAS<\/span>
\nBEGIN<\/span>
\n DECLARE<\/span> @RetentionDays<\/span> int<\/span> =<\/span> 90<\/span>;<\/span>
\n DECLARE<\/span> @CutoffDate<\/span> datetime<\/span> =<\/span> DATEADD(<\/span>day<\/span>,<\/span> –<\/span>@RetentionDays<\/span>,<\/span> GETDATE(<\/span>)<\/span>)<\/span>;<\/span><\/p>\n

— \u6e05\u7406\u5386\u53f2\u6027\u80fd\u6570\u636e<\/span>
\n DELETE<\/span> FROM<\/span> PerformanceMetrics
\n WHERE<\/span> CollectionTime <<\/span> @CutoffDate<\/span>;<\/span><\/p>\n

— \u6e05\u7406\u5386\u53f2\u544a\u8b66\u6570\u636e<\/span>
\n DELETE<\/span> FROM<\/span> AlertHistory
\n WHERE<\/span> AlertTime <<\/span> DATEADD(<\/span>day<\/span>,<\/span> –<\/span>365<\/span>,<\/span> GETDATE(<\/span>)<\/span>)<\/span>;<\/span> — \u544a\u8b66\u4fdd\u75591\u5e74<\/span><\/p>\n

— \u6e05\u7406\u67e5\u8be2\u5b58\u50a8\u5386\u53f2\u6570\u636e<\/span>
\n EXEC<\/span> sp_query_store_flush_db;<\/span><\/p>\n

— \u538b\u7f29\u6e05\u7406\u540e\u7684\u8868<\/span>
\n ALTER<\/span> INDEX<\/span> ALL<\/span> ON<\/span> PerformanceMetrics REORGANIZE;<\/span>
\n ALTER<\/span> INDEX<\/span> ALL<\/span> ON<\/span> AlertHistory REORGANIZE;<\/span><\/p>\n

PRINT<\/span> '\u76d1\u63a7\u6570\u636e\u6e05\u7406\u5b8c\u6210，\u6e05\u7406\u65e5\u671f\u65e9\u4e8e: '<\/span> +<\/span> CONVERT<\/span>(<\/span>varchar<\/span>,<\/span> @CutoffDate<\/span>)<\/span>;<\/span>
\nEND<\/span>;<\/span><\/p>\n

6.2 \u5b9e\u9645\u6848\u4f8b\u5206\u6790<\/h4>\n

6.2.1 \u6848\u4f8b\u4e00：\u7535\u5546\u5e73\u53f0\u9ad8\u5e76\u53d1\u76d1\u63a7<\/h5>\n

\u4e1a\u52a1\u573a\u666f： \u67d0\u7535\u5546\u5e73\u53f0\u65e5\u8ba2\u5355\u91cf100\u4e07+，\u6570\u636e\u5e93\u627f\u8f7d\u9ad8\u5e76\u53d1\u8bfb\u5199\u538b\u529b<\/p>\n

\u76d1\u63a7\u91cd\u70b9：<\/p>\n

    \n
  • \u8fde\u63a5\u6c60\u76d1\u63a7：\u9632\u6b62\u8fde\u63a5\u6cc4\u9732<\/li>\n
  • \u9501\u7b49\u5f85\u76d1\u63a7：\u907f\u514d\u6b7b\u9501\u5f71\u54cd\u7528\u6237\u4f53\u9a8c<\/li>\n
  • \u67e5\u8be2\u6027\u80fd\u76d1\u63a7：\u53ca\u65f6\u53d1\u73b0\u6162\u67e5\u8be2<\/li>\n<\/ul>\n

    \u89e3\u51b3\u65b9\u6848：<\/p>\n

    — \u9ad8\u5e76\u53d1\u573a\u666f\u8fde\u63a5\u76d1\u63a7<\/span>
    \nCREATE<\/span> VIEW<\/span> v_ConnectionMonitoring AS<\/span>
    \nSELECT<\/span>
    \n s.<\/span>session_id,<\/span>
    \n s.<\/span>login_name,<\/span>
    \n s.<\/span>host_name,<\/span>
    \n s.<\/span>program_name,<\/span>
    \n s.<\/span>status<\/span>,<\/span>
    \n s.<\/span>last_request_start_time,<\/span>
    \n s.<\/span>last_request_end_time,<\/span>
    \n DATEDIFF(<\/span>second<\/span>,<\/span> s.<\/span>last_request_end_time,<\/span> GETDATE(<\/span>)<\/span>)<\/span> as<\/span> idle_time_seconds,<\/span>
    \n r.<\/span>command,<\/span>
    \n r.<\/span>wait_type,<\/span>
    \n r.<\/span>wait_time,<\/span>
    \n st.<\/span>text<\/span> as<\/span> current_sql
    \nFROM<\/span> sys.<\/span>dm_exec_sessions s
    \nLEFT<\/span> JOIN<\/span> sys.<\/span>dm_exec_requests r ON<\/span> s.<\/span>session_id =<\/span> r.<\/span>session_id
    \nOUTER<\/span> APPLY<\/span> sys.<\/span>dm_exec_sql_text(<\/span>r.<\/span>sql_handle)<\/span> st
    \nWHERE<\/span> s.<\/span>is_user_process =<\/span> 1<\/span>;<\/span><\/p>\n

    — \u76d1\u63a7\u957f\u65f6\u95f4\u7a7a\u95f2\u8fde\u63a5<\/span>
    \nSELECT<\/span> COUNT<\/span>(<\/span>*<\/span>)<\/span> as<\/span> long_idle_connections
    \nFROM<\/span> v_ConnectionMonitoring
    \nWHERE<\/span> idle_time_seconds ><\/span> 1800<\/span> — 30\u5206\u949f\u7a7a\u95f2<\/span>
    \n AND<\/span> status<\/span> =<\/span> 'sleeping'<\/span>;<\/span><\/p>\n

    6.2.2 \u6848\u4f8b\u4e8c：\u91d1\u878d\u7cfb\u7edf24×7\u76d1\u63a7<\/h5>\n

    \u4e1a\u52a1\u573a\u666f： \u94f6\u884c\u6838\u5fc3\u4ea4\u6613\u7cfb\u7edf，\u8981\u6c4299.99%\u53ef\u7528\u6027<\/p>\n

    \u76d1\u63a7\u7b56\u7565：<\/p>\n

    #mermaid-svg-X4VWh63pAaVnIWNw {font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;fill:#333;}#mermaid-svg-X4VWh63pAaVnIWNw .error-icon{fill:#552222;}#mermaid-svg-X4VWh63pAaVnIWNw .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-X4VWh63pAaVnIWNw .edge-thickness-normal{stroke-width:2px;}#mermaid-svg-X4VWh63pAaVnIWNw .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-X4VWh63pAaVnIWNw .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-X4VWh63pAaVnIWNw .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-X4VWh63pAaVnIWNw .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-X4VWh63pAaVnIWNw .marker{fill:#333333;stroke:#333333;}#mermaid-svg-X4VWh63pAaVnIWNw .marker.cross{stroke:#333333;}#mermaid-svg-X4VWh63pAaVnIWNw svg{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-X4VWh63pAaVnIWNw .label{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;color:#333;}#mermaid-svg-X4VWh63pAaVnIWNw .cluster-label text{fill:#333;}#mermaid-svg-X4VWh63pAaVnIWNw .cluster-label span{color:#333;}#mermaid-svg-X4VWh63pAaVnIWNw .label text,#mermaid-svg-X4VWh63pAaVnIWNw span{fill:#333;color:#333;}#mermaid-svg-X4VWh63pAaVnIWNw .node rect,#mermaid-svg-X4VWh63pAaVnIWNw .node circle,#mermaid-svg-X4VWh63pAaVnIWNw .node ellipse,#mermaid-svg-X4VWh63pAaVnIWNw .node polygon,#mermaid-svg-X4VWh63pAaVnIWNw .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-X4VWh63pAaVnIWNw .node .label{text-align:center;}#mermaid-svg-X4VWh63pAaVnIWNw .node.clickable{cursor:pointer;}#mermaid-svg-X4VWh63pAaVnIWNw .arrowheadPath{fill:#333333;}#mermaid-svg-X4VWh63pAaVnIWNw .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-X4VWh63pAaVnIWNw .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-X4VWh63pAaVnIWNw .edgeLabel{background-color:#e8e8e8;text-align:center;}#mermaid-svg-X4VWh63pAaVnIWNw .edgeLabel rect{opacity:0.5;background-color:#e8e8e8;fill:#e8e8e8;}#mermaid-svg-X4VWh63pAaVnIWNw .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-X4VWh63pAaVnIWNw .cluster text{fill:#333;}#mermaid-svg-X4VWh63pAaVnIWNw .cluster span{color:#333;}#mermaid-svg-X4VWh63pAaVnIWNw div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#mermaid-svg-X4VWh63pAaVnIWNw :root{–mermaid-font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;} <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    \u91d1\u878d\u7cfb\u7edf\u76d1\u63a7 <\/p>\n

    \u5b9e\u65f6\u4ea4\u6613\u76d1\u63a7 <\/p>\n

    \u6570\u636e\u4e00\u81f4\u6027\u76d1\u63a7 <\/p>\n

    \u5b89\u5168\u5ba1\u8ba1\u76d1\u63a7 <\/p>\n

    \u707e\u5907\u5207\u6362\u76d1\u63a7 <\/p>\n

    TPS\u76d1\u63a7 <\/p>\n

    \u54cd\u5e94\u65f6\u95f4 <\/p>\n

    \u9519\u8bef\u7387 <\/p>\n

    \u8d26\u52a1\u5e73\u8861 <\/p>\n

    \u6570\u636e\u5b8c\u6574\u6027 <\/p>\n

    \u540c\u6b65\u72b6\u6001 <\/p>\n

    \u767b\u5f55\u5f02\u5e38 <\/p>\n

    \u6743\u9650\u53d8\u66f4 <\/p>\n

    \u654f\u611f\u64cd\u4f5c <\/p>\n

    \u4e3b\u5907\u540c\u6b65 <\/p>\n

    \u5207\u6362\u5c31\u7eea <\/p>\n

    \u6570\u636e\u4e00\u81f4 <\/p>\n

    \u5173\u952e\u76d1\u63a7\u811a\u672c：<\/p>\n

    — \u4ea4\u6613\u7cfb\u7edf\u5173\u952e\u6307\u6807\u76d1\u63a7<\/span>
    \nCREATE<\/span> PROCEDURE<\/span> sp_MonitorCriticalMetrics
    \nAS<\/span>
    \nBEGIN<\/span>
    \n — 1. \u5b9e\u65f6TPS\u76d1\u63a7<\/span>
    \n SELECT<\/span>
    \n 'TPS'<\/span> as<\/span> MetricName,<\/span>
    \n COUNT<\/span>(<\/span>*<\/span>)<\/span> \/<\/span> 60.0<\/span> as<\/span> CurrentValue,<\/span>
    \n CASE<\/span> WHEN<\/span> COUNT<\/span>(<\/span>*<\/span>)<\/span> \/<\/span> 60.0<\/span> <<\/span> 100<\/span> THEN<\/span> 'WARNING'<\/span>
    \n WHEN<\/span> COUNT<\/span>(<\/span>*<\/span>)<\/span> \/<\/span> 60.0<\/span> <<\/span> 50<\/span> THEN<\/span> 'CRITICAL'<\/span>
    \n ELSE<\/span> 'OK'<\/span>
    \n END<\/span> as<\/span> Status<\/span>
    \n FROM<\/span> TransactionLog
    \n WHERE<\/span> LogTime >=<\/span> DATEADD(<\/span>minute<\/span>,<\/span> –<\/span>1<\/span>,<\/span> GETDATE(<\/span>)<\/span>)<\/span>;<\/span><\/p>\n

    — 2. \u8d26\u52a1\u5e73\u8861\u68c0\u67e5<\/span>
    \n DECLARE<\/span> @BalanceCheck<\/span> decimal<\/span>(<\/span>18<\/span>,<\/span>2<\/span>)<\/span>;<\/span>
    \n SELECT<\/span> @BalanceCheck<\/span> =<\/span> SUM<\/span>(<\/span>Amount)<\/span>
    \n FROM<\/span> DailyBalance
    \n WHERE<\/span> BalanceDate =<\/span> CAST(<\/span>GETDATE(<\/span>)<\/span> as<\/span> date<\/span>)<\/span>;<\/span><\/p>\n

    SELECT<\/span>
    \n 'AccountBalance'<\/span> as<\/span> MetricName,<\/span>
    \n @BalanceCheck<\/span> as<\/span> CurrentValue,<\/span>
    \n CASE<\/span> WHEN<\/span> ABS(<\/span>@BalanceCheck<\/span>)<\/span> ><\/span> 0.01<\/span> THEN<\/span> 'CRITICAL'<\/span>
    \n ELSE<\/span> 'OK'<\/span>
    \n END<\/span> as<\/span> Status<\/span>;<\/span><\/p>\n

    — 3. \u6570\u636e\u5e93\u8fde\u63a5\u5065\u5eb7\u68c0\u67e5<\/span>
    \n SELECT<\/span>
    \n 'DatabaseConnections'<\/span> as<\/span> MetricName,<\/span>
    \n COUNT<\/span>(<\/span>*<\/span>)<\/span> as<\/span> CurrentValue,<\/span>
    \n CASE<\/span> WHEN<\/span> COUNT<\/span>(<\/span>*<\/span>)<\/span> ><\/span> 500<\/span> THEN<\/span> 'WARNING'<\/span>
    \n WHEN<\/span> COUNT<\/span>(<\/span>*<\/span>)<\/span> ><\/span> 800<\/span> THEN<\/span> 'CRITICAL'<\/span>
    \n ELSE<\/span> 'OK'<\/span>
    \n END<\/span> as<\/span> Status<\/span>
    \n FROM<\/span> sys.<\/span>dm_exec_sessions
    \n WHERE<\/span> is_user_process =<\/span> 1<\/span>;<\/span>
    \nEND<\/span>;<\/span><\/p>\n

    6.3 \u544a\u8b66\u964d\u566a\u4e0e\u667a\u80fd\u5316<\/h4>\n

    6.3.1 \u544a\u8b66\u805a\u5408\u7b56\u7565<\/h5>\n

    — \u667a\u80fd\u544a\u8b66\u805a\u5408\u5b58\u50a8\u8fc7\u7a0b<\/span>
    \nCREATE<\/span> PROCEDURE<\/span> sp_ProcessAlerts
    \nAS<\/span>
    \nBEGIN<\/span>
    \n — \u76f8\u540c\u7c7b\u578b\u544a\u8b665\u5206\u949f\u5185\u805a\u5408<\/span>
    \n WITH<\/span> AlertAggregation AS<\/span> (<\/span>
    \n SELECT<\/span>
    \n AlertType,<\/span>
    \n COUNT<\/span>(<\/span>*<\/span>)<\/span> as<\/span> AlertCount,<\/span>
    \n MIN<\/span>(<\/span>AlertTime)<\/span> as<\/span> FirstAlertTime,<\/span>
    \n MAX<\/span>(<\/span>AlertTime)<\/span> as<\/span> LastAlertTime,<\/span>
    \n DATEADD(<\/span>minute<\/span>,<\/span> DATEDIFF(<\/span>minute<\/span>,<\/span> 0<\/span>,<\/span> AlertTime)<\/span> \/<\/span> 5<\/span> *<\/span> 5<\/span>,<\/span> 0<\/span>)<\/span> as<\/span> TimeWindow
    \n FROM<\/span> RawAlerts
    \n WHERE<\/span> AlertTime >=<\/span> DATEADD(<\/span>minute<\/span>,<\/span> –<\/span>5<\/span>,<\/span> GETDATE(<\/span>)<\/span>)<\/span>
    \n AND<\/span> IsProcessed =<\/span> 0<\/span>
    \n GROUP<\/span> BY<\/span> AlertType,<\/span> DATEADD(<\/span>minute<\/span>,<\/span> DATEDIFF(<\/span>minute<\/span>,<\/span> 0<\/span>,<\/span> AlertTime)<\/span> \/<\/span> 5<\/span> *<\/span> 5<\/span>,<\/span> 0<\/span>)<\/span>
    \n )<\/span>
    \n INSERT<\/span> INTO<\/span> ProcessedAlerts (<\/span>AlertType,<\/span> AlertCount,<\/span> TimeWindow,<\/span> Severity)<\/span>
    \n SELECT<\/span>
    \n AlertType,<\/span>
    \n AlertCount,<\/span>
    \n TimeWindow,<\/span>
    \n CASE<\/span>
    \n WHEN<\/span> AlertCount >=<\/span> 10<\/span> THEN<\/span> 'CRITICAL'<\/span>
    \n WHEN<\/span> AlertCount >=<\/span> 5<\/span> THEN<\/span> 'WARNING'<\/span>
    \n ELSE<\/span> 'INFO'<\/span>
    \n END<\/span> as<\/span> Severity
    \n FROM<\/span> AlertAggregation;<\/span><\/p>\n

    — \u6807\u8bb0\u539f\u59cb\u544a\u8b66\u4e3a\u5df2\u5904\u7406<\/span>
    \n UPDATE<\/span> RawAlerts
    \n SET<\/span> IsProcessed =<\/span> 1<\/span>
    \n WHERE<\/span> AlertTime >=<\/span> DATEADD(<\/span>minute<\/span>,<\/span> –<\/span>5<\/span>,<\/span> GETDATE(<\/span>)<\/span>)<\/span>;<\/span>
    \nEND<\/span>;<\/span><\/p>\n

    \n

    7. \u603b\u7ed3\u4e0e\u5c55\u671b<\/h3>\n

    7.1 \u76d1\u63a7\u6280\u672f\u53d1\u5c55\u8d8b\u52bf<\/h4>\n

    #mermaid-svg-iqLEYkvYe1AAR0r8 {font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;fill:#333;}#mermaid-svg-iqLEYkvYe1AAR0r8 .error-icon{fill:#552222;}#mermaid-svg-iqLEYkvYe1AAR0r8 .error-text{fill:#552222;stroke:#552222;}#mermaid-svg-iqLEYkvYe1AAR0r8 .edge-thickness-normal{stroke-width:2px;}#mermaid-svg-iqLEYkvYe1AAR0r8 .edge-thickness-thick{stroke-width:3.5px;}#mermaid-svg-iqLEYkvYe1AAR0r8 .edge-pattern-solid{stroke-dasharray:0;}#mermaid-svg-iqLEYkvYe1AAR0r8 .edge-pattern-dashed{stroke-dasharray:3;}#mermaid-svg-iqLEYkvYe1AAR0r8 .edge-pattern-dotted{stroke-dasharray:2;}#mermaid-svg-iqLEYkvYe1AAR0r8 .marker{fill:#333333;stroke:#333333;}#mermaid-svg-iqLEYkvYe1AAR0r8 .marker.cross{stroke:#333333;}#mermaid-svg-iqLEYkvYe1AAR0r8 svg{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:16px;}#mermaid-svg-iqLEYkvYe1AAR0r8 .label{font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;color:#333;}#mermaid-svg-iqLEYkvYe1AAR0r8 .cluster-label text{fill:#333;}#mermaid-svg-iqLEYkvYe1AAR0r8 .cluster-label span{color:#333;}#mermaid-svg-iqLEYkvYe1AAR0r8 .label text,#mermaid-svg-iqLEYkvYe1AAR0r8 span{fill:#333;color:#333;}#mermaid-svg-iqLEYkvYe1AAR0r8 .node rect,#mermaid-svg-iqLEYkvYe1AAR0r8 .node circle,#mermaid-svg-iqLEYkvYe1AAR0r8 .node ellipse,#mermaid-svg-iqLEYkvYe1AAR0r8 .node polygon,#mermaid-svg-iqLEYkvYe1AAR0r8 .node path{fill:#ECECFF;stroke:#9370DB;stroke-width:1px;}#mermaid-svg-iqLEYkvYe1AAR0r8 .node .label{text-align:center;}#mermaid-svg-iqLEYkvYe1AAR0r8 .node.clickable{cursor:pointer;}#mermaid-svg-iqLEYkvYe1AAR0r8 .arrowheadPath{fill:#333333;}#mermaid-svg-iqLEYkvYe1AAR0r8 .edgePath .path{stroke:#333333;stroke-width:2.0px;}#mermaid-svg-iqLEYkvYe1AAR0r8 .flowchart-link{stroke:#333333;fill:none;}#mermaid-svg-iqLEYkvYe1AAR0r8 .edgeLabel{background-color:#e8e8e8;text-align:center;}#mermaid-svg-iqLEYkvYe1AAR0r8 .edgeLabel rect{opacity:0.5;background-color:#e8e8e8;fill:#e8e8e8;}#mermaid-svg-iqLEYkvYe1AAR0r8 .cluster rect{fill:#ffffde;stroke:#aaaa33;stroke-width:1px;}#mermaid-svg-iqLEYkvYe1AAR0r8 .cluster text{fill:#333;}#mermaid-svg-iqLEYkvYe1AAR0r8 .cluster span{color:#333;}#mermaid-svg-iqLEYkvYe1AAR0r8 div.mermaidTooltip{position:absolute;text-align:center;max-width:200px;padding:2px;font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;font-size:12px;background:hsl(80, 100%, 96.2745098039%);border:1px solid #aaaa33;border-radius:2px;pointer-events:none;z-index:100;}#mermaid-svg-iqLEYkvYe1AAR0r8 :root{–mermaid-font-family:\\”trebuchet ms\\”,verdana,arial,sans-serif;} <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    <\/span> <\/p>\n

    \u76d1\u63a7\u6280\u672f\u8d8b\u52bf <\/p>\n

    AI\/ML\u96c6\u6210 <\/p>\n

    \u4e91\u539f\u751f\u76d1\u63a7 <\/p>\n

    \u81ea\u52a8\u5316\u8fd0\u7ef4 <\/p>\n

    \u53ef\u89c2\u6d4b\u6027 <\/p>\n

    \u5f02\u5e38\u68c0\u6d4b\u7b97\u6cd5 <\/p>\n

    \u9884\u6d4b\u6027\u7ef4\u62a4 <\/p>\n

    \u667a\u80fd\u544a\u8b66 <\/p>\n

    \u5bb9\u5668\u5316\u76d1\u63a7 <\/p>\n

    \u5fae\u670d\u52a1\u76d1\u63a7 <\/p>\n

    \u591a\u4e91\u7ba1\u7406 <\/p>\n

    \u81ea\u6108\u7cfb\u7edf <\/p>\n

    \u81ea\u52a8\u6269\u7f29\u5bb9 <\/p>\n

    \u6545\u969c\u81ea\u52a8\u5207\u6362 <\/p>\n

    \u5206\u5e03\u5f0f\u8ffd\u8e2a <\/p>\n

    \u7edf\u4e00\u53ef\u89c2\u6d4b\u5e73\u53f0 <\/p>\n

    \u4e1a\u52a1\u76d1\u63a7\u6574\u5408 <\/p>\n

    7.2 \u6838\u5fc3\u8981\u70b9\u603b\u7ed3<\/h4>\n

    \u6280\u672f\u8981\u70b9：<\/p>\n

  • \u5206\u5c42\u76d1\u63a7\u67b6\u6784 – \u4ece\u57fa\u7840\u8bbe\u65bd\u5230\u4e1a\u52a1\u5c42\u9762\u7684\u5168\u65b9\u4f4d\u8986\u76d6<\/li>\n
  • \u5b9e\u65f6\u6027\u5e73\u8861 – \u5728\u76d1\u63a7\u7cbe\u5ea6\u548c\u7cfb\u7edf\u6027\u80fd\u4e4b\u95f4\u627e\u5230\u6700\u4f73\u5e73\u8861\u70b9<\/li>\n
  • \u667a\u80fd\u544a\u8b66 – \u901a\u8fc7\u7b97\u6cd5\u51cf\u5c11\u8bef\u62a5，\u63d0\u9ad8\u544a\u8b66\u7cbe\u51c6\u5ea6<\/li>\n
  • \u81ea\u52a8\u5316\u54cd\u5e94 – \u6784\u5efa\u81ea\u52a8\u5316\u8fd0\u7ef4\u80fd\u529b，\u51cf\u5c11\u4eba\u5de5\u5e72\u9884<\/li>\n

    \u5b9e\u65bd\u5efa\u8bae：<\/p>\n

  • \u6e10\u8fdb\u5f0f\u5b9e\u65bd – \u4ece\u6838\u5fc3\u6307\u6807\u5f00\u59cb，\u9010\u6b65\u5b8c\u5584\u76d1\u63a7\u4f53\u7cfb<\/li>\n
  • \u56e2\u961f\u57f9\u8bad – \u786e\u4fdd\u8fd0\u7ef4\u56e2\u961f\u5177\u5907\u5fc5\u8981\u7684\u6280\u672f\u80fd\u529b<\/li>\n
  • \u6587\u6863\u89c4\u8303 – \u5efa\u7acb\u5b8c\u5584\u7684\u76d1\u63a7\u6d41\u7a0b\u548c\u5e94\u6025\u54cd\u5e94\u6587\u6863<\/li>\n
  • \u6301\u7eed\u4f18\u5316 – \u57fa\u4e8e\u76d1\u63a7\u6570\u636e\u6301\u7eed\u6539\u8fdb\u7cfb\u7edf\u67b6\u6784\u548c\u914d\u7f6e<\/li>\n

    7.3 \u5c55\u671b\u672a\u6765<\/h4>\n

    \u968f\u7740\u4e91\u8ba1\u7b97\u3001\u5927\u6570\u636e\u548c\u4eba\u5de5\u667a\u80fd\u6280\u672f\u7684\u53d1\u5c55，SQL Server\u76d1\u63a7\u5c06\u5411\u66f4\u52a0\u667a\u80fd\u5316\u3001\u81ea\u52a8\u5316\u7684\u65b9\u5411\u53d1\u5c55\u3002\u672a\u6765\u7684\u76d1\u63a7\u7cfb\u7edf\u5c06\u5177\u5907：<\/p>\n

      \n
    • \u9884\u6d4b\u6027\u5206\u6790\u80fd\u529b – \u57fa\u4e8e\u5386\u53f2\u6570\u636e\u9884\u6d4b\u6f5c\u5728\u95ee\u9898<\/li>\n
    • \u81ea\u9002\u5e94\u9608\u503c – \u52a8\u6001\u8c03\u6574\u544a\u8b66\u9608\u503c\u9002\u5e94\u4e1a\u52a1\u53d8\u5316<\/li>\n
    • \u8de8\u5e73\u53f0\u7edf\u4e00\u76d1\u63a7 – \u652f\u6301\u6df7\u5408\u4e91\u548c\u591a\u6570\u636e\u5e93\u5e73\u53f0<\/li>\n
    • \u4e1a\u52a1\u611f\u77e5\u76d1\u63a7 – \u5c06\u6280\u672f\u6307\u6807\u4e0e\u4e1a\u52a1\u4ef7\u503c\u76f4\u63a5\u5173\u8054<\/li>\n<\/ul>\n

      \u5efa\u8bae\u4f01\u4e1a\u5728\u6784\u5efaSQL Server\u76d1\u63a7\u4f53\u7cfb\u65f6，\u4e0d\u4ec5\u8981\u5173\u6ce8\u5f53\u524d\u9700\u6c42，\u66f4\u8981\u8003\u8651\u672a\u6765\u7684\u6269\u5c55\u6027\u548c\u6f14\u8fdb\u80fd\u529b，\u4e3a\u6570\u5b57\u5316\u8f6c\u578b\u5960\u5b9a\u575a\u5b9e\u7684\u6570\u636e\u57fa\u7840\u8bbe\u65bd\u76d1\u63a7\u57fa\u7840\u3002<\/p>\n

      \n

      \u53c2\u8003\u8d44\u6e90：<\/p>\n

        \n
      • Microsoft SQL Server\u5b98\u65b9\u6587\u6863<\/li>\n
      • SQL Server\u6027\u80fd\u8c03\u4f18\u6700\u4f73\u5b9e\u8df5<\/li>\n
      • \u4f01\u4e1a\u7ea7\u6570\u636e\u5e93\u76d1\u63a7\u89e3\u51b3\u65b9\u6848\u6848\u4f8b<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

        \u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb692\u6b21\uff0c\u70b9\u8d5e17\u6b21\uff0c\u6536\u85cf17\u6b21\u3002\u5728\u5f53\u4eca\u6570\u636e\u9a71\u52a8\u7684\u5546\u4e1a\u73af\u5883\u4e2d\uff0cSQL Server\u6570\u636e\u5e93\u4f5c\u4e3a\u4f01\u4e1a\u6838\u5fc3\u6570\u636e\u5b58\u50a8\u548c\u5904\u7406\u5e73\u53f0\uff0c\u5176\u7a33\u5b9a\u6027\u548c\u6027\u80fd\u76f4\u63a5\u5f71\u54cd\u4e1a\u52a1\u8fde\u7eed\u6027\u3002\u636e\u7edf\u8ba1\uff0c\u6570\u636e\u5e93\u6545\u969c\u9020\u6210\u7684\u4e1a\u52a1\u635f\u5931\u6bcf\u5c0f\u65f6\u53ef\u8fbe\u6570\u4e07\u81f3\u6570\u767e\u4e07\u5143\uff0c\u56e0\u6b64\u5efa\u7acb\u9ad8\u6548\u7684\u5b9e\u65f6\u76d1\u6d4b\u4f53\u7cfb\u81f3\u5173\u91cd\u8981\u3002<\/p>\n","protected":false},"author":2,"featured_media":44390,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[4146,4148,100,4147,78],"topic":[],"class_list":["post-44391","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-sql-server-","tag-4148","tag-100","tag-4147","tag-78"],"yoast_head":"\nSQL Server \u6570\u636e\u5e93\u6545\u969c\u4e0e\u6027\u80fd\u9ad8\u6548\u5b9e\u65f6\u76d1\u6d4b\u6280\u672f\u6df1\u5ea6\u89e3\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.wsisp.com\/helps\/44391.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server \u6570\u636e\u5e93\u6545\u969c\u4e0e\u6027\u80fd\u9ad8\u6548\u5b9e\u65f6\u76d1\u6d4b\u6280\u672f\u6df1\u5ea6\u89e3\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb692\u6b21\uff0c\u70b9\u8d5e17\u6b21\uff0c\u6536\u85cf17\u6b21\u3002\u5728\u5f53\u4eca\u6570\u636e\u9a71\u52a8\u7684\u5546\u4e1a\u73af\u5883\u4e2d\uff0cSQL Server\u6570\u636e\u5e93\u4f5c\u4e3a\u4f01\u4e1a\u6838\u5fc3\u6570\u636e\u5b58\u50a8\u548c\u5904\u7406\u5e73\u53f0\uff0c\u5176\u7a33\u5b9a\u6027\u548c\u6027\u80fd\u76f4\u63a5\u5f71\u54cd\u4e1a\u52a1\u8fde\u7eed\u6027\u3002\u636e\u7edf\u8ba1\uff0c\u6570\u636e\u5e93\u6545\u969c\u9020\u6210\u7684\u4e1a\u52a1\u635f\u5931\u6bcf\u5c0f\u65f6\u53ef\u8fbe\u6570\u4e07\u81f3\u6570\u767e\u4e07\u5143\uff0c\u56e0\u6b64\u5efa\u7acb\u9ad8\u6548\u7684\u5b9e\u65f6\u76d1\u6d4b\u4f53\u7cfb\u81f3\u5173\u91cd\u8981\u3002\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/44391.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2025-06-18T09:18:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250618091754-6852844229ba7.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"22 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/44391.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/44391.html\",\"name\":\"SQL Server \u6570\u636e\u5e93\u6545\u969c\u4e0e\u6027\u80fd\u9ad8\u6548\u5b9e\u65f6\u76d1\u6d4b\u6280\u672f\u6df1\u5ea6\u89e3\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2025-06-18T09:18:01+00:00\",\"dateModified\":\"2025-06-18T09:18:01+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/44391.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/44391.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/44391.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server \u6570\u636e\u5e93\u6545\u969c\u4e0e\u6027\u80fd\u9ad8\u6548\u5b9e\u65f6\u76d1\u6d4b\u6280\u672f\u6df1\u5ea6\u89e3\u6790\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\",\"url\":\"https:\/\/www.wsisp.com\/helps\/\",\"name\":\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"description\":\"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"contentUrl\":\"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery\",\"caption\":\"admin\"},\"sameAs\":[\"http:\/\/wp.wsisp.com\"],\"url\":\"https:\/\/www.wsisp.com\/helps\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server \u6570\u636e\u5e93\u6545\u969c\u4e0e\u6027\u80fd\u9ad8\u6548\u5b9e\u65f6\u76d1\u6d4b\u6280\u672f\u6df1\u5ea6\u89e3\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.wsisp.com\/helps\/44391.html","og_locale":"zh_CN","og_type":"article","og_title":"SQL Server \u6570\u636e\u5e93\u6545\u969c\u4e0e\u6027\u80fd\u9ad8\u6548\u5b9e\u65f6\u76d1\u6d4b\u6280\u672f\u6df1\u5ea6\u89e3\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb692\u6b21\uff0c\u70b9\u8d5e17\u6b21\uff0c\u6536\u85cf17\u6b21\u3002\u5728\u5f53\u4eca\u6570\u636e\u9a71\u52a8\u7684\u5546\u4e1a\u73af\u5883\u4e2d\uff0cSQL Server\u6570\u636e\u5e93\u4f5c\u4e3a\u4f01\u4e1a\u6838\u5fc3\u6570\u636e\u5b58\u50a8\u548c\u5904\u7406\u5e73\u53f0\uff0c\u5176\u7a33\u5b9a\u6027\u548c\u6027\u80fd\u76f4\u63a5\u5f71\u54cd\u4e1a\u52a1\u8fde\u7eed\u6027\u3002\u636e\u7edf\u8ba1\uff0c\u6570\u636e\u5e93\u6545\u969c\u9020\u6210\u7684\u4e1a\u52a1\u635f\u5931\u6bcf\u5c0f\u65f6\u53ef\u8fbe\u6570\u4e07\u81f3\u6570\u767e\u4e07\u5143\uff0c\u56e0\u6b64\u5efa\u7acb\u9ad8\u6548\u7684\u5b9e\u65f6\u76d1\u6d4b\u4f53\u7cfb\u81f3\u5173\u91cd\u8981\u3002","og_url":"https:\/\/www.wsisp.com\/helps\/44391.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2025-06-18T09:18:01+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/06\/20250618091754-6852844229ba7.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"22 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/44391.html","url":"https:\/\/www.wsisp.com\/helps\/44391.html","name":"SQL Server \u6570\u636e\u5e93\u6545\u969c\u4e0e\u6027\u80fd\u9ad8\u6548\u5b9e\u65f6\u76d1\u6d4b\u6280\u672f\u6df1\u5ea6\u89e3\u6790 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2025-06-18T09:18:01+00:00","dateModified":"2025-06-18T09:18:01+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/44391.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/44391.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/44391.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"SQL Server \u6570\u636e\u5e93\u6545\u969c\u4e0e\u6027\u80fd\u9ad8\u6548\u5b9e\u65f6\u76d1\u6d4b\u6280\u672f\u6df1\u5ea6\u89e3\u6790"}]},{"@type":"WebSite","@id":"https:\/\/www.wsisp.com\/helps\/#website","url":"https:\/\/www.wsisp.com\/helps\/","name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","description":"\u9999\u6e2f\u670d\u52a1\u5668_\u9999\u6e2f\u4e91\u670d\u52a1\u5668\u8d44\u8baf_\u670d\u52a1\u5668\u5e2e\u52a9\u6587\u6863_\u670d\u52a1\u5668\u6559\u7a0b","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.wsisp.com\/helps\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41","name":"admin","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/image\/","url":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","contentUrl":"https:\/\/gravatar.wp-china-yes.net\/avatar\/?s=96&d=mystery","caption":"admin"},"sameAs":["http:\/\/wp.wsisp.com"],"url":"https:\/\/www.wsisp.com\/helps\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/44391","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/comments?post=44391"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/44391\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/44390"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=44391"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=44391"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=44391"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=44391"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}