Azure SQL Database Integration
DTU usage, query performance insights, and geo-replication lag tracking for Azure SQL Database. Identify expensive queries and replication failures before they degrade your application.
How It Works
Grant Monitoring Reader Access
Assign the Monitoring Reader role to the TigerOps Service Principal on your SQL Server resource group. No SQL login is needed — all metrics are pulled from Azure Monitor.
Enable Diagnostic Settings
Turn on Diagnostic Settings for each database to stream SQLInsights, QueryStoreRuntimeStatistics, and Errors categories to a Log Analytics workspace.
Configure Query Store
Ensure Query Store is enabled on your databases (it is on by default for Azure SQL). TigerOps reads top expensive queries, wait statistics, and execution plan changes from the QueryStoreRuntimeStatistics log.
Set DTU and Replica Alerts
Define DTU or vCore consumption thresholds and geo-replication lag SLOs. TigerOps alerts before you hit resource limits and predicts when you need to scale up the service tier.
What You Get Out of the Box
DTU & vCore Utilization
Real-time and historical DTU percentage, CPU percentage, log IO percentage, and data IO percentage. TigerOps alerts when resource consumption approaches tier limits before throttling occurs.
Query Performance Insights
Top queries by CPU time, logical reads, and execution count pulled from Query Store. Track query performance regressions across deployments and identify queries causing DTU spikes.
Geo-Replication Lag
Replication latency between primary and all secondary replicas, failover readiness status, and last failover timestamp. Alert when replication lag exceeds your RPO requirements.
Deadlock & Blocking Detection
Deadlock event counts, blocked query duration, and lock wait statistics from SQL Insights diagnostic logs. Identify lock contention patterns before they impact application throughput.
Storage & Tempdb Usage
Database size growth rate, tempdb usage, and log file size trends. TigerOps forecasts when you will exhaust storage tier limits based on current growth velocity.
AI Query Regression Alerts
TigerOps AI compares query execution plan statistics before and after deployments and flags queries that regressed in CPU time or IO reads, helping pinpoint schema change impacts.
Enable SQL Database Diagnostics
Stream Query Store and performance metrics to Log Analytics for full SQL visibility in TigerOps.
#!/bin/bash
# TigerOps — Azure SQL Database Diagnostic Settings
SQL_SERVER="my-sql-server"
DATABASE="my-database"
RESOURCE_GROUP="my-resource-group"
WORKSPACE_ID="/subscriptions/${SUBSCRIPTION_ID}/resourceGroups/${RESOURCE_GROUP}/providers/Microsoft.OperationalInsights/workspaces/tigerops-workspace"
DB_RESOURCE="/subscriptions/${SUBSCRIPTION_ID}/resourceGroups/${RESOURCE_GROUP}/providers/Microsoft.Sql/servers/${SQL_SERVER}/databases/${DATABASE}"
# Enable all SQL diagnostic categories
az monitor diagnostic-settings create \
--name tigerops-sql-diagnostics \
--resource "${DB_RESOURCE}" \
--workspace "${WORKSPACE_ID}" \
--metrics '[{"category":"Basic","enabled":true},{"category":"InstanceAndAppAdvanced","enabled":true}]' \
--logs '[
{"category":"SQLInsights", "enabled":true},
{"category":"QueryStoreRuntimeStatistics", "enabled":true},
{"category":"QueryStoreWaitStatistics", "enabled":true},
{"category":"Errors", "enabled":true},
{"category":"DatabaseWaitStatistics", "enabled":true},
{"category":"Deadlocks", "enabled":true}
]'
echo "Diagnostics enabled for ${DATABASE} on ${SQL_SERVER}"
echo "Query Store data will appear in TigerOps within 5 minutes"Common Questions
Does TigerOps support Elastic Pools?
Yes. TigerOps monitors both individual Azure SQL Databases and Elastic Pools. Pool-level eDTU and storage metrics are tracked alongside per-database metrics, so you can see which databases are consuming the most pool resources.
How does TigerOps collect Query Store data?
TigerOps reads the QueryStoreRuntimeStatistics and QueryStoreWaitStatistics diagnostic log categories streamed to Log Analytics. No direct SQL connection is required — all data flows through the Azure Monitor pipeline.
Can TigerOps detect when geo-replication is lagging behind my RPO?
Yes. You can configure a geo-replication lag threshold in TigerOps that maps to your Recovery Point Objective. When the replica lag exceeds the threshold, TigerOps fires an alert with the current lag value and trend.
Does TigerOps support Azure SQL Managed Instance?
Yes. Azure SQL Managed Instance exposes the same Azure Monitor metric categories as SQL Database. TigerOps supports both deployment options with the same setup process.
How are SQL Database alerts correlated with application performance?
TigerOps links SQL DTU spike events and slow query alerts to application traces collected from the services querying the database, giving you full context from the user request down to the SQL execution plan.
Full Visibility Into Your Azure SQL Workloads
DTU tracking, query performance insights, and geo-replication lag monitoring. Connect in 5 minutes.