This is my note for how to setup the Database alert with SQL Server.
Create Database Mail profile
You will need to create the mail profiler before this.
Enable SQL Agent
It is very important to bounce the SQLAgent after we setup the mail profiler for the SQL Server.
If that is not being done, we will receive the error “ Database Mail is not enabled for agent notifications. ”
Create the new database <TestDB> with initial size 4MB.
Create the alert that will be trigger when the database grow over 100MB.
Database alert will check base on the performance counter. Then create the test table and insert some data to force the database grow.
You can see the performance counter has grow to 163008 and we receive the email for the same value as well.