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