janihur/azure-sql-database-monitoring-dashboard

Azure SQL Database Monitoring Dashboard

Azure SQL Database Monitoring Dashboard

Build on top of Dashing.

Configuration

TODO: set up database user for monitoring.

Database connection is configured in file src/dbconfig.yml:

FreeTDS may have issues with passwords longer than 30 characters!

---
host: '<SERVERNAME>.database.windows.net'
username: '<USERNAME>@<SERVERNAME>'
password: '<PASSWORD>'
database: '<DATABASENAME>'

Development Environment

Uses Vagrant - Vagrantfile included:

# first time provision only
$ vagrant up
$ vagrant halt
# normal startup
$ vagrant up
$ vagrant ssh
vagrant@azure-sql-dashboard:~$ cd /vagrant/src
# create dbconfig.yml
vagrant@azure-sql-dashboard:/vagrant/src$ vi dbconfig.yml
vagrant@azure-sql-dashboard:/vagrant/src$ bundle && dashing start

Further Reading

• Database Journal: Monitoring Azure SQL Database by Marcin Policht (6th Nov 2014)
• MSDN: Azure SQL Database sys.resource_stats

License

The MIT License. See LICENSE.