SQL Server Installation Recommendations:
1. SYSTEM DATABASES TO BE ON THE SAME OS DRIVE.
REASON:
A. RESOURCE DATABASE NEEDS TO COMMUNICATE WITH SERVICE.
B. SERVICES TO BE CONFIGURED ON OS DRIVE ONLY.
2. DEDICATED DRIVE FOR USER DATABASE DATA FILES
3. DEDIATED DRIVE FOR USER DATABASE LOG FILES
4. DEDICATED DRIVE FOR BACKUP FILES
5. DEDIXATED DRIVE FOR TEMPDB
6. NUMBER OF TEMPDB DATA FILES = NUMBER OF PROCESSOR NODES. THIS IS TAKEN BY DEFAULT
SERVICE ACCOUNTS:
1. DATABASE ENGINE – FOR DATABASE HOSTING, MANAGEMENT, HA & DR, TROUBLESHOOTING OPERATIONS.
2. SQL SERVER AGENT – FOR ROUTINE & AUTOMATED OPERATIONS CALLED “JOBS”. ALSO FOR ALERTS, EMAILS
3. SQL BROWSER – FOR REMOTE DATA ACCESS TO OUR SQL SERVER INSTANCE
4. SQL SERVER INTEGRATION SERVICES – FOR DATABASE MIGRATIONS, MULTI DATABASE BACKUPS AND MSBI FOR DWH DESIGN