{"id":48142,"date":"2025-07-30T10:53:40","date_gmt":"2025-07-30T02:53:40","guid":{"rendered":"https:\/\/www.wsisp.com\/helps\/48142.html"},"modified":"2025-07-30T10:53:40","modified_gmt":"2025-07-30T02:53:40","slug":"windows-server%e6%9c%8d%e5%8a%a1%e5%99%a8%ef%bc%88sqlserver%e6%9c%8d%e5%8a%a1%ef%bc%89-c%e7%9b%98%e6%bb%a1%e4%ba%86%e7%9a%84%e4%b8%80%e6%ac%a1%e6%8e%92%e6%9f%a5%e5%8f%8a%e5%a4%84%e7%90%86","status":"publish","type":"post","link":"https:\/\/www.wsisp.com\/helps\/48142.html","title":{"rendered":"windows server\u670d\u52a1\u5668\uff08sqlserver\u670d\u52a1\uff09 C\u76d8\u6ee1\u4e86\u7684\u4e00\u6b21\u6392\u67e5\u53ca\u5904\u7406"},"content":{"rendered":"

windows server\u670d\u52a1\u5668（sqlserver\u670d\u52a1） C\u76d8\u6ee1\u4e86\u7684\u4e00\u6b21\u6392\u67e5\u53ca\u5904\u7406<\/p>\n

\u670d\u52a1\u5668\u7684C\u76d8\u7206\u7ea2，\u7531\u4e8e\u7ed9C\u76d8\u6269\u5bb9\u592a\u9ebb\u70e6，\u5f00\u59cb\u6392\u67e5<\/h2>\n

\u5ffd\u7136\u53d1\u73b0\u670d\u52a1\u5668\u7684C\u76d8\u7206\u7ea2，\u7531\u4e8e\u7ed9C\u76d8\u6269\u5bb9\u592a\u9ebb\u70e6，\u5f00\u59cb\u6392\u67e5\u600e\u4e48\u4f1a\u6ee1\u4e86，\u660e\u660e\u4e4b\u524d\u8fd8\u597d\u3002\u4ece\u4ee5\u4e0b\u5f00\u59cb\u6392\u67e5<\/p>\n

1. \u4ece\u670d\u52a1\u5668\u7684\u65e5\u5fd7\u65b9\u9762\u5f00\u59cb\u6392\u67e5，\u5220\u9664\u4e86\u4e00\u4e9b\u65e5\u5fd7（\u76f4\u63a5\u5220\u9664\u5931\u8d25\u4e86，\u4f7f\u7528\u4e8b\u4ef6\u67e5\u770b\u5668\u5220\u9664\u65e5\u5fd7）<\/h3>\n

\u641c\u5230\u8bf4\u7cfb\u7edf\u7684\u65e5\u5fd7，C:\\\\Windows\\\\System32\\\\winevt\\\\Logs\u4e0b\u7684\u53ef\u4ee5\u5220\u9664，\u4f46\u662f\u5220\u9664\u63d0\u793a\u8bf4\u5df2\u7ecf\u5728winevt\u6253\u5f00\u4e86，\u65e0\u6cd5\u5220\u9664，\u540e\u641c\u4e86，\u53d1\u73b0\u9700\u8981\u5728\u4e8b\u4ef6\u67e5\u770b\u5668\u4e2d\u5220\u9664，\u4e8e\u662f\u5f00\u59cb\u6162\u6162\u5220\u9664\u3002\u5220\u9664\u5b8c，\u53d1\u73b0\u6548\u679c\u4e0d\u660e\u663e，C\u76d8\u8fd8\u662f\u7ea2\u7684\u3002<\/p>\n

  • \u4e8b\u4ef6\u67e5\u770b\u5668\u5220\u9664\u65f6，\u7cfb\u7edf\u8fd8\u5361\u6b7b\u4e86\u3002\u3002\u3002 ，\u4f7f\u7528\u4e86\u4efb\u52a1\u7ba1\u7406\u5668\u6740\u6389\u4e86\u4efb\u52a1，\u4f46\u662f\u628awindows\u7684\u754c\u9762\u4e5f\u6740\u6389\u4e86，\u754c\u9762\u5168\u9ed1\u4e86，\u771f\u7684\u5f88\u614c\u4e86\u3002（\u7b2c\u4e00\u6b21\u9047\u5230），\u6765\u56de\u91cd\u65b0\u8fde\u63a5\u670d\u52a1\u5668\u597d\u51e0\u6b21，\u90fd\u662f\u9ed1\u7684\u3002\u540e\u9762\u641c\u4e86，\u53d1\u73b0\u53ef\u4ee5\u4f7f\u7528esc+shift+ctrl\u53ef\u4ee5\u8c03\u51fa\u4efb\u52a1\u7ba1\u7406\u5668，\u7136\u540e\u65b0\u589e\u4efb\u52a1，\u8f93\u5165explorer，\u7ec8\u4e8e\u770b\u5230\u684c\u9762\u4e86，~~~<\/li>\n

    2. \u5220\u9664\u65e5\u5fd7\u65e0\u6cd5\u89e3\u51b3，\u60f3\u5230\u4e86sqlserver\u662f\u4e0d\u662f\u7d22\u5f15\u788e\u7247\u592a\u591a\u5bfc\u81f4\u7684，\u5f00\u59cb\u5904\u7406\u7d22\u5f15\u788e\u7247\u3002<\/h3>\n

    \u67e5\u8be2\u7d22\u5f15\u788e\u7247<\/p>\n

    SELECT<\/span> i.<\/span>name AS<\/span> indexname,<\/span> o.<\/span>name AS<\/span> tablename,<\/span> s.<\/span>name AS<\/span> schemaname,<\/span> f.<\/span>index_type_desc AS<\/span> indextype,<\/span>
    \nf.<\/span>avg_page_space_used_in_percent AS<\/span> indexdensity,<\/span> f.<\/span>avg_fragmentation_in_percent AS<\/span> indexfragmentation,<\/span>
    \nf.<\/span>page_count AS<\/span> pages FROM<\/span> sys.<\/span>dm_db_index_physical_stats(<\/span>DB_ID(<\/span>)<\/span>,<\/span> NULL<\/span>,<\/span> NULL<\/span>,<\/span> NULL<\/span>,<\/span> 'SAMPLED'<\/span>)<\/span> f
    \nINNER<\/span> JOIN<\/span> sys.<\/span>objects o ON<\/span> o.<\/span>object_id =<\/span> f.<\/span>object_id
    \nINNER<\/span> JOIN<\/span> sys.<\/span>schemas s ON<\/span> o.<\/span>schema_id =<\/span> s.<\/span>schema_id
    \nINNER<\/span> JOIN<\/span> sys.<\/span>indexes i ON<\/span> f.<\/span>object_id =<\/span> i.<\/span>object_id AND<\/span> f.<\/span>index_id =<\/span> i.<\/span>index_id
    \nWHERE<\/span> page_count ><\/span> 50<\/span> AND<\/span> f.<\/span>index_id ><\/span> 0<\/span>
    \nORDER<\/span> BY<\/span> f.<\/span>avg_fragmentation_in_percent desc<\/span><\/p>\n

    \u53d1\u73b0\u788e\u7247\u7387\u5f88\u9ad8，\u7136\u540e，\u51c6\u5907\u505c\u670d\u52a1，\u5904\u7406\u788e\u7247\u3002<\/p>\n

    — Ensure a USE <databasename> statement has been executed first.<\/span>
    \nSET<\/span> NOCOUNT ON<\/span>;<\/span>
    \nDECLARE<\/span> @objectid<\/span> int<\/span>;<\/span>
    \nDECLARE<\/span> @indexid<\/span> int<\/span>;<\/span>
    \nDECLARE<\/span> @partitioncount<\/span> bigint<\/span>;<\/span>
    \nDECLARE<\/span> @schemaname<\/span> nvarchar(<\/span>130<\/span>)<\/span>;<\/span>
    \nDECLARE<\/span> @objectname<\/span> nvarchar(<\/span>130<\/span>)<\/span>;<\/span>
    \nDECLARE<\/span> @indexname<\/span> nvarchar(<\/span>130<\/span>)<\/span>;<\/span>
    \nDECLARE<\/span> @partitionnum<\/span> bigint<\/span>;<\/span>
    \nDECLARE<\/span> @partitions<\/span> bigint<\/span>;<\/span>
    \nDECLARE<\/span> @frag<\/span> float<\/span>;<\/span>
    \nDECLARE<\/span> @command<\/span> nvarchar(<\/span>4000<\/span>)<\/span>;<\/span>
    \nDECLARE<\/span> @sql<\/span> nvarchar(<\/span>4000<\/span>)<\/span>;<\/span>
    \nDECLARE<\/span> @dbid<\/span> INT<\/span>
    \nSET<\/span> @dbid<\/span>=<\/span>DB_ID(<\/span>)<\/span><\/p>\n

    — Conditionally select tables and indexes from the sys.dm_db_index_physical_stats function <\/span>
    \n— and convert object and index IDs to names.<\/span>
    \nSELECT<\/span>
    \n object_id AS<\/span> objectid,<\/span>
    \n index_id AS<\/span> indexid,<\/span>
    \n partition_number AS<\/span> partitionnum,<\/span>
    \n avg_fragmentation_in_percent AS<\/span> frag
    \nINTO<\/span> #work_to_do<\/span>
    \nFROM<\/span> sys.<\/span>dm_db_index_physical_stats (<\/span>@dbid<\/span>,<\/span> NULL<\/span>,<\/span> NULL<\/span> ,<\/span> NULL<\/span>,<\/span> 'LIMITED'<\/span>)<\/span>
    \nWHERE<\/span> avg_fragmentation_in_percent ><\/span> 10.0<\/span> AND<\/span> index_id ><\/span> 0<\/span>;<\/span><\/p>\n

    — Declare the cursor for the list of partitions to be processed.<\/span>
    \nDECLARE<\/span> partitions CURSOR<\/span> FOR<\/span> SELECT<\/span> *<\/span> FROM<\/span> #work_to_do;<\/span><\/p>\n

    — Open the cursor.<\/span>
    \nOPEN<\/span> partitions;<\/span><\/p>\n

    — Loop through the partitions.<\/span>
    \nWHILE<\/span> (<\/span>1<\/span>=<\/span>1<\/span>)<\/span>
    \n BEGIN<\/span>;<\/span>
    \n FETCH<\/span> NEXT<\/span>
    \n FROM<\/span> partitions
    \n INTO<\/span> @objectid<\/span>,<\/span> @indexid<\/span>,<\/span> @partitionnum<\/span>,<\/span> @frag<\/span>;<\/span>
    \n IF<\/span> @@FETCH_STATUS<\/span> <<\/span> 0<\/span> BREAK<\/span>;<\/span>
    \n SELECT<\/span> @objectname<\/span> =<\/span> QUOTENAME(<\/span>o.<\/span>name)<\/span>,<\/span> @schemaname<\/span> =<\/span> QUOTENAME(<\/span>s.<\/span>name)<\/span>
    \n FROM<\/span> sys.<\/span>objects AS<\/span> o
    \n JOIN<\/span> sys.<\/span>schemas as<\/span> s ON<\/span> s.<\/span>schema_id =<\/span> o.<\/span>schema_id
    \n WHERE<\/span> o.<\/span>object_id =<\/span> @objectid<\/span>;<\/span>
    \n SELECT<\/span> @indexname<\/span> =<\/span> QUOTENAME(<\/span>name)<\/span>
    \n FROM<\/span> sys.<\/span>indexes
    \n WHERE<\/span> object_id =<\/span> @objectid<\/span> AND<\/span> index_id =<\/span> @indexid<\/span>;<\/span>
    \n SELECT<\/span> @partitioncount<\/span> =<\/span> count<\/span> (<\/span>*<\/span>)<\/span>
    \n FROM<\/span> sys.<\/span>partitions
    \n WHERE<\/span> object_id =<\/span> @objectid<\/span> AND<\/span> index_id =<\/span> @indexid<\/span>;<\/span><\/p>\n

    SET<\/span> @sql<\/span> =<\/span> 'ALTER INDEX '<\/span> +<\/span> @indexname<\/span> +<\/span> N' ON '<\/span> +<\/span> @schemaname<\/span> +<\/span> N'.'<\/span> +<\/span> @objectname<\/span> +<\/span> N' SET ( ALLOW_PAGE_LOCKS = ON );'<\/span>
    \n — 30 is an arbitrary decision point at which to switch between reorganizing and rebuilding.<\/span>
    \n IF<\/span> @frag<\/span> <<\/span> 30.0<\/span>
    \n SET<\/span> @command<\/span> =<\/span> N'ALTER INDEX '<\/span> +<\/span> @indexname<\/span> +<\/span> N' ON '<\/span> +<\/span> @schemaname<\/span> +<\/span> N'.'<\/span> +<\/span> @objectname<\/span> +<\/span> N' REORGANIZE'<\/span>;<\/span>
    \n IF<\/span> @frag<\/span> >=<\/span> 30.0<\/span>
    \n SET<\/span> @command<\/span> =<\/span> N'ALTER INDEX '<\/span> +<\/span> @indexname<\/span> +<\/span> N' ON '<\/span> +<\/span> @schemaname<\/span> +<\/span> N'.'<\/span> +<\/span> @objectname<\/span> +<\/span> N' REBUILD'<\/span>;<\/span>
    \n IF<\/span> @partitioncount<\/span> ><\/span> 1<\/span>
    \n SET<\/span> @command<\/span> =<\/span> @command<\/span> +<\/span> N' PARTITION='<\/span> +<\/span> CAST(<\/span>@partitionnum<\/span> AS<\/span> nvarchar(<\/span>10<\/span>)<\/span>)<\/span>;<\/span><\/p>\n

    PRINT<\/span> @objectname<\/span> +<\/span> @indexname<\/span> +<\/span> '\u788e\u7247'<\/span> +<\/span> CAST(<\/span>@frag<\/span> AS<\/span> varchar<\/span>(<\/span>20<\/span>)<\/span>)<\/span>
    \n PRINT<\/span> @command<\/span> +<\/span> '——————–start'<\/span>
    \n EXEC<\/span> (<\/span>@sql<\/span>)<\/span> –\u6267\u884c ALLOW_PAGE_LOCKS<\/span>
    \n EXEC<\/span> (<\/span>@command<\/span>)<\/span> –\u6267\u884c<\/span>
    \n PRINT<\/span> @command<\/span> +<\/span> '——————–END'<\/span>
    \n END<\/span>;<\/span><\/p>\n

    — Close and deallocate the cursor.<\/span>
    \nCLOSE<\/span> partitions;<\/span>
    \nDEALLOCATE<\/span> partitions;<\/span><\/p>\n

    — Drop the temporary table.<\/span>
    \nDROP<\/span> TABLE<\/span> #work_to_do;<\/span><\/p>\n

    \u8fd0\u884c\u4ee5\u4e0a，\u53d1\u73b0\u62a5\u9519\u8bf4\u8868\u4e0d\u5b58\u5728，\u5148\u4e0d\u6267\u884c\u6700\u540e\u4e00\u53e5\u5220\u9664\u8fd9\u4e2a\u4e34\u65f6\u8868，\u6267\u884c\u524d\u9762\u7684\u7d22\u5f15\u91cd\u6784sql，\u4e00\u6bb5\u65f6\u95f4\u540e\u6210\u529f，\u5220\u9664\u4e34\u65f6\u8868\u3002\u518d\u8fd0\u884c\u67e5\u8be2\u788e\u7247\u7387\u7684sql，\u53ef\u4ee5\u770b\u5230\u788e\u7247\u7387\u4e0b\u964d\u4e86\u3002
    \n\u6b64\u65f6，\u518d\u770bC\u76d8，\u53d1\u73b0C\u76d8\u7a7a\u95f4\u53d8\u5316\u4e0d\u660e\u663e\u3002
    \n\u7ee7\u7eed\u6392\u67e5\u3002\u3002\u3002<\/p>\n

    3. \u67e5\u770bsqlserver\u7684data\u76ee\u5f55，\u53d1\u73b0\u5c45\u7136\u670950\u591a\u4e2aG，\u7136\u540e\u67e5\u770b\u53d1\u73b0\u6709\u4e2a\u5927\u6587\u4ef6tempdb.mdf，\u5c45\u7136\u670912G<\/h3>\n

    \u641c\u7d22\u4e86\u4e00\u4e0b，\u53d1\u73b0 tempdb.mdf\u662f\u4e34\u65f6\u5e93，\u4e8e\u662f\u8003\u8651\u80fd\u4e0d\u80fd\u79fb\u52a8\u4e34\u65f6\u5e93\u5462，\u641c\u7d22\u540e\u53d1\u73b0\u53ef\u4ee5，\u4e8e\u662f \u8fc1\u79fbtempdb\u6570\u636e\u6587\u4ef6
    \n（1）\u67e5\u770b\u5f53\u524d\u6570\u636e\u6587\u4ef6\u903b\u8f91\u540d\u79f0\u4e0e\u6570\u636e\u6587\u4ef6\u4f4d\u7f6e：<\/p>\n

    SELECT<\/span> name,<\/span> physical_name
    \nFROM<\/span> sys.<\/span>master_files
    \nWHERE<\/span> database_id =<\/span> DB_ID(<\/span>'tempdb'<\/span>)<\/span>;<\/span><\/p>\n

    \u679c\u7136\u770b\u5230\u663e\u793a\u6587\u4ef6\u662f\u5728C\u76d8\u7684SQL Server\u7684data\u76ee\u5f55\u4e0b\u7684\u3002
    \n（2）\u8fd0\u884csql \u66f4\u6539\u6587\u4ef6\u4f4d\u7f6e：
    \n\u5207\u6362\u5230master\u5e93<\/p>\n

    USE<\/span> master;<\/span><\/p>\n

    \u7136\u540e\u4fee\u6539\u6587\u4ef6\u4f4d\u7f6e：<\/p>\n

    ALTER<\/span> DATABASE<\/span> tempdb
    \nMODIFY<\/span> FILE<\/span> (<\/span>NAME =<\/span> tempdev,<\/span> FILENAME =<\/span> 'E:\\\\DATA\\\\tempdb.mdf'<\/span>)<\/span>;<\/span><\/p>\n

    ALTER<\/span> DATABASE<\/span> tempdb
    \nMODIFY<\/span> FILE<\/span> (<\/span>NAME =<\/span> templog,<\/span> FILENAME =<\/span> 'E:\\\\DATA\\\\templog.ldf'<\/span>)<\/span>;<\/span><\/p>\n

    \u4e4b\u540e\u518d\u67e5\u770b\u6587\u4ef6\u4f4d\u7f6e，\u53d1\u73b0\u5df2\u7ecf\u6539\u53d8\u4e86\u3002
    \n（3）\u91cd\u542fsqlserver\"\u91cd\u542fsqlserver\"<\/p>\n

    (4)\u53ef\u4ee5\u770b\u5230\u65b0\u8def\u5f84\u4e0b\u6709
    \ntempdb.mdf\u548ctemplog.ldf\u6587\u4ef6\u751f\u6210\u4e86\u3002
    \n\u6570\u636e\u5e93\u7684\u72b6\u6001\u4e5f\u6b63\u5e38，\u542f\u52a8\u81ea\u5df1\u7684\u670d\u52a1，\u6ca1\u53d1\u73b0\u95ee\u9898\u3002
    \n（5）（\u5148\u5907\u4efdtempdb.mdf\u548ctemplog.ldf\u5230\u5176\u4ed6\u76d8，\u3010\u4e5f\u53ef\u4ee5\u4e0d\u5907\u4efd，\u4fdd\u9669\u8d77\u89c1\u5148\u5907\u4efd\u4e86\u3011），\u7136\u540e\u5220\u9664C\u76d8\u7684sql server\u7684data\u76ee\u5f55\u4e0b\u7684\u8fd92\u4e2a\u6587\u4ef6\u3002\u7cfb\u7edf\u548c\u6570\u636e\u5e93\u8fd0\u884c\u4e00\u5207\u6b63\u5e38，\u53ef\u4ee5\u5220\u9664\u5907\u4efd\u6587\u4ef6\u4e86\u3002
    \n\u6b64\u65f6，C\u76d8\u7ec8\u4e8e\u8fd8\u526912G\u4e86，\u4e0d\u518d\u7206\u7ea2\u4e86！！！<\/p>\n

    \u6b64\u6b21\u5904\u7406\u544a\u4e00\u6bb5\u843d，\u4e0b\u6b21\u518d\u51fa\u73b0，\u518d\u6839\u636e\u60c5\u51b5\u89e3\u51b3\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

    \u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb933\u6b21\uff0c\u70b9\u8d5e12\u6b21\uff0c\u6536\u85cf9\u6b21\u3002sql server\u4e34\u65f6\u5e93\u8f6c\u79fb\u5b58\u653e\u8def\u5f84_\u4e0b\u8f7dsql server2022\u540ec\u76d8\u8d8a\u6765\u8d8a\u6ee1<\/p>\n","protected":false},"author":2,"featured_media":48141,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[538,149,43],"topic":[],"class_list":["post-48142","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-server","tag-sqlserver","tag-windows","tag-43"],"yoast_head":"\nwindows server\u670d\u52a1\u5668\uff08sqlserver\u670d\u52a1\uff09 C\u76d8\u6ee1\u4e86\u7684\u4e00\u6b21\u6392\u67e5\u53ca\u5904\u7406 - \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\/48142.html\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"windows server\u670d\u52a1\u5668\uff08sqlserver\u670d\u52a1\uff09 C\u76d8\u6ee1\u4e86\u7684\u4e00\u6b21\u6392\u67e5\u53ca\u5904\u7406 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"og:description\" content=\"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb933\u6b21\uff0c\u70b9\u8d5e12\u6b21\uff0c\u6536\u85cf9\u6b21\u3002sql server\u4e34\u65f6\u5e93\u8f6c\u79fb\u5b58\u653e\u8def\u5f84_\u4e0b\u8f7dsql server2022\u540ec\u76d8\u8d8a\u6765\u8d8a\u6ee1\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.wsisp.com\/helps\/48142.html\" \/>\n<meta property=\"og:site_name\" content=\"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-30T02:53:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/07\/20250730025339-6889893362987.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=\"3 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/48142.html\",\"url\":\"https:\/\/www.wsisp.com\/helps\/48142.html\",\"name\":\"windows server\u670d\u52a1\u5668\uff08sqlserver\u670d\u52a1\uff09 C\u76d8\u6ee1\u4e86\u7684\u4e00\u6b21\u6392\u67e5\u53ca\u5904\u7406 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3\",\"isPartOf\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#website\"},\"datePublished\":\"2025-07-30T02:53:40+00:00\",\"dateModified\":\"2025-07-30T02:53:40+00:00\",\"author\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.wsisp.com\/helps\/48142.html#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.wsisp.com\/helps\/48142.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.wsisp.com\/helps\/48142.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.wsisp.com\/helps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"windows server\u670d\u52a1\u5668\uff08sqlserver\u670d\u52a1\uff09 C\u76d8\u6ee1\u4e86\u7684\u4e00\u6b21\u6392\u67e5\u53ca\u5904\u7406\"}]},{\"@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":"windows server\u670d\u52a1\u5668\uff08sqlserver\u670d\u52a1\uff09 C\u76d8\u6ee1\u4e86\u7684\u4e00\u6b21\u6392\u67e5\u53ca\u5904\u7406 - \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\/48142.html","og_locale":"zh_CN","og_type":"article","og_title":"windows server\u670d\u52a1\u5668\uff08sqlserver\u670d\u52a1\uff09 C\u76d8\u6ee1\u4e86\u7684\u4e00\u6b21\u6392\u67e5\u53ca\u5904\u7406 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","og_description":"\u6587\u7ae0\u6d4f\u89c8\u9605\u8bfb933\u6b21\uff0c\u70b9\u8d5e12\u6b21\uff0c\u6536\u85cf9\u6b21\u3002sql server\u4e34\u65f6\u5e93\u8f6c\u79fb\u5b58\u653e\u8def\u5f84_\u4e0b\u8f7dsql server2022\u540ec\u76d8\u8d8a\u6765\u8d8a\u6ee1","og_url":"https:\/\/www.wsisp.com\/helps\/48142.html","og_site_name":"\u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","article_published_time":"2025-07-30T02:53:40+00:00","og_image":[{"url":"https:\/\/www.wsisp.com\/helps\/wp-content\/uploads\/2025\/07\/20250730025339-6889893362987.png"}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"admin","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"3 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.wsisp.com\/helps\/48142.html","url":"https:\/\/www.wsisp.com\/helps\/48142.html","name":"windows server\u670d\u52a1\u5668\uff08sqlserver\u670d\u52a1\uff09 C\u76d8\u6ee1\u4e86\u7684\u4e00\u6b21\u6392\u67e5\u53ca\u5904\u7406 - \u7f51\u7855\u4e92\u8054\u5e2e\u52a9\u4e2d\u5fc3","isPartOf":{"@id":"https:\/\/www.wsisp.com\/helps\/#website"},"datePublished":"2025-07-30T02:53:40+00:00","dateModified":"2025-07-30T02:53:40+00:00","author":{"@id":"https:\/\/www.wsisp.com\/helps\/#\/schema\/person\/358e386c577a3ab51c4493330a20ad41"},"breadcrumb":{"@id":"https:\/\/www.wsisp.com\/helps\/48142.html#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.wsisp.com\/helps\/48142.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.wsisp.com\/helps\/48142.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.wsisp.com\/helps"},{"@type":"ListItem","position":2,"name":"windows server\u670d\u52a1\u5668\uff08sqlserver\u670d\u52a1\uff09 C\u76d8\u6ee1\u4e86\u7684\u4e00\u6b21\u6392\u67e5\u53ca\u5904\u7406"}]},{"@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\/48142","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=48142"}],"version-history":[{"count":0,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/posts\/48142\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media\/48141"}],"wp:attachment":[{"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/media?parent=48142"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/categories?post=48142"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/tags?post=48142"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.wsisp.com\/helps\/wp-json\/wp\/v2\/topic?post=48142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}