{"id":30193,"date":"2025-12-23T15:36:51","date_gmt":"2025-12-23T10:06:51","guid":{"rendered":"https:\/\/opstree.com\/blog\/?p=30193"},"modified":"2026-01-03T13:26:32","modified_gmt":"2026-01-03T07:56:32","slug":"monitoring-mssql-prometheus-grafana","status":"publish","type":"post","link":"https:\/\/opstree.com\/blog\/2025\/12\/23\/monitoring-mssql-prometheus-grafana\/","title":{"rendered":"Windows Exporter Setup for Monitoring MSSQL on Windows Server"},"content":{"rendered":"<p data-start=\"1236\" data-end=\"1482\">Modern enterprises rely heavily on <strong data-start=\"1271\" data-end=\"1303\">Microsoft SQL Server (MSSQL)<\/strong> to power mission-critical applications. However, without proper monitoring, SQL Server performance issues can go unnoticed, leading to downtime, slow queries, and business impact.<!--more--><\/p>\n<p data-start=\"1236\" data-end=\"1482\"><!-- ===== TABLE OF CONTENTS START ===== --><\/p>\n<div style=\"background: #f8fafc; padding: 18px; border: 1px solid #e2e8f0; border-radius: 6px; font-family: Inter, Arial, sans-serif;\">\n<h2 style=\"margin-top: 0; font-size: 18px;\">Table of Contents<\/h2>\n<ol style=\"margin: 0; padding-left: 18px; line-height: 1.6;\">\n<li><a style=\"text-decoration: none; color: #2563eb;\" href=\"#objective\">Objective<br \/>\n<\/a><\/li>\n<li><a style=\"text-decoration: none; color: #2563eb;\" href=\"#requirements\">Requirements<br \/>\n<\/a><\/li>\n<li><a style=\"text-decoration: none; color: #2563eb;\" href=\"#install-mssql\">Installation and Setup of MSSQL<br \/>\n<\/a><\/li>\n<li><a style=\"text-decoration: none; color: #2563eb;\" href=\"#install-ssms\">Install SQL Server Management Studio (SSMS)<br \/>\n<\/a><\/li>\n<li><a style=\"text-decoration: none; color: #2563eb;\" href=\"#sql-agent-auto-start\">Enabling Automatic Start for SQL Server Agent<br \/>\n<\/a><\/li>\n<li><a style=\"text-decoration: none; color: #2563eb;\" href=\"#install-windows-exporter\">Install Prometheus Windows Exporter<br \/>\n<\/a><\/li>\n<li><a style=\"text-decoration: none; color: #2563eb;\" href=\"#open-registry-editor\">Open Registry Editor<br \/>\n<\/a><\/li>\n<li><a style=\"text-decoration: none; color: #2563eb;\" href=\"#conclusion\">Conclusion<\/a><\/li>\n<\/ol>\n<\/div>\n<h2 id=\"objective\" aria-level=\"2\"><b><span data-contrast=\"none\">Objective<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:299,&quot;335559739&quot;:299}\">\u00a0<\/span><\/h2>\n<p><span data-contrast=\"auto\">The\u00a0objective\u00a0of this\u00a0document is\u00a0to\u00a0<\/span><b><span data-contrast=\"auto\">monitor MSSQL performance metrics<\/span><\/b><span data-contrast=\"auto\">\u00a0on a Windows Server using\u00a0<\/span><a href=\"https:\/\/opstree.com\/blog\/2022\/10\/04\/prometheus-and-grafana-on-kubernetes\/\" target=\"_blank\" rel=\"noopener\"><b><span data-contrast=\"auto\">Prometheus<\/span><\/b><span data-contrast=\"auto\">\u00a0and\u00a0<\/span><b><span data-contrast=\"auto\">Grafana<\/span><\/b><\/a><span data-contrast=\"auto\">.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">The goal is to help you set up a reliable monitoring pipeline that includes:<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<ul>\n<li><span data-contrast=\"auto\">Installing MSSQL Server and SQL Server Management Studio (SSMS)<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Enabling SQL Server Agent<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Installing and configuring the Windows Exporter<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Setting up Prometheus and Grafana on <a href=\"https:\/\/opstree.com\/blog\/2019\/04\/02\/resolving-segmentation-fault-core-dumped-in-ubuntu\/\" target=\"_blank\" rel=\"noopener\">Ubuntu<\/a><\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Visualizing MSSQL metrics in Grafana dashboards<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n<h2 id=\"requirements\" aria-level=\"2\"><b><span data-contrast=\"none\">Requirements<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:299,&quot;335559739&quot;:299}\">\u00a0<\/span><\/h2>\n<p><span data-contrast=\"auto\">Before starting, ensure the following prerequisites are met:<\/span><\/p>\n<div style=\"overflow-x: auto; -webkit-overflow-scrolling: touch; margin: 20px 0;\">\n<table style=\"width: 100%; border-collapse: collapse; min-width: 520px; font-family: Arial, sans-serif; font-size: 14px;\">\n<thead>\n<tr>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px; text-align: left; background: #f9fafb;\">Component<\/th>\n<th style=\"border: 1px solid #e5e7eb; padding: 10px; text-align: left; background: #f9fafb;\">Description<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px;\"><strong>Windows Server<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px;\">Host machine where MSSQL Server is installed<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px;\"><strong>MSSQL Server 2022 Developer Edition<\/strong><\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px;\">Database engine to monitor<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px;\">SQL Server Management Studio (SSMS)<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px;\">Tool for database administration and queries<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px;\">Prometheus<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px;\">Metrics collection tool (installed on Ubuntu)<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px;\">Grafana<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px;\">Visualization and dashboarding tool (installed on Ubuntu)<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px;\">Windows Exporter<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px;\">Exposes Windows system and MSSQL performance metrics<\/td>\n<\/tr>\n<tr>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px;\">Open Ports<\/td>\n<td style=\"border: 1px solid #e5e7eb; padding: 10px;\">9182 (Windows Exporter), 9090 (Prometheus), 3000 (Grafana)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<div style=\"border: 1px solid #d1d5db; padding: 16px; margin: 20px 0; background-color: #f0f4f8;\">\n<p style=\"margin: 0; font-weight: 600; font-size: 16px;\">Also Read &#8211; <a href=\"https:\/\/opstree.com\/blog\/2025\/11\/15\/real-time-data-processing\/\" target=\"_blank\" rel=\"noopener\">Real-Time Data Processing: Why Stream Data is the Future of Business Decisions<\/a><\/p>\n<\/div>\n<h2 id=\"install-mssql\" aria-level=\"2\"><b><span data-contrast=\"none\">Installation and Setup of MSSQL<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:299,&quot;335559739&quot;:299}\">\u00a0<\/span><\/h2>\n<p><span data-contrast=\"auto\">Download and Install MSSQL<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/p>\n<ul>\n<li><span data-contrast=\"auto\">Visit the official\u00a0<\/span><a href=\"https:\/\/www.microsoft.com\/en-in\/sql-server\/sql-server-downloads\" target=\"_blank\" rel=\"noopener\"><span data-contrast=\"none\">SQL Server download page.<\/span><\/a><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Under SQL Server 2022 Developer Edition, click Download now.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">During installation:<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Select Basic installation<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Accept the license terms<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Click Install<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">The setup takes around 10\u201320 minutes<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Keep the default instance name unless you want to customize it.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Click Connect when installation is\u00a0completed.<\/span><span data-ccp-props=\"{}\">\u00a0<\/span><\/li>\n<\/ul>\n<h2 id=\"install-ssms\" aria-level=\"2\"><b><span data-contrast=\"none\">Install SQL Server Management Studio (SSMS)<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:299,&quot;335559739&quot;:299}\">\u00a0<\/span><\/h2>\n<ul>\n<li><span data-contrast=\"auto\">Download SSMS from the\u00a0<\/span><a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/ssms\/download-sql-server-management-studio-ssms\" target=\"_blank\" rel=\"nofollow noopener\"><span data-contrast=\"none\">official Microsoft website<\/span><\/a><span data-contrast=\"auto\">\u00a0<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Run the installer and complete the setup.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<\/ul>\n<p aria-level=\"2\"><span data-contrast=\"none\">Enable SQL Server Agent in SSMS<\/span><span data-ccp-props=\"{&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:160,&quot;335559739&quot;:80}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Prometheus relies on SQL Server Agent to expose certain SQL-related metrics.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<ol>\n<li><span data-contrast=\"auto\">Open\u00a0<\/span><b><span data-contrast=\"auto\">SSMS.<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">In\u00a0<\/span><b><span data-contrast=\"auto\">Object Explorer<\/span><\/b><span data-contrast=\"auto\">,\u00a0locate\u00a0<\/span><b><span data-contrast=\"auto\">SQL Server Agent.<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Right-click \u2192\u00a0<\/span><b><span data-contrast=\"auto\">Start<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30194 size-large\" src=\"https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/page3_image1-1024x576.png\" alt=\"\" width=\"840\" height=\"473\" srcset=\"https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/page3_image1-1024x576.png 1024w, https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/page3_image1-300x169.png 300w, https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/page3_image1-768x432.png 768w, https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/page3_image1-1200x675.png 1200w, https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/page3_image1.png 1366w\" sizes=\"(max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/p>\n<h3 id=\"sql-agent-auto-start\" aria-level=\"3\"><b><span data-contrast=\"none\">Enabling Automatic Start for SQL Server Agent<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:281,&quot;335559739&quot;:281}\">\u00a0<\/span><\/h3>\n<p><span data-contrast=\"auto\">Follow the steps below to configure the\u00a0<\/span><b><span data-contrast=\"auto\">SQL Server Agent<\/span><\/b><span data-contrast=\"auto\">\u00a0service to start automatically when Windows boots:<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<ol>\n<li><span data-contrast=\"auto\">Press\u00a0<\/span><b><span data-contrast=\"auto\">Windows + R<\/span><\/b><span data-contrast=\"auto\">\u00a0to open the Run dialog.\u00a0<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Type\u00a0<\/span><b><span data-contrast=\"auto\">services.msc<\/span><\/b><span data-contrast=\"auto\">\u00a0and press\u00a0<\/span><b><span data-contrast=\"auto\">Enter<\/span><\/b><span data-contrast=\"auto\">\u00a0to open the\u00a0<\/span><b><span data-contrast=\"auto\">Services<\/span><\/b><span data-contrast=\"auto\">\u00a0window.\u00a0<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Locate the service named\u00a0<\/span><b><span data-contrast=\"auto\">SQL Server Agent ()<\/span><\/b><span data-contrast=\"auto\">, where\u00a0<\/span><span data-contrast=\"auto\">&lt;InstanceName&gt;<\/span><span data-contrast=\"auto\">\u00a0is the name of your SQL Server instance.\u00a0<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Double-click the\u00a0<\/span><b><span data-contrast=\"auto\">SQL Server Agent<\/span><\/b><span data-contrast=\"auto\">\u00a0service to open its\u00a0<\/span><b><span data-contrast=\"auto\">Properties<\/span><\/b><span data-contrast=\"auto\">\u00a0window.\u00a0<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">In the\u00a0<\/span><b><span data-contrast=\"auto\">Startup type<\/span><\/b><span data-contrast=\"auto\">\u00a0dropdown menu, select\u00a0<\/span><b><span data-contrast=\"auto\">Automatic<\/span><\/b><span data-contrast=\"auto\">.\u00a0<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 &#8211; <\/span><span data-contrast=\"auto\">You can also choose <\/span><b><span data-contrast=\"auto\">Automatic (Delayed Start)<\/span><\/b><span data-contrast=\"auto\"> if you want other services to start first.<img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30195 size-large\" src=\"https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/page4_image1-1024x576.png\" alt=\"\" width=\"840\" height=\"473\" srcset=\"https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/page4_image1-1024x576.png 1024w, https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/page4_image1-300x169.png 300w, https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/page4_image1-768x432.png 768w, https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/page4_image1-1200x675.png 1200w, https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/page4_image1.png 1366w\" sizes=\"(max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/span><\/li>\n<li><span class=\"NormalTextRun SCXW82373383 BCX0\">Click <\/span><span class=\"TextRun SCXW82373383 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW82373383 BCX0\">Apply<\/span><\/span><span class=\"TextRun SCXW82373383 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW82373383 BCX0\">, and then\u00a0<\/span><\/span><span class=\"TextRun SCXW82373383 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW82373383 BCX0\">OK<\/span><\/span><span class=\"TextRun SCXW82373383 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW82373383 BCX0\">\u00a0to save the\u00a0<\/span><span class=\"NormalTextRun SCXW82373383 BCX0\">changes. To<\/span><span class=\"NormalTextRun SCXW82373383 BCX0\">\u00a0verify\u00a0<\/span><span class=\"NormalTextRun SCXW82373383 BCX0\">it<\/span><span class=\"NormalTextRun SCXW82373383 BCX0\">\u00a0check startup type\u00a0<\/span><span class=\"NormalTextRun SCXW82373383 BCX0\">changes automatically<\/span><span class=\"NormalTextRun SCXW82373383 BCX0\">.\u00a0<\/span><\/span><span class=\"EOP SCXW82373383 BCX0\" data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30196 size-large\" src=\"https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/page4_image2-1024x576.png\" alt=\"\" width=\"840\" height=\"473\" srcset=\"https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/page4_image2-1024x576.png 1024w, https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/page4_image2-300x169.png 300w, https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/page4_image2-768x432.png 768w, https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/page4_image2-1200x675.png 1200w, https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/page4_image2.png 1366w\" sizes=\"(max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/p>\n<h2 id=\"install-windows-exporter\" aria-level=\"2\"><b><span data-contrast=\"none\">Install Prometheus Windows Exporter<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:299,&quot;335559739&quot;:299}\">\u00a0<\/span><\/h2>\n<p><span data-contrast=\"auto\">Prometheus Windows Exporter helps expose system and MSSQL metrics for monitoring.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<p aria-level=\"3\"><b><span data-contrast=\"none\">Steps:<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:281,&quot;335559739&quot;:281}\">\u00a0<\/span><\/p>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"22\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Download Windows Exporter<\/span><span data-ccp-props=\"{&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><span data-contrast=\"auto\">Visit the <\/span><a href=\"https:\/\/github.com\/prometheus-community\/windows_exporter\/releases\" target=\"_blank\" rel=\"nofollow noopener\"><span data-contrast=\"none\">official releases page<\/span><\/a><span data-contrast=\"auto\">\u00a0to download the latest version of\u00a0Windows Exporter.<\/span><\/p>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"22\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"2\" data-aria-level=\"1\"><span data-contrast=\"auto\">Download the Binary File<\/span><span data-ccp-props=\"{&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><span data-contrast=\"auto\">\u00a0Select and download the binary file:<\/span><\/p>\n<ul>\n<li><span data-contrast=\"auto\">Open Command Prompt as Administrator<\/span><\/li>\n<li><span data-contrast=\"auto\">Press\u00a0Start \u2192 Search \u201ccmd\u201d \u2192 Right-click \u2192 Run as Administrator.<\/span><\/li>\n<li><span data-contrast=\"auto\">Run the Exporter Manually<\/span><span data-ccp-props=\"{&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<\/ul>\n<p><span data-contrast=\"auto\">Execute the following command to start the Windows Exporter and fetch SQL Server statistics:<\/span><\/p>\n<pre style=\"background: #0f172a; color: #e5e7eb; padding: 16px; border-radius: 8px; font-size: 14px; line-height: 1.6; overflow-x: auto; max-width: 100%;\"><span class=\"TextRun SCXW227058626 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW227058626 BCX0\" data-ccp-parastyle=\"No Spacing\">\u00a0<\/span><span class=\"NormalTextRun SCXW227058626 BCX0\" data-ccp-parastyle=\"No Spacing\">\"C:\\Program Files\\<\/span><span class=\"NormalTextRun SCXW227058626 BCX0\" data-ccp-parastyle=\"No Spacing\">windows_exporter<\/span><span class=\"NormalTextRun SCXW227058626 BCX0\" data-ccp-parastyle=\"No Spacing\">\\windows_exporter-0.31.3-amd64.exe\" --<\/span><span class=\"NormalTextRun SCXW227058626 BCX0\" data-ccp-parastyle=\"No Spacing\">collectors.enabled<\/span><span class=\"NormalTextRun SCXW227058626 BCX0\" data-ccp-parastyle=\"No Spacing\">=\"<\/span><span class=\"NormalTextRun SCXW227058626 BCX0\" data-ccp-parastyle=\"No Spacing\">cpu,logical_disk,net,os,service,system,textfile,mssql<\/span><span class=\"NormalTextRun SCXW227058626 BCX0\" data-ccp-parastyle=\"No Spacing\">\"<\/span><\/span><span class=\"LineBreakBlob BlobObject DragDrop SCXW227058626 BCX0\"><span class=\"SCXW227058626 BCX0\">\u00a0<\/span><br class=\"SCXW227058626 BCX0\" \/><\/span><\/pre>\n<p><span data-contrast=\"auto\">5.<\/span><b><span data-contrast=\"auto\">Verify the Metrics Endpoint<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/p>\n<ul>\n<li aria-setsize=\"-1\" data-leveltext=\"\uf0b7\" data-font=\"Symbol\" data-listid=\"10\" data-list-defn-props=\"{&quot;335552541&quot;:1,&quot;335559685&quot;:720,&quot;335559991&quot;:360,&quot;469769226&quot;:&quot;Symbol&quot;,&quot;469769242&quot;:[8226],&quot;469777803&quot;:&quot;left&quot;,&quot;469777804&quot;:&quot;\uf0b7&quot;,&quot;469777815&quot;:&quot;hybridMultilevel&quot;}\" data-aria-posinset=\"1\" data-aria-level=\"1\"><span data-contrast=\"auto\">Press Open your browser and navigate to:\u00a0<\/span><span data-contrast=\"none\">http:\/\/PublicIp:9182\/metrics<\/span><\/li>\n<\/ul>\n<p aria-level=\"2\"><b><span data-contrast=\"none\">Run Windows Exporter Automatically After System Restart<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;134245418&quot;:true,&quot;134245529&quot;:true,&quot;335559738&quot;:299,&quot;335559739&quot;:299}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">To ensure the Windows Exporter service starts automatically after a system reboot, follow these steps<\/span><\/p>\n<div style=\"border: 1px solid #d1d5db; padding: 16px; margin: 20px 0; background-color: #f0f4f8;\">\n<p style=\"margin: 0; font-weight: 600; font-size: 16px;\">Case Study : <a href=\"https:\/\/opstree.com\/case-study\/accelerating-a-global-tech-leaders-ads-platform-with-strategic-devops-platform-and-data-engineering\/\" target=\"_blank\" rel=\"noopener\">Accelerating a Global Tech Leader\u2019s Ads Platform with Strategic DevOps, Platform, and Data Engineering<\/a><\/p>\n<\/div>\n<h2 id=\"open-registry-editor\"><b><span data-contrast=\"auto\">Open Registry Editor<\/span><\/b><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:240,&quot;335559739&quot;:240}\">\u00a0<\/span><\/h2>\n<ul>\n<li><span data-contrast=\"auto\">Press Start \u2192 Search \u201cregedit\u201d \u2192 Open Registry Editor<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"auto\">Navigate to the Following Path:<\/span><\/li>\n<\/ul>\n<p><span data-contrast=\"auto\">HKEY_LOCAL_MACHINE\\SYSTEM\\CurrentControlSet\\Services\\windows_exporter\u00a0Modify the\u00a0ImagePath\u00a0Value,Double-click on\u00a0ImagePath.<\/span><span data-ccp-props=\"{&quot;335559739&quot;:0}\">\u00a0<\/span><\/p>\n<p><span data-contrast=\"auto\">Replace the existing value with the following (adjust if your installation path differs):<\/span><\/p>\n<pre style=\"background: #0f172a; color: #e5e7eb; padding: 16px; border-radius: 8px; font-size: 14px; line-height: 1.6; overflow-x: auto; max-width: 100%;\"><span class=\"TextRun SCXW220938105 BCX0\" lang=\"EN-US\" xml:lang=\"EN-US\" data-contrast=\"auto\"><span class=\"NormalTextRun SCXW220938105 BCX0\" data-ccp-parastyle=\"No Spacing\">\"C:\\Program Files\\<\/span><span class=\"NormalTextRun SCXW220938105 BCX0\" data-ccp-parastyle=\"No Spacing\">windows_exporter<\/span><span class=\"NormalTextRun SCXW220938105 BCX0\" data-ccp-parastyle=\"No Spacing\">\\windows_exporter-0.31.3-amd64.exe\" --<\/span><span class=\"NormalTextRun SCXW220938105 BCX0\" data-ccp-parastyle=\"No Spacing\">collectors.enabled<\/span><span class=\"NormalTextRun SCXW220938105 BCX0\" data-ccp-parastyle=\"No Spacing\">=\"<\/span><span class=\"NormalTextRun SCXW220938105 BCX0\" data-ccp-parastyle=\"No Spacing\">cpu,logical_disk,net,os,service,system,textfile,mssql<\/span><span class=\"NormalTextRun SCXW220938105 BCX0\" data-ccp-parastyle=\"No Spacing\">\"<\/span><\/span><span class=\"EOP SCXW220938105 BCX0\" data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335559738&quot;:281,&quot;335559739&quot;:281}\">\u00a0<\/span><\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30199 size-large\" src=\"https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/image_4_page_6-1024x576.png\" alt=\"\" width=\"840\" height=\"473\" srcset=\"https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/image_4_page_6-1024x576.png 1024w, https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/image_4_page_6-300x169.png 300w, https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/image_4_page_6-768x432.png 768w, https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/image_4_page_6-1200x675.png 1200w, https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/image_4_page_6.png 1366w\" sizes=\"(max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/p>\n<ul>\n<li><span data-contrast=\"none\">Press\u00a0<\/span><b><span data-contrast=\"none\">Windows + R<\/span><\/b><span data-contrast=\"none\">\u00a0to open the Run dialog.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335557856&quot;:16777215,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"none\">Type\u00a0<\/span><b><span data-contrast=\"none\">services.msc<\/span><\/b><span data-contrast=\"none\">\u00a0and press\u00a0<\/span><b><span data-contrast=\"none\">Enter<\/span><\/b><span data-contrast=\"none\">\u00a0to open the\u00a0<\/span><b><span data-contrast=\"none\">Services<\/span><\/b><span data-contrast=\"none\">\u00a0window.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335557856&quot;:16777215,&quot;335559738&quot;:0,&quot;335559739&quot;:0}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"none\">Double-click the\u00a0<\/span><b><span data-contrast=\"none\">window exporter<\/span><\/b><span data-contrast=\"none\">\u00a0service to open its\u00a0<\/span><b><span data-contrast=\"none\">Properties<\/span><\/b><span data-contrast=\"none\">\u00a0window.<\/span><span data-ccp-props=\"{&quot;134233117&quot;:false,&quot;134233118&quot;:false,&quot;335557856&quot;:16777215,&quot;335559738&quot;:0,&quot;335559739&quot;:240}\">\u00a0<\/span><\/li>\n<li><span data-contrast=\"none\">In the\u00a0<\/span><b><span data-contrast=\"none\">Startup type<\/span><\/b><span data-contrast=\"none\">\u00a0dropdown menu, select\u00a0<\/span><b><span data-contrast=\"none\">Automatic<\/span><\/b><span data-contrast=\"none\">,\u00a0You\u00a0can also choose\u00a0<\/span><b><span data-contrast=\"none\">Automatic (Delayed Start)<\/span><\/b><span data-contrast=\"none\">\u00a0if you want other services to start first.<\/span><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30200 size-large\" src=\"https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/image_5_page_7-1024x435.png\" alt=\"\" width=\"840\" height=\"357\" srcset=\"https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/image_5_page_7-1024x435.png 1024w, https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/image_5_page_7-300x127.png 300w, https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/image_5_page_7-768x326.png 768w, https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/image_5_page_7-1200x510.png 1200w, https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/image_5_page_7.png 1342w\" sizes=\"(max-width: 709px) 85vw, (max-width: 909px) 67vw, (max-width: 1362px) 62vw, 840px\" \/><\/p>\n<h2 id=\"conclusion\" data-start=\"6670\" data-end=\"6687\"><strong data-start=\"6673\" data-end=\"6687\">Conclusion<\/strong><\/h2>\n<p data-start=\"6689\" data-end=\"6845\">Monitoring MSSQL on Windows Server using <strong data-start=\"6730\" data-end=\"6775\">Windows Exporter, Prometheus, and Grafana<\/strong> provides deep visibility into database health and system performance.<\/p>\n<p data-start=\"6689\" data-end=\"6845\"><strong>Related Searches &#8211; <a href=\"https:\/\/opstree.com\/services\/database-and-data-engineering\/\" target=\"_blank\" rel=\"noopener\">Data Engineering Solutions<\/a> | <a href=\"https:\/\/opstree.com\/blog\/2023\/06\/20\/database-migration-service-in-aws\/\" target=\"_blank\" rel=\"noopener\">Database Migration Services<\/a> | <a href=\"https:\/\/opstree.com\/blog\/2025\/10\/27\/data-engineering-companies\/\" target=\"_blank\" rel=\"noopener\">Best data engineering company in India<\/a>\u00a0<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Modern enterprises rely heavily on Microsoft SQL Server (MSSQL) to power mission-critical applications. However, without proper monitoring, SQL Server performance issues can go unnoticed, leading to downtime, slow queries, and business impact.<\/p>\n","protected":false},"author":244582716,"featured_media":30230,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false},"version":2}},"categories":[28070474],"tags":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/opstree.com\/blog\/wp-content\/uploads\/2025\/12\/Blog-Image-Template-9.jpg","jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pfDBOm-7QZ","jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/posts\/30193"}],"collection":[{"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/users\/244582716"}],"replies":[{"embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/comments?post=30193"}],"version-history":[{"count":7,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/posts\/30193\/revisions"}],"predecessor-version":[{"id":30232,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/posts\/30193\/revisions\/30232"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/media\/30230"}],"wp:attachment":[{"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/media?parent=30193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/categories?post=30193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/opstree.com\/blog\/wp-json\/wp\/v2\/tags?post=30193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}