MSSQLTips: Tip #48 – SQL Server Database Mail Health Check with Policy Based Management

Email alerting is an important feature that helps to automate a lot of Database Administration tasks. How can we be sure that Database Mail works properly? If there is email problem there is no another email that will notify us of an issue and it could be days before we realize that there is a problem.

In this tip we will provide a solution to check all of your servers for the different types of Database Mail issues. We are going to use Policy-Based Management (PBM) to perform these checks.

Please read the latest MSSQLTips post: “SQL Server Database Mail Health Check with Policy Based Management“.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.

MSSQL Tips: Tip #18 – Using Policy Based Management for SQL Server Availability Groups Data Loss Alerts

This tip is again on my favorite topic – Policy Based Management.

Please read the latest MSSQL Tip: “Using Policy Based Management for SQL Server Availability Groups Data Loss Alerts“.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.

MSSQL Tips: Tip #17 – Using Policy Based Management to check that SQL Server indexes are created in the correct filegroup

Another tip about using Policy Based Management for the SQL Server checks.

Please read the latest MSSQL Tip: “Using Policy Based Management to check that SQL Server indexes are created in the correct filegroup“.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.

MSSQL Tips: Tip #8 – Using Policy Based Management to check number of SQL Server data and log files

In this tip I explain how to make sure that you have only one database transaction log file and more than one data file using policy based management.

Please read this MSSQL Tip: “Using Policy Based Management for checking SQL Server database file extensions“.

Check out all of my tips here: http://www.mssqltips.com/sqlserverauthor/94/svetlana-golovko/.