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:
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.
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.
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.
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.