You can configure different roles to send you an email notification when their database
space is running low.
Before you begin
To make sure that the email notification is sent, configure the
SMTP and
Watchdog settings on the server
hosting the role.
What you should know
All role database notifications are configured from Config
Tool, except for the Directory database, which
must be configured from the Server
Admin - Main Server page. The
procedures are very similar in both cases. Therefore, only the configuration from Config
Tool is described here.
To receive a notification when a role’s database is almost full:
-
From the Config
Tool home page, open the
System task, and click the Roles view.
-
Select a role, and click the Resources tab.
-
Click Notifications ().
-
In the dialog box that opens, set the following options:
Disk space:
Sends a notification when the remaining free space on the disk falls below a
certain threshold (in GB).
Database usage:
Sends a notification when the space used by the role's database reaches a certain
percentage. This option is only for the Express edition of SQL Server, whose
database size is limited to 10 GB. If you are using a full edition of SQL Server,
this option has no effect.
-
Click OK.