SQL Database Metrics
QuickStart
To monitor Database's system metrics like CPU Percentage, Memory Percentage, Storage Usage with SigNoz, you just need to set up the OpenTelemetry Collector with the Azure Monitor exporter and enable Monitoring for the databases.
Overview
In this document, you will learn how to monitor Database's system metrics like CPU Percentage, Memory Percentage, Data In, and Data Out with SigNoz. By monitoring these metrics, you can keep track of your application's resource utilization and performance.
For application-level traces and metrics, you can use the DNS name of the OpenTelemetry Collector you set up earlier. Simply configure your application to send traces and metrics to the Central Collector, and they will be forwarded to SigNoz automatically.
Prerequisites
Before you can monitor your Database with SigNoz, you need to ensure the following prerequisites are met:
- An Azure subscription and an Database instance running
- Central Collector Setup
- SQL monitoring profile created to monitor the databases in Azure Monitor
Setup
Once you have completed the prerequisites, you can start monitoring your Database's system metrics with SigNoz. Here's how you can do it:
- Log in to your SigNoz account.
- Navigate to the Dashboards, and add an dashboard
- Add a Timeseries Panel
- In Metrics, select
azure_storage_maximumand Avg By select taglocation - In Filter say
name = <database-name> - Hit “Save Changes” You now have Memory Usage of your Database in a Dashboard for reporting and alerting
Signoz Dashboard
That's it! You have successfully set up monitoring for your Database's system metrics with SigNoz.
Make sure you have created a sql monitoring profile in Azure Monitor if not, Follow this guide to Create SQL Monitoring Profile. You can monitor multiple databases in a single profile.
Troubleshooting
If you encounter any issues while setting up monitoring for your Database's system metrics with SigNoz, here are a few troubleshooting steps you can try:
- Check if the OpenTelemetry Collector is running and properly configured with the Azure Monitor exporter.
- Verify that your Database instance is running and accessible.
- Ensure that you have the necessary permissions to access the metrics in your Azure subscription.
- Double-check the configuration of the OpenTelemetry Collector with the Azure Monitor exporter to ensure that a resource group filter is not preventing the metrics from being collected.
By following this document, you should be able to easily monitor your Database's system metrics with SigNoz and gain valuable insights into your application's performance and resource utilization.
