SelectStar

Microsoft SQL Azure

Connection Information

The following information is required by SelectStar in order to monitor to your Microsoft SQL Azure databases:

Field
API Field
Description

Host

host

Hostname or IP address of the system on which your database is running

Port

port

Port on which your database is listening [default: 1433]

Database

database_list

Comma-separated list of databases to monitor. Leave this field blank to monitor the entire instance

Credentials

Field
API Field
Description

Username

username

SQL Azure user

Password

password

User's password

Use Active Directory

use_active_directory

Whether or not to use Active Directory Authentication

Access Rights

To set up the minimum user permissions needed for monitoring with SelectStar, grant your Microsoft SQL Azure login credentials the VIEW DEFINITION and VIEW DATABASE STATE permissions for each user database.

Note

Some metrics are only available for users of Azure's Premium tier, or administrators of Azure's Standard and Basic tiers.