CloudMonix utilizes Dynamic Management Views to query diagnostic data from SQL Azure databases.  It will connect to master database for certain metrics and to the monitored database for other metrics


To authorize query permissions against Dynamic Management Views utilize this script


  

-- in master database

CREATE LOGIN CloudMonixClient WITH PASSWORD = 'your_password_here' 
CREATE USER CloudMonixClient FROM LOGIN CloudMonixClient;

--per each database to be monitored

CREATE USER CloudMonixClient FROM LOGIN CloudMonixClient;
GRANT VIEW DATABASE STATE TO CloudMonixClient;

  


Note: In order for CloudMonix to be able to auto-scale SQL Azure databases, the username provided must be a part of the dbmanager role and have permissions to execute ALTER DATABASE command