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 SQL Size GUI

The SQL Size GUI is used to display the size data collected by the SQL Size Agent service.


Licensing

The SQL Size GUI does not require a license. You can install it on as many computers as you want.


Installation


You install the SQL Size GUI by running the SQL Size installer (which you can download from http://www.yohz.com), and then selecting the Full installation option,

install_component  

or the Compact installation option.

install_minimal  


Usage

When you start the SQL Size GUI, you will need to connect to a SQL Size database to retrieve the data from. Choose the SQL Server Compact option if you were using a SQL Server Compact Edition database to store the size data, and enter the name of the database file.

sqlgui_connect_ce  

If you are using a SQL Server database to store the size data, select the SQL Server option, and enter the connection details to connect to that database.

sqlgui_connect_sql  

Once connected to a SQL Size database, you can analyse the growth patterns of your databases:

· the Overview page displays a summary of the growth trend of each instance's databases  
 
· for each database, you can drill down to analyse the growth trend of the database's components, and also the largest tables