Drilldown on the SQL Azure database, tables, and indexes.
To see the Databases drilldown
Click Monitor | Databases.
To investigate... | Look at the... | |
---|---|---|
Database space usage | Summary page |
Shows the disk space usage for databases, displayed in megabytes or as a percentage. To switch between statistics, click the arrow next to the chart name. Data components are broken down into space used by:
The maximum database size is determined by the edition of the SQL Azure database. |
Tables, table space, and table growth | Tables page |
Shows all tables in the SQL Azure database, including their size, number of rows, and free space. You can filter the results displayed in the Tables grid by the following criteria:
To filter the results, type appropriate values into the fields above the Tables grid (wildcards are supported) and then click Apply Filter. Shows the amount of space used by each table, displayed in megabytes or as the number of rows. To switch between megabytes and rows, click the arrow next to the chart name. Shows the amounts by which each table is growing over time, displayed in megabytes or as the number of rows. To switch between megabytes and rows, click the arrow next to the chart name. |
Index distribution statistics | Indexes page |
Shows the index statistics for all indexes in the SQL Azure database. When you first display the Indexes page, by default the top 50 indexes by size are displayed in the grid. You can filter the results displayed in the Indexes grid by the following criteria:
To filter the results, type appropriate values into the fields above the Indexes grid (wildcards are supported) and then click Apply Filter |
When in Playback, history will not be displayed for SQL Azure database information. For more information, see Playback.
|
TIP: For more information on Spotlight charts and grids see Spotlight charts and Spotlight grids |
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy