I would like have scripts to create a weekly report to email me the 'Health Status' of the server.
Free disk space Job failures, missing indexes report, any errors in SQL Server Error log or Event Log, overall performance space available on the database Security Audit Database consistency check
There are plenty of scripts available on the Internet. Put some together and schedule. If you want information for multiple servers Powershell is very effective at iterating through multiple servers - logging on a and running the scripts - using a scheduler I'd recommend you run the Error Logs report daily
Weekly Health check report
Posted - 05/14/2012 : 14:48:45
