below is the doc that has step by step instruction to
1) configure db mail in MSSQL. please check the doc attached in below link
try t-sql to configure DB mail in this link – t-sql_DB_Mail_creation
or refer below links for better understanding.
2) configure the db blocing alerts. please refer the below link. superb article,great work!! thanks to the author!!
3) test the alerts.
Testing the blocking alerts
— step 1 : create a sample database and table in DBA Monitor
Use master Go Create database sample_db go use sample_db go create table test_sample_table (emp_id int ,emp_name varchar(30)) -- step 2 : insert data into table, execute ‘commit transaction’ after blocking threshold time i.e if blocking is set tp 30 secs,60 secs(1min),900 sec(15 mins) then execute the commit command as given below use sample_db go begin TRANSACTION go insert into test_sample_table (emp_id,emp_name) values (1,'aaa'),(2,'bbb'),(3,'ccc') go -- commit TRANSACTION -- step 3 : open new query window & execute below query to check the total records in sample table use sample_db go select * from test_sample_table
if all the above steps are done correctly then you will get a mail.