Actually i m new in sql server administration. And i m in the process of building our production box with sql server 2005. ( win 2003 std )
Can anybody plz tell me , what all the "Alerts" and their 'Thresholds' i have to configure on my server, so that those can be emailed (or) paged.
And does anybody know like any link, which gives step by step instruction for configuring Database mail with explanations.
Thanks in advance.
//Najeed
Hi,
that highly depends on what other monitoring software you are using and which areas this already covers. But I would go for disk usage and datafile / logfile growth and size. If you experiencing other problems, you might also want to trace / log other parameters, but this depends upon your requirements. Database mail is explained in detail at the MSDN sites:
http://msdn2.microsoft.com/en-us/library/ms186358(SQL.90).aspx
Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment