Schedule Demo
 
 

Microsoft Azure SQL Database Monitoring

Microsoft Azure SQL Database Monitoring

Microsoft Azure SQL Database is a scalable, relational database-as-a-service that provides managed SQL database capabilities to applications running in the Azure cloud. Applications Manager provides monitoring of Azure SQL database performance by tracking key performance indicators and query statistics while notifying users of events and outages occurring in their system.

Let's take a look at what you need to see for Microsoft Azure SQL database administration from a high availability viewpoint, the performance metrics to gather and how you can ensure that your Azure SQL database is operating as expected:

Plan Capacity And Resource Utilization

Track key performance indicators such as DTU usage and R/W utilization to help you determine whether your database has excess capacity or has resources are maxed out. Gather info about resource consumption (CPU, storage, I/O, etc.), and track the general efficiency of your database. Get alerted before maximum capacity is reached.

Microsoft Azure SQL Database DTU Usage

Find Blocking Queries, Troubleshoot Deadlocks

Lock waits indicate data contention by queries; page IO latch waits indicate slow IO response times; page latch update waits indicate incorrect file layout. Get details about wait times during query execution, historical long running and blocked queries, plus metrics to aid in troubleshooting, such as the count of deadlocks. Receive alerts when SQL deadlocks occur and identify failed processes.

Microsoft Azure SQL Database Performance

Monitor Active Sessions And Failed Connections

Drill down into each aspect of the resource metrics and more - CPU, reads, writes, number of sessions and client connections, to evaluate how well your workload fits the performance level. Track any data retrieved from the database via custom SQL queries. Visualize how specific activities might impact others and jump to run-time performance graphs, which show specific query performance trends and activity details.Microsoft Azure SQL Database Connections

Detect real-time performance issues and fix them faster

Distinguish consistent performance patterns from anomalies, which is critical to ensuring your data platform delivers optimal performance for the end users of your applications. Get instant notifications of performance issues and bottlenecks. Take quick remedial action before your end-users experience issues.

With Applications Manager, you gain system-wide visibility into resource utilization, application performance, and operational health of your Microsoft Azure SQL Database and application performance. Quickly get started Microsoft Azure SQL Database Monitoring with Applications Manager’s full-fledged, 30-day free trial edition.