{"id":2798,"date":"2013-08-16T09:55:11","date_gmt":"2013-08-16T09:55:11","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2798"},"modified":"2013-08-16T09:55:11","modified_gmt":"2013-08-16T09:55:11","slug":"%e5%a4%8d%e5%88%b6%e5%88%86%e5%8f%91%e5%8f%82%e6%95%b0%e9%85%8d%e7%bd%ae","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2013\/08\/16\/%e5%a4%8d%e5%88%b6%e5%88%86%e5%8f%91%e5%8f%82%e6%95%b0%e9%85%8d%e7%bd%ae\/","title":{"rendered":"\u590d\u5236\u5206\u53d1\u53c2\u6570\u914d\u7f6e"},"content":{"rendered":"

\n\t\u901a\u8fc7sp_help_agent_profile<\/font>\u67e5\u770b\u4ee3\u7406\u7c7b\u578b\u6240\u5bf9\u5e94\u7684<\/font>profile_id,<\/font>\u4e0b\u9762\u662f\u6b64\u8fc7\u7a0b\u7684\u8fd4\u56de\u7ed3\u679c<\/font><\/span> <\/span>profile_id    profile_name    agent_type    type    description    def_profile<\/span>
\n\t1    \u9ed8\u8ba4\u4ee3\u7406\u914d\u7f6e\u6587\u4ef6<\/font>    1    0    NULL    1<\/font><\/span>
\n\t2    \u9ed8\u8ba4\u4ee3\u7406\u914d\u7f6e\u6587\u4ef6<\/font>    2    0    NULL    1<\/font><\/span>
\n\t3    \u8be6\u7ec6\u5386\u53f2\u8bb0\u5f55\u4ee3\u7406\u914d\u7f6e\u6587\u4ef6<\/font>    2    0    <\/font>\u7528\u4e8e\u8be6\u7ec6\u5386\u53f2\u8bb0\u5f55\u65e5\u5fd7\u7684\u4ee3\u7406\u914d\u7f6e\u6587\u4ef6\u3002<\/font>    0<\/font><\/span>
\n\t4    \u9ed8\u8ba4\u4ee3\u7406\u914d\u7f6e\u6587\u4ef6<\/font>    3    0    NULL    1<\/font><\/span>
\n\t5    \u8be6\u7ec6\u5386\u53f2\u8bb0\u5f55\u4ee3\u7406\u914d\u7f6e\u6587\u4ef6<\/font>    3    0    <\/font>\u7528\u4e8e\u8be6\u7ec6\u5386\u53f2\u8bb0\u5f55\u65e5\u5fd7\u7684\u4ee3\u7406\u914d\u7f6e\u6587\u4ef6\u3002<\/font>    0<\/font><\/span>
\n\t6    \u9ed8\u8ba4\u4ee3\u7406\u914d\u7f6e\u6587\u4ef6<\/font>    4    0    NULL    1<\/font><\/span>
\n\t7    \u6162\u901f\u94fe\u63a5\u4ee3\u7406\u914d\u7f6e\u6587\u4ef6<\/font>    4    0    <\/font>\u7528\u4e8e\u4f4e\u5e26\u5bbd\u8fde\u63a5\u7684\u4ee3\u7406\u914d\u7f6e\u6587\u4ef6\u3002<\/font>    0<\/font><\/span>
\n\t8    \u8be6\u7ec6\u5386\u53f2\u8bb0\u5f55\u4ee3\u7406\u914d\u7f6e\u6587\u4ef6<\/font>    4    0    <\/font>\u7528\u4e8e\u8be6\u7ec6\u5386\u53f2\u8bb0\u5f55\u65e5\u5fd7\u7684\u4ee3\u7406\u914d\u7f6e\u6587\u4ef6\u3002<\/font>    0<\/font><\/span>
\n\t9    Windows Synchronization Manager profile    4    0    Windows \u540c\u6b65\u7ba1\u7406\u5668\u6240\u7528\u7684\u914d\u7f6e\u6587\u4ef6\u3002<\/font>    0<\/font><\/span>
\n\t10    Windows Synchronization Manager profile    3    0    Windows \u540c\u6b65\u7ba1\u7406\u5668\u6240\u7528\u7684\u914d\u7f6e\u6587\u4ef6\u3002<\/font>    0<\/font><\/span>
\n\t11    \u9ed8\u8ba4\u4ee3\u7406\u914d\u7f6e\u6587\u4ef6<\/font>    9    0    <\/font>\u7528\u4e8e\u5df2\u590d\u5236\u7684\u6392\u961f\u4e8b\u52a1\u8bfb\u53d6\u5668\u7684\u4ee3\u7406\u914d\u7f6e\u6587\u4ef6\u3002<\/font>    1<\/font><\/span>
\n\t12    \u884c\u8ba1\u6570\u9a8c\u8bc1\u914d\u7f6e\u6587\u4ef6<\/font>    4    0    <\/font>\u5408\u5e76\u4ee3\u7406\u7528\u4e8e\u6267\u884c\u884c\u8ba1\u6570\u9a8c\u8bc1\u7684\u914d\u7f6e\u6587\u4ef6\u3002<\/font>    0<\/font><\/span>
\n\t13    \u884c\u8ba1\u6570\u548c\u6821\u9a8c\u548c\u9a8c\u8bc1\u914d\u7f6e\u6587\u4ef6<\/font>    4    0    <\/font>\u5408\u5e76\u4ee3\u7406\u7528\u4e8e\u6267\u884c\u884c\u8ba1\u6570\u548c\u6821\u9a8c\u548c\u9a8c\u8bc1\u7684\u914d\u7f6e\u6587\u4ef6\u3002<\/font>    0<\/font><\/span>
\n\t14    \u9047\u5230\u6570\u636e\u4e00\u81f4\u6027\u9519\u8bef\u65f6\u7ee7\u7eed\u3002<\/font>    3    0    <\/font>\u7528\u4e8e\u8df3\u8fc7\u6570\u636e\u4e00\u81f4\u6027\u9519\u8bef\u7684\u4ee3\u7406\u914d\u7f6e\u6587\u4ef6\u3002\u5b83\u53ea\u80fd\u7531 <\/font>SQL Server <\/font>\u8ba2\u9605\u670d\u52a1\u5668\u4f7f\u7528\u3002<\/font>    0<\/font><\/span>
\n\t15    \u5927\u5bb9\u91cf\u670d\u52a1\u5668\u5bf9\u670d\u52a1\u5668\u7684\u914d\u7f6e\u6587\u4ef6<\/font>    4    0    <\/font>\u5408\u5e76\u4ee3\u7406\u914d\u7f6e\u6587\u4ef6\u5df2\u7ecf\u4f18\u5316\uff0c\u9002\u7528\u4e8e\u670d\u52a1\u5668\u4e4b\u95f4\u7684\u5927\u5bb9\u91cf\u540c\u6b65\u3002<\/font>    0<\/font><\/span>
\n\t16    \u7528\u4e8e <\/font>OLEDB <\/font>\u6d41\u5f0f\u5904\u7406\u7684\u5206\u53d1\u914d\u7f6e\u6587\u4ef6<\/font>    3    0    <\/font>\u4f7f\u7528 <\/font>OLEDB <\/font>\u6d41\u5f0f\u5904\u7406\u4e3a\u5904\u7406 <\/font>LOB <\/font>\u6570\u636e\u542f\u7528\u7684\u5206\u53d1\u4ee3\u7406\u914d\u7f6e\u6587\u4ef6\u3002<\/font>    0<\/font><\/span><\/o:p><\/span><\/p>\n

\n\t
\n\t\u901a\u5e38 \u5feb\u7167\u4ee3\u7406 agent_type = 1<\/font>\uff0c\u6240\u5bf9\u5e94\u7684<\/font>profile_id = 1<\/font><\/span><\/o:p><\/span><\/p>\n

\n\t\u65e5\u5fd7\u8bfb\u53d6\u4ee3\u7406 agent_type = 2<\/font>\uff0c\u6240\u5bf9\u5e94\u7684<\/font>profile_id = 2<\/font><\/span><\/o:p><\/span><\/p>\n

\n\t\u5206\u53d1\u4ee3\u7406 agent_type = 3<\/font>\uff0c\u6240\u5bf9\u5e94\u7684<\/font>profile_id = 4<\/font><\/span><\/o:p><\/span><\/p>\n

\n\t<\/o:p><\/span><\/p>\n

\n\t\u5982\u4e0b\u547d\u4ee4\u8fd4\u56de\u67d0\u4e2a\u4ee3\u7406\u7684\u914d\u7f6e\u4fe1\u606f\uff0c\u6ce8\u610f\u540e\u9762\u7684\u53c2\u6570\u662fprofile_id<\/font><\/span><\/o:p><\/span><\/p>\n

\n\tsp_help_agent_parameter @profile_id<\/span><\/o:p><\/span><\/p>\n

\n\t<\/o:p><\/span><\/p>\n

\n\tsp_help_agent_parameter 1 \u8fd4\u56de\u5feb\u7167\u4ee3\u7406\u914d\u7f6e\u53c2\u6570<\/font><\/span><\/o:p><\/span><\/p>\n

\n\tprofile_id parameter_name value<\/span><\/o:p><\/span><\/p>\n

\n\t1 -BcpBatchSize 100000<\/span><\/o:p><\/span><\/p>\n

\n\t1 -HistoryVerboseLevel 2<\/span><\/o:p><\/span><\/p>\n

\n\t1 -LoginTimeout 15<\/span><\/o:p><\/span><\/p>\n

\n\t1 -QueryTimeout 1800<\/span><\/o:p><\/span><\/p>\n

\n\t<\/o:p><\/span><\/p>\n

\n\t\u5728\u5feb\u7167\u4ee3\u7406\u4e2d\u589e\u52a0MaxBcpThreads<\/font>\u914d\u7f6e\u53c2\u6570\u4e3a<\/font>20<\/font><\/span><\/o:p><\/span><\/p>\n

\n\tsp_add_agent_parameter 1,'MaxBcpThreads',20<\/span><\/o:p><\/span><\/p>\n

\n\t\u5728\u65e5\u5fd7\u8bfb\u53d6\u4ee3\u7406\u4e2d\u4fee\u6539PollingInterval<\/font>\u914d\u7f6e\u53c2\u6570\u4e3a\uff13<\/font><\/span><\/o:p><\/span><\/p>\n

\n\tsp_change_agent_parameter 2,'PollingInterval',3<\/span><\/o:p><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"

\u901a\u8fc7sp_help_agent_profile\u67e5\u770b\u4ee3\u7406\u7c7b\u578b\u6240\u5bf9\u5e94\u7684profile_id,\u4e0b\u9762\u662f\u6b64\u8fc7\u7a0b\u7684\u8fd4\u56de\u7ed3\u679c […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-2798","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2798","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=2798"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2798\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2798"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2798"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2798"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}