Tuesday, 26 May 2015

Microsoft Azure SQL Database – Dashboard

By David Postlethwaite

Once you have created your database you can now start to manage and configure it.

There are six menus for a SQL Azure Database: -

  • Dashboard
  • Monitor
  • Scale
  • Configure
  • GEO-Replication
  • Auditing and Security
The Dashboard

Microsoft Azure SQL Database - Dashboard

The Dashboard gives an overview of the state of your Azure database. The most useful section is down the right hand side under “Quick Glance” where you can find your connections strings, manage the IP security, server name, status, collation and edition.


Microsoft Azure SQL Databases – Monitoring


The Database monitor screen allows us to see the performance of your database. There are various indicators that you can manage. By default there are four metrics:- deadlocks, failed and successful connections and storage size but  we can add more metrics from the Add Metrics button on  the grey bar at the bottom.

Microsoft Azure SQL Database Metrics

We can also add alerts to warn us when these metrics go over a certain threshold


No comments:

Post a Comment

Featured post

OUT OF SUPPORT: SQL Server 2008 and SQL Server 2008 R2

Welcome to this post, on SQL Server 2008 and 2008 R2, both of these versions of SQL server will go out of  extended support with Microsoft t...