<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:dc="http://purl.org/dc/elements/1.1/">
  <channel>
    <title>Forem: chandan kumar</title>
    <description>The latest articles on Forem by chandan kumar (@chandansqlexpert).</description>
    <link>https://forem.com/chandansqlexpert</link>
    <image>
      <url>https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F3813124%2F068aa6e3-4c10-4b79-a493-97744d19bab0.png</url>
      <title>Forem: chandan kumar</title>
      <link>https://forem.com/chandansqlexpert</link>
    </image>
    <atom:link rel="self" type="application/rss+xml" href="https://forem.com/feed/chandansqlexpert"/>
    <language>en</language>
    <item>
      <title>How to monitor Windows Server and SQL Server for $0 using SQL Planner.</title>
      <dc:creator>chandan kumar</dc:creator>
      <pubDate>Sun, 08 Mar 2026 16:11:37 +0000</pubDate>
      <link>https://forem.com/chandansqlexpert/how-to-monitor-windows-server-and-sql-server-for-0-using-sql-planner-kg</link>
      <guid>https://forem.com/chandansqlexpert/how-to-monitor-windows-server-and-sql-server-for-0-using-sql-planner-kg</guid>
      <description>&lt;p&gt;As a DBA, I’ve always been frustrated by the "monitoring tax." You either pay thousands of dollars for enterprise tools, or you’re stuck with basic scripts that don't give you the full picture. I wanted a tool that combined deep SQL metrics (deadlocks, expensive queries, health checks) with Windows OS-level monitoring (CPU, IO, Memory, IIS, Services) under one roof.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;What is SQL Planner?&lt;/strong&gt;&lt;br&gt;
I’ve spent the last 5+ years building SQL Planner to bridge this gap. It’s a lightweight tool designed to handle:&lt;/p&gt;

&lt;p&gt;&lt;u&gt;Performance Analytics:&lt;/u&gt; Real-time monitoring of blockers, long-running queries, and IO latency.&lt;br&gt;
&lt;u&gt;Database Automation:&lt;/u&gt; Handling SQL Monitoring, Auditing, backups, and automated index defragmentation.&lt;br&gt;
&lt;u&gt;Windows Monitoring:&lt;/u&gt; Monitoring IIS, Windows Services, and OS-level resources without a massive agent footprint.&lt;br&gt;
Reporting: 100+ deep-dive reports for audit and health checks.&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fsf0110it5mfekceygozu.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fsf0110it5mfekceygozu.png" alt=" " width="800" height="422"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fakjjm6om2x6wy5386h82.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fakjjm6om2x6wy5386h82.png" alt=" " width="800" height="423"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Flh6aunop93u6lr0f00e5.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Flh6aunop93u6lr0f00e5.png" alt=" " width="800" height="428"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;a href="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fc76ydnxa3nucun6i1clf.png" class="article-body-image-wrapper"&gt;&lt;img src="https://media2.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Farticles%2Fc76ydnxa3nucun6i1clf.png" alt=" " width="800" height="383"&gt;&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;The Tech Stack&lt;/strong&gt;&lt;br&gt;
The tool is designed for Windows environments. I focused heavily on ensuring the monitoring overhead is negligible—collecting 100+ metrics shouldn't become the performance bottleneck it’s trying to solve.&lt;br&gt;
&lt;strong&gt;Why Free?&lt;/strong&gt;&lt;br&gt;
I’m offering this for free to the community. I believe every developer and DBA should have access to professional-grade monitoring regardless of their company's budget.&lt;/p&gt;

&lt;p&gt;&lt;strong&gt;I would love your feedback on:&lt;/strong&gt;&lt;br&gt;
Missing Metrics: What is the one SQL Server metric that always saves your life during a production outage?&lt;br&gt;
UI/UX: Is the dashboard intuitive enough for a sysadmin who isn't a SQL expert?&lt;/p&gt;

&lt;p&gt;Link: &lt;a href="https://mssqlplanner.com" rel="noopener noreferrer"&gt;https://mssqlplanner.com&lt;/a&gt;&lt;/p&gt;

</description>
      <category>sqlserver</category>
      <category>servermonitor</category>
      <category>monitoring</category>
      <category>productivity</category>
    </item>
  </channel>
</rss>
