Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
 Posted - 2012-05-14 : 14:48:45
|
| I would like have scripts to create a weekly report to email me the 'Health Status' of the server.Free disk spaceJob failures,missing indexes report,any errors in SQL Server Error log or Event Log,overall performancespace available on the databaseSecurity AuditDatabase consistency check |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2012-05-15 : 01:58:31
|
| 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 schedulerI'd recommend you run the Error Logs report dailyJack Vamvas--------------------http://www.sqlserver-dba.com |
 |
|
|
sqlfresher2k7
Aged Yak Warrior
623 Posts |
Posted - 2012-05-18 : 11:23:30
|
| Thansk Jack..I found few but most of them are not workable.I have only one server with multiple databases.Please let me know if you have or find any workable scripts. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
Weekly Health check report