Telegraf Plugins used:
- 1 Telegraf Configuration:
- 1 Dashboards:
- 1 Label:
- 1 Bucket:
- 1 Variable:
If you have your InfluxDB credentials configured in the CLI, you can install this template with:
Microsoft SQL Server is a popular Relational Database (RDBS) that is used for storing and retrieving data as requested by mission-critical applications. Because it is such an important component of your application, having full insight into how your database is used can help you set up a baseline when analyzing performance. Poor-performing databases could cause serious customer experience issues that will lead to customer dissatisfaction and ultimately to customer abandonment.
When troubleshooting performance issues, baselines help to distinguish between abnormal and routine patterns of behaviors, link cause and effect, and even help make predictions to anticipate potential problems.
Why Microsoft SQL Server monitoring
Microsoft SQL Server is used to store and query data, and it comes with a set of optimization configurations to enhance performance. Users can configure resource use, cache queries, store tables in memory rather than on disk, and control the distribution of CPU, memory, and storage by configuring resource pools. Proactive monitoring of how effective these configurations are in your instance will help you establish its health.
Microsoft SQL Server Monitoring Dashboard
How to use the Microsoft SQL Server Monitoring Template
Once your InfluxDB credentials have been properly configured in the CLI, you can install the Microsoft SQL Server monitoring template using the Quick Install command. Once installed, the data for the dashboard will be populated by the included Telegraf configuration, which includes the relevant MS SQL Server metrics input. Note that you might need to customize the input configuration to better serve your needs if you are running an Azure managed instance. All of this will depend on how your organization is currently running.
To find out more information about environmental variables within the Telegraf configuration, consult the following link.
Key Microsoft SQL Server monitoring metrics to collect
Some of the most important Microsoft SQL Server monitoring metrics that you should proactively monitor include:
- Current Queries
- Active Threads
- CPU Usage/Idle