BPCUK 2011: Best Practices – IT Pro

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

Leave a Comment