SQL 2008 R2 Configuration Help
Posted on 2012-09-19
We’re hoping you can give us some insight to some general SQL configuration questions we have before we begin our SQL installation. We’ve looked for answer to these questions but couldn’t find much solid information, or we couldn’t understand certain aspects of SQL in the articles we did find. Hopefully, you can help us in completing our task. Thank you, in advance, for any help you could give us.
We’re building a new SQL Server:
1. Windows Server 2008 R2 SP1
2. SQL Server 2008 R2 SP2
The server storage consists of eight (8) 15k SAS Hard Drives split into 3 RAIDs:
1. Volume #1 for the OS - 600GB in a RAID 1 (2 Drives)
2. Volume #2 for SQL Databases – 1200GB in a RAID 10 (4 Drives)
3. Volume #3 for SQL Logs – 600GB in a RAID 1 (2 Drives)
There are five (5) databases, roughly:
1. Database #1: 300GB
2. Database #2: 25GB
3. Database #3: 25GB
4. Database #4: 5GB
5. Database #5: 500MB
These five databases are used in one (1) of our Enterprise Applications (a Document Management Solution) and consist mainly of PDFs, Word Documents, and Excel Documents. Our Software vendor has not been able to provide much support or Best Practice for setting up the SQL Server for this application.
Your help and advice is appreciated for the following questions (Please keep in mind we are not SQL experts or DBAs of any sort):
1. Is it better to install SQL on the System Drive (Volume #1), the databases on the Data Drive (Volume #2), and the SQL Logs on their own drive (Volume #3)?
2. Is there even a separation of SQL Server and the databases to do this or should SQL and the databases should all be on the SQL Data Drive (Volume #2) and the logs on their own drive (Volume #3)?
3. On Volume #3 where we want to put the SQL Logs, can this also be used as the storage area for Shadow Copies? Or is this bad practice?
4. Is it general practice to install an application on the same drive as the databases, or normally would this be done on a separate volume as well?
Thank you for your time and help.