How to Baseline Microsoft SQL Server with Open Source Tools
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 Portal | User Name | Password |
| https://sqlmonitor.ajaydwivedi.com:3000/ | guest | ajaydwivedi-guest |
| Sql Instance -> sqlmonitor.ajaydwivedi.com:1433 | grafana | grafana |
I hope this will be useful. Please do like and share if you liked the post.
Happing Coding 🙂
Related Posts
About The Author
Ajay Dwivedi
I am Microsoft Certified Professional having 10+ years of experience in SQL Server Querying, Database Design, and Administration. I am fond of Query Tuning and like to automate things using TSQL & PowerShell. I also have experience of implementing end-to-end Data Warehouse solution, and Data Migration using ETL tools SQL Server Integration Services (SSIS), Pentaho Business Analytics, and have designed Database Inventory through PowerShell, Python, and Django etc.
Leave a Reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
i am having issues with the below section
Push Perform data collector data to SqlServer using relog & dsn.
NonSql-Files/perfmon-collector-push-to-sqlserver.ps1
Hi Pardha,
kindly create an issue on https://github.com/imajaydwivedi/SqlServer-Baselining-Grafana/issues. Please put all screenshot, and errors.
Thanks,
Ajay