{"id":7932,"date":"2025-05-05T14:05:35","date_gmt":"2025-05-05T07:05:35","guid":{"rendered":"https:\/\/longvan.net\/cong-dong\/?p=7932"},"modified":"2025-05-05T14:05:35","modified_gmt":"2025-05-05T07:05:35","slug":"huong-dan-cai-dat-window_exporter-monitor-microsoft-sql-server","status":"publish","type":"post","link":"https:\/\/longvan.net\/cong-dong\/huong-dan-cai-dat-window_exporter-monitor-microsoft-sql-server\/","title":{"rendered":"H\u01b0\u1edbng D\u1eabn C\u00e0i \u0110\u1eb7t Window_Exporter Monitor Microsoft Sql Server"},"content":{"rendered":"<ol>\n<li>B\u01b0\u1edbc 1 : Thao t\u00e1c download file c\u00e0i \u0111\u1eb7t window_exporter m\u1edbi nh\u1ea5t:\n<ul>\n<li style=\"text-align: left\">truy c\u1eadp trang web <a href=\"https:\/\/github.com\/prometheus-community\/windows_exporter\/releases\/tag\/v0.30.6\">https:\/\/github.com\/prometheus-community\/windows_exporter\/releases\/tag\/v0.30.6<\/a> S\u1eed d\u1ee5ng phi\u00ean b\u1ea3n Windows 64 t\u1ea3i file windows_exporter-0.30.6-amd64.msi.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-7935 aligncenter\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_10-1024x271.png\" alt=\"\" width=\"1024\" height=\"271\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_10-1024x271.png 1024w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_10-300x79.png 300w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_10-768x203.png 768w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_10.png 1516w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/li>\n<\/ul>\n<\/li>\n<li>B\u01b0\u1edbc 2 : Right-Click v\u00e0o file c\u00e0i \u0111\u1eb7t v\u1eeba t\u1ea3i v\u1ec1 -&gt; ch\u1ecdn Install -&gt; sau \u0111\u00f3 nh\u1ea5n Run \u0111\u1ec3 ti\u1ebfn h\u00e0nh c\u00e0i \u0111\u1eb7t:<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-7936 aligncenter\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_16.png\" alt=\"\" width=\"632\" height=\"447\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_16.png 632w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_16-300x212.png 300w\" sizes=\"auto, (max-width: 632px) 100vw, 632px\" \/><\/p>\n<ul>\n<li>khi ch\u1ea1y file ph\u1ea7n c\u1eeda s\u1ed5 c\u00e0i \u0111\u1eb7t xu\u1ea5t hi\u1ec7n ph\u1ea7n n\u00e0y s\u1ebd \u0111\u1ec3 m\u1eb7c \u0111\u1ecbnh v\u00e0 Net \u0111\u1ec3 c\u00e0i \u0111\u1eb7t ph\u1ea7n c\u1ea5u window_exporter<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-large wp-image-7938\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_17-1024x272.png\" alt=\"\" width=\"1024\" height=\"272\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_17-1024x272.png 1024w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_17-300x80.png 300w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_17-768x204.png 768w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_17.png 1208w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/li>\n<\/ul>\n<\/li>\n<li>B\u01b0\u1edbc 3: Truy c\u1eadp service ki\u1ec3m tra trang th\u00e1i sau khi c\u00e0i \u0111\u1eb7t:\n<ul>\n<li>V\u00e0o bi\u1ec3u t\u01b0\u1ee3ng Windows -&gt; t\u00ecm ki\u1ebfm v\u00e0 truy c\u1eadp v\u00e0o Services.<\/li>\n<li>\u0110\u1ea3m b\u1ea3o service windows_exporter \u0111\u00e3 running k\u00e8m v\u1edbi Automatic (kh\u1edfi \u0111\u1ed9ng c\u00f9ng h\u1ec7 th\u1ed1ng)<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-7939\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_20.png\" alt=\"\" width=\"770\" height=\"260\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_20.png 770w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_20-300x101.png 300w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_20-768x259.png 768w\" sizes=\"auto, (max-width: 770px) 100vw, 770px\" \/><\/li>\n<\/ul>\n<\/li>\n<li>Ki\u1ec3m tra\u00a0 port tr\u00ean firewall\n<ul>\n<li>T\u00ecm ki\u1ebfm v\u00e0 truy c\u1eadp Windows Firewall with Advanced Security.<\/li>\n<li>Trong m\u1ee5c Inbound Rule, \u1ede \u0111\u00e2y ph\u1ea7n khi c\u00e0i \u0111\u1eb7t \u0111\u00e3 ch\u1ecdn ph\u1ea7n c\u1ea5u m\u1edf port \u1edf ph\u1ea7n firewall se kh\u00f4ng c\u1ea7n thao t\u00e1c m\u1edf th\u00eam port , m\u1eb7c \u0111\u1ecbnh ph\u1ea7n service s\u1ebd ch\u1ea1y port 9182<\/li>\n<li><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-7940 aligncenter\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_21.png\" alt=\"\" width=\"631\" height=\"329\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_21.png 894w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_21-300x156.png 300w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_21-768x400.png 768w\" sizes=\"auto, (max-width: 631px) 100vw, 631px\" \/><\/li>\n<\/ul>\n<\/li>\n<li>B\u01b0\u1edbc 5 : c\u1ea5u h\u00ecnh file conf.yaml c\u1ea3u ph\u1ea7n window_exporter \u0111\u1ec3 c\u00f3 ghi nh\u1eadn ph\u1ea7n metrics c\u1ee7a MSSQL .\n<ul>\n<li>Truy c\u1eadp v\u00e0o \u0111\u01b0\u1eddng d\u1eabn sau \u0111\u1ec3 c\u1ea5u h\u00ecnh c\u00e1c file \u0111\u1ec3 c\u00f3 th\u1ec3 ghi nh\u1eadn \u0111\u01b0\u1ee3c ph\u1ea7n metrics c\u1ee7a mssql.<\/li>\n<li>C:\\Program Files\\windows_exporter<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-7942\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_22.png\" alt=\"\" width=\"686\" height=\"183\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_22.png 686w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Screenshot_22-300x80.png 300w\" sizes=\"auto, (max-width: 686px) 100vw, 686px\" \/><\/li>\n<li>C:\\Program Files\\windows_exporter\\config.yaml (file c\u00f3 s\u1eb5n khi c\u00e0i window exporter)\n<ul>\n<li>M\u1ee5c \u0111\u00edch: File c\u1ea5u h\u00ecnh ch\u00ednh cho Windows Exporter (t\u1eeb phi\u00ean b\u1ea3n 0.18+)<\/li>\n<li>Khi n\u00e0o d\u00f9ng: Khi mu\u1ed1n c\u1ea5u h\u00ecnh t\u1eadp trung t\u1ea5t c\u1ea3 collectors, \u01afu ti\u00ean s\u1eed d\u1ee5ng thay cho tham s\u1ed1 d\u00f2ng l\u1ec7nh.<\/li>\n<li>collectors:<br \/>\nenabled: cpu,memory,net,service,mssql,textfile,cs,logical_disk<br \/>\ntextfile:<br \/>\ndirectory: C:\\Program Files\\windows_exporter\\textfile_inputs<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-7954\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/05\/Screenshot_12.png\" alt=\"\" width=\"630\" height=\"231\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/05\/Screenshot_12.png 630w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/05\/Screenshot_12-300x110.png 300w\" sizes=\"auto, (max-width: 630px) 100vw, 630px\" \/><\/li>\n<\/ul>\n<\/li>\n<li>sau khi thao t\u00e1c c\u1ea5u h\u00ecnh c\u00e1c file tr\u00ean xong truy c\u1eadp v\u00e0o ph\u1ea7n service nh\u01b0 \u1edf B\u01b0\u1edbc 3 thao t\u00e1c restart l\u1ea1i service v\u00e0 truy c\u1eadp ph\u1ea7n metrics \u0111\u1ec3 check th\u00f4ng tin v\u00e0 d\u1eef li\u1ec7u metrics ghi nh\u1eadn \u0111\u01b0\u1ee3c .<\/li>\n<\/ul>\n<\/li>\n<li>Tuy c\u1eadp link metrics \u0111\u1ec3 check th\u00f4ng tin sao khi c\u1ea5u h\u00ecnh c\u00e1c file tr\u00ean .\n<ul>\n<li>Truy c\u1eadp v\u1edbi v\u1edbi url http:\/\/ip-address:9182\/metrics<\/li>\n<li><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-7947\" src=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Untitled-1024x389.png\" alt=\"\" width=\"940\" height=\"357\" srcset=\"https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Untitled-1024x389.png 1024w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Untitled-300x114.png 300w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Untitled-768x292.png 768w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Untitled-1536x583.png 1536w, https:\/\/longvan.net\/cong-dong\/wp-content\/uploads\/2025\/04\/Untitled-2048x778.png 2048w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p><img decoding=\"async\" id=\"image-hover-icon\" style=\"position: absolute;width: 25px;height: 25px;cursor: pointer;left: 53px;top: 346.388px;opacity: 0.7\" src=\"\/\/pbhpcbdjngblklnibanbkgkogjmbjeoe\/src\/public\/images\/128px.png\" \/><\/p>\n<p>Nh\u01b0 v\u1eady, Long V\u00e2n \u0111\u00e3 ho\u00e0n th\u00e0nh h\u01b0\u1edbng d\u1eabn c\u00e0i \u0111\u1eb7t Node Exporter tr\u00ean h\u1ec7 \u0111i\u1ec1u h\u00e0nh Windows, Ch\u00fac Qu\u00fd kh\u00e1ch th\u00e0nh c\u00f4ng !<\/p>\n","protected":false},"excerpt":{"rendered":"<p>B\u01b0\u1edbc 1 : Thao t\u00e1c download file c\u00e0i \u0111\u1eb7t window_exporter m\u1edbi nh\u1ea5t: truy c\u1eadp trang web https:\/\/github.com\/prometheus-community\/windows_exporter\/releases\/tag\/v0.30.6 S\u1eed d\u1ee5ng phi\u00ean b\u1ea3n Windows 64 t\u1ea3i file windows_exporter-0.30.6-amd64.msi. B\u01b0\u1edbc 2 : Right-Click v\u00e0o file c\u00e0i \u0111\u1eb7t v\u1eeba t\u1ea3i v\u1ec1 -&gt; ch\u1ecdn Install -&gt; sau \u0111\u00f3 nh\u1ea5n Run \u0111\u1ec3 ti\u1ebfn h\u00e0nh c\u00e0i \u0111\u1eb7t: khi ch\u1ea1y file ph\u1ea7n c\u1eeda [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_oasis_is_in_workflow":0,"_oasis_original":0,"footnotes":""},"categories":[1,15],"tags":[],"class_list":["post-7932","post","type-post","status-publish","format-standard","hentry","category-huong-dan-chung","category-windows"],"_links":{"self":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts\/7932","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/comments?post=7932"}],"version-history":[{"count":8,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts\/7932\/revisions"}],"predecessor-version":[{"id":7955,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/posts\/7932\/revisions\/7955"}],"wp:attachment":[{"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/media?parent=7932"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/categories?post=7932"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/longvan.net\/cong-dong\/wp-json\/wp\/v2\/tags?post=7932"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}