How to Monitor a Database in Microsoft Azure

Find out how the Basic Monitoring via Web Console operates, and get an overview of deadlocks, failed connections, successful connections, and blocking by firewall. Review three categories of views: Database-Related, Execution-Related, and Transaction-Related.

Monitoring tools and techniques that you might be accustomed to using on an on-premises server, such as auditing logins, running traces, and using performance counters, are not available for SQL Database. On Azure, you use Data Management Views (DMVs) to monitor data capacity, query problems, and current connections.

How to Create Database in Microsoft SQL Azure

Microsoft Azure SQL Database is a relational database-as-a-service that delivers predictable performance, scalability, business continuity, data protection, and near-zero administration to cloud developers and solution architects.

Microsoft Azure offers several choices for data storage. These include Azure storage and SQL Azure. You may choose to use one or both in your particular project. Azure storage currently contains three types of storage structures: tables, queues and blobs.

Batching Techniques for SQL Database Applications in Azure

Batching operations can be very helpful in improving your performance and scalability for your in house application as well as cloud applications.

Here are some of the batching techniques available for you to consider:


Client side code based transactions can be simple and useful. Here is an example: