Do you watch/review the informationa messages that are generated in SQL Server error log? Do you have a alert mechanism to capture informational/warning/error messages within your data platform? The first question itself catered as informational, I believe...
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
Mon, Jun 28 2010
Filed under: Filed under: sql server, perfmon, memory, system, cpu, performance monitoring, statiscs age, free space, dbcc freeproccache, procedure cache