How to Baseline Microsoft SQL Server with Open Source Tools

Spread the love

Are you tired of not knowing what is usual workload of your server? Do you want to know what is speed of your server?

If you are a developer or DBA who manages Microsoft SQL Servers, it becomes important to understand the current load vs usual load when SQL Server is slow.

Recently, for this reason, I have been working on my own automation to capture performance counters that would help me get an idea of CPU/Memory/IO/Network issues. Baselining also lets me know if the Server load has increased gradually over time.

I have created GitHub repository ‘SqlServer-Baselining-Grafana’ that contains all the scripts that will help anyone to set up the baseline on individual SQL Server instances, and then visualize the collected data using Grafana through one Inventory server with Linked Server for individual SQL Server instances.

The github repo markdown page has all the details of how it would look like, and steps of how to do on your own.

To get the realtime experience of the final result of the baseline of my SQL Server environment, below are the details:-

Database/Grafana PortalUser NamePassword
http://ajaydwivedi.ddns.net:3000/guestajaydwivedi-guest
Sql Instance -> ajaydwivedi.ddns.net:1433grafanagrafana

I hope this will be useful. Please do like and share if you liked the post.

Happing Coding 🙂

3 Comments

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.