Good articles for SQL Server Health Check specifically for Web Applications
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.