I agree with Phill Carter, as the SQL Mail maintenace is very time consuming. Some times is hangs and we need to restart the SQL Server Agent. Some times restarting...

check the authenication mode, is it windows only or mixed.

if it is windows only then change it to mixed mode.

thanks

removing the foreign keys constraint from the database help in some performance boost as while storing the data to the tables SQL engine does not need to check integrity of...