Home
SQL Size online help Prev Page Prev Page
Introduction
About SQL Size
Version history
Contact us
User Guide
Architecture
Licensing
Installation
System requirements
Reference Guide
The SQL Size Agent service
The SQL Size Configuration application
SQL Server instances
Data collection schedule
Reports and emails
Report template
Data storage
Alerts
Script editor
Useful shortcuts
Activating your license
The SQL Size database
The SQL Size GUI
The Overview page
Export overview
Database analysis
Alerts history
Error history
Scripting
Data types
Script structure
Language basics
Debugging
Global variables
Functions
Alert functions
RaiseAlert
RaiseConditionalAlert
AddAlertDetails
Mathematical functions
Power
String formatting functions
FormatBytes
FormatFloat
Support functions
String functions
Date and time functions
Date-Time format strings
Class reference
TBaseClass
Properties
AverageDailyGrowth
Name
ObjectType
Size
SizeDesc
Tag
TInstance
Properties
Database
DatabaseByName
DatabaseCount
DatabaseDataSize
DatabaseExists
DatabaseFilestreamSize
DatabaseLogSize
DatabaseSize
PathCount
Path
TDatabase
Properties
DataSize
DBFile
DBFileCount
Filegroup
FilegroupCount
FilestreamSize
LogSize
TFilegroup
Properties
DBFile
DBFileCount
FilegroupType
TDBFile
Properties
Filegroup
FileType
Growth
IsPercentGrowth
MaxSize
Path
PhysicalName
TPath
Properties
FreeSpace
Enumerations
TFileType
TFilegroupType
TObjectType
Records
TGrowthStats
Constants

The Overview page

The Overview page displays a summary of the growth trend of each instance's databases.

sqlgui_overview  

The number of databases and the total size for each instance is displayed, together with the date range for the displayed data.

sqlgui_header  

Note that the number of databases does not represent the actual number of databases for that instance, as SQL Size collects size data only for the databases you specify. This is set up using the SQL Size Configuration application, on the Databases page.

For each database, you can compare the relative size of the various components (data files, transaction logs, and filestream data). The growth trend of the database is also displayed in a small chart.

sqlgui_components_2  

Expanding the database node will reveal details of the individual components of the database.

sqlgui_dbdetails  


To analyse the database in detail, double click on the database name, or any one of it's components. You can also analyse the database in detail by selecting the Analyse database item from the database's context menu.

sqlgui_contextmenu  

To change the analysis period, change the starting data and end date of the period on the toolbar, and click on the Refresh data refresh button.

sqlgui_daterange_02  

You can also export the currently displayed data to an Excel spreadsheet by clicking on the Export overview to Excel spreadsheet button file_excel_normal on the toolbar.

To filter the databases that are displayed, enter part or all of the database name in the area next to the Filter item on the toolbar.

sqlgui_filter_02