SQL Server Install Guide Part 3
I’m in part 3 of a series on installing SQL Server. In the previous post I began discussing steps to take after the install is complete. Because there are quite a number of things to consider post-install, this part 3 will continue discussing the post-install configuration items.
Configure SQL Server Alerts
One of the things I always do after installing SQL Server is set up SQL Server Alerts. This is a free, easy way to find out about problems on the SQL instance, like read retry errors or other potential nasty issues. There are probably a number of places to find scripts useful for this task. The one I recommend is from Glenn Berry at SQLSkills.com. You can find his script at this link. One of my favorite things about Glenn’s script is that it has very well defined alert names that allow the DBA to easily know what server is involved when an alert is sent.