SQL Server Maintenance
- for improving performance, use defragmentation. Health Analyzer can tell you when it’s necessary
- never shrink, only if you know for sure that the DB never ever ever grows again
- (officially) run checkDD once a week (no one does it)
- if SQL is on the same machine as SP, limit the memory usage of SQL, otherwise it will use it all
- if you have a backup plan with full and incremental backups, be careful with ad-hoc backups.
Service Applications
- consider scaling, e.g. a separate server for Excel Services, Search Services, etc
- when manually configured, be sure that all (windows) services are actually started up
Application Pools
- ever application pool uses an own worker process, and as such own memory. Thus the more application pools, the more memory consumed
Posted by Kate 
