SQL Diagnostic Manager provides a graphical analysis of the used, unused, and index disk space of the database. You can also view the size and structure of database tables, this screen provides a list of data size, text or image size, index page size, and the number of table rows, making reorganization and index creation decisions easy.
Summary
The Database Summary view allows you to view the status of all the databases on the selected Azure SQL server.
The following graphs are displayed at the bottom of the screen:
- Capacity Usage - Select how to view the data or the log is used on your database. The drop-down list allows you to choose to view the data or log in megabytes or percentages.
- Recent Trends - Select how to view how your database or group of databases are used currently by selecting either active sessions, transactions per second, data size, log size, or log flushes from the drop-down list.
Configuration
The Database Configuration view allows you to review the configuration settings of the databases on the selected Azure SQL instance. This view contains a single grid that includes the configuration settings for all databases on the selected SQL Server instance.