Open the database growth report
Sign in to Spotlight Cloud at https://app.spotlightcloud.io and click the Reports tab.
Select the Database Growth Report.
The Reports tab is only available for Spotlight Cloud Professional and Trial Professional subscription holders. The Reports tab will not be visible to you if you have a Spotlight Cloud Basic subscription.
Dates and times
In the report, the Data collected at time indicates the most recent time in the report period that data was collected. This report has no information after this date and time. All times are in UTC time.
The Diagnostic Server(S), connection(s) and period
Select the Diagnostic Server(s), connections and period to cover in the report from the drop down menus at the top of the chart. By default the report covers all Spotlight Cloud Diagnostic Servers and all connections monitored through all Spotlight Cloud Diagnostic Servers, over the last month. All reported times and selectable times are in UTC time.
Click on the charts to further filter the report display. For example, click on Fastest Growing to filter the report to show only the databases that have grown in size by more than 30% over the selected period. Click on a database horizontal bar on the Database Size (MB) chart to filter the report to show only that database. Use the CTRL key to filter on multiple selected items. To remove the filter on a selected item, click again on the item or click anywhere on the report away from selectable items.
Data collection
Data values are either point in time or aggregated.
The most recent data collection time in the selected report period is marked under the database growth report heading. Data collected at this time is used for point in time tables and charts. The data values in the Database Size chart for example come from this collection time.
Aggregated data values are aggregated over the selected report period. For example, the fastest growing databases value is calculated by aggregating data values over the selected report period.
Data is collected daily.
Summary data
Space
Shows the amount of space used and available on the selected connections at the data collection time marked under the database growth report title. Shows also the proportion of allocated space used at this time.
Total databases
Shows the number of databases on the selected connections at the data collection time marked under the database growth report title.
Risk to 100% full in 30 days
Shows the number of databases running the risk of being 100% full in the next 30 days. The calculation is based on the average growth rate of the database during the report period multiplied out to the next 30 days.
Fastest growing
Shows the number of databases whose size grew by more than 30% during the report period. Consider increasing the space allocated to the database or investigate the reason for the growth.
Most underutilized
Shows the number of databases that used less than 60% of their total allocated size during the report period. These databases can be potentially shrunk.
Deleted
Shows the number of databases that ran on the connections in this report and were deleted during the report period.
Database size (MB)
Shows the data and log space, both allocated and used, for each database. The data collection time is marked under the database growth report title.
Space used over time (MB)
Shows how the amount of space used and the amount of space free has varied over time.
Hover your mouse over the chart to see the actual cartesian values.
The period of time covered by the chart can be adjusted by selecting a different report period.
Files
Lists all database files at the data collection time marked under the database growth report title on the selected SQL Server connections. Files are initially sorted in descending order of utilization. Click on a column title to change the sort order.
| Column | Description |
|---|---|
| File Name | The name of the file |
| DB Name | The file is stored in this database. |
| Connection | The file is in a database on this Spotlight connection (SQL Server instance). |
| Type | The type of file (Data or Log) |
| Disk | The location of the file. |
| Mount Point | The mount point location of the file. |
| Total Size (MB) | The size of the file |
| Utilization (%) | The proportion of space allocated to the file that is actually used by the file. |
| Time to full (Days) | The estimated number of days till the file fills its allocated size. |
| Avg Growth Rate (MB/day) | The rate of file growth measured by the number of megabytes per day. |
| Auto Grow | Ticked for files that are set to auto grow. |
| Max Size (MB) | The maximum size the file can grow to (for files that are set to auto grow). |