Performing SQL Server 2000 Operations
The SQL Server Management Pack will generate reports that display data over time
and will present patterns that indicate possible problems. Even though many of the
important problems that may exist in your database will not cause an alert, they will
still need your attention from time to time. Going over the information provided in
the reports allows you to take a proactive rather than a reactive stance by resolving
this type of issue before it can generate an alert.
BEST PRACTICES ACCORDING TO MICROSOFT
■
Review and prioritize all your alerts on a daily basis.
■
Perform other tasks on a regular basis, depending on ...