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

Alerts

You can use alerts to monitor your databases' growth and send your users an email on the occurrence of certain events that you define. Alerts are also displayed on the SQL Size GUI Alerts page.

To raise alerts, you need to define the conditions using scripts. SQL Size is shipped with over 10 script templates that you can use to modify to suit your needs. To learn more about scripting, see the Scripting section.

alerts_11  

On the left side, the list of monitored instances are displayed.

alerts_12  

When you select an instance, the alert scripts that will run for that instance are selected. In the screenshot below, this means that SQL Size will run all the selected scripts every time it collects size data from the for the YOHZ_PROD_SS05E\DEV2005 instance instance.

alerts_13  

On the right panel, the instances that run the currently selected script are displayed. In the screenshot below, this means that the 'raise alert if any paths have < 2 GB of free space' script is ran for the YOHZ_PROD_SS05E\DEV2005, YOHZ_PROD_SS05E\DEV2012, and YOHZ_PROD_SS05E\SQL2008 instances.

alerts_14