Good articles for SQL Server Health Check specifically for Web Applications 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)
The two I've found most useful:


Brent Ozar's Blitz! Script
Glenn Berry's DMV Diagnostic queries


Posting these as an answer since you haven't received any other responses. Also, not sure how long this question will live; it may be viewed by some as a shopping list request that will eventually be obsolete.