I am searching for Database Health check articles specifically for a web application back-end server and SQL Server 2005/2008.
My current checklist includes:
- Index Fragmentation
- SQL Server logs
- Mirroring Monitor
- Backup completion
- File growth
What else should I look for? Are there good articles specifically for a webapp DBA scenario?
(Note: I don't need to worry about many database users - there is only one user the application itself)