patternsqlMinor
Good articles for SQL Server Health Check specifically for Web Applications
Viewed 0 times
sqlspecificallyapplicationsarticleshealthforwebgoodservercheck
Problem
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:
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)
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)
Solution
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.
-
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.
Context
StackExchange Database Administrators Q#21263, answer score: 4
Revisions (0)
No revisions yet.