SQL Health Check

Here are some of the checks that help determine how a SQL server database is performing.

1. CPU Optimization
2. Indexing usage
3. Waitstats
4. Buffer Cache
5. Fragmentation
6. SQL server Database security
7. Review Log Files
8. Backups
9. Space utilization and trends
10. Transactions performance, issues, locking, etc
11. SQL TEXT
12. I/O performance
13. Database Integrity check