|
Introduction |
|
User Guide |
|
Alert functions |
|
Mathematical functions |
|
String formatting functions |
|
Properties |
|
Properties |
|
Properties |
|
Properties |
|
Properties |
|
Properties |
|
|
Report template
SQL
Size ships with a default template for the reports, and is
formatted as follows:
You
can create a new template based off this default template, and use
your customized template for the reports.
The
report elements are represented by tags e.g. [INSTANCE],
[DATABASE], [DBFILES] etc. They must be displayed in a hierarchical
order as follows:
|
The
following tags are available at the instance level:
|
|
[INSTANCE]
|
The
instance name.
|
[INSTANCEDBCOUNT]
|
The
number of databases for this instance.
|
[INSTANCETOTALDBSIZE]
|
The
size of all databases for this instance.
|
[TIMESTAMPSTART]
|
The
earliest date size data is available for this instance, based on
the date range you chose to report on.
|
[TIMESTAMPEND]
|
The
latest date size data is available for this instance, based on the
date range you chose to report on.
|
|
|
[SEQUENCE]
|
The
sequence number of the database for the current
instance.
|
[DATABASE]
|
The
database name.
|
[DBSIZEELEMENTS]
|
Displays
a stacked bar chart made up of the data files, transaction log, and
filestream components.
|
[DBSIZEELEMENTSRELATIVE]
|
Displays
a stacked bar chart made up of the data files, transaction log, and
filestream components, relative to the largest database for the
current instance.
|
[DBSIZETREND]
|
Displays
the database growth trend.
|
[TOTALSIZE]
|
Displays
the database's size.
|
[DATASIZE]
|
Displays
the database's data files size.
|
[LOGSIZE]
|
Displays
the database's transaction log size.
|
[FILESTREAMSIZE]
|
Displays
the database's filestream size.
|
|
|
[DBFILES]
|
Displays
for each of the database's files, its logical file name.
|
[DBFILESPHYSICALNAME]
|
Displays
for each of the database's files, its physical file
name.
|
|
The [ADJUSTWIDTH] tag
This tag is used to indicate that SQL Size should adjust this
column's width to display all its contents.
|