Hi,
I'm setting up separate server for SQL 2008 x64 (first one is SBS2008).
Current disk configuration is three logical drives (C:, D:, E:) - each on separate RAID1 array. (Together 6 disks). OS is installed on C: partition.
I'm planing to use partition D: for database, partition e: for logs and partition c: for TempDB and sql backup directory. At the moment total size of DB and logs is 30GB and SQL server will be used by 20 users.
Am I on the right path or should I consider some other configuration and why?
For SQL services I plan to use system account...
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
i prefer untouching the c:\ drive in that way windows pages can grow as it like..
on tempdb performance read this http://msdn.microsoft.com/
**create one data file for each CPU on the server (accounting for any affinity mask settings) and then adjust the number of files up or down as necessary
that means all the sequential files in the same drive
Thanks for your answer.
You both prefer to leave c: partition only for OS.
But I have configured data locations like follows:
c: tempdb
d: data
e: logs + backup
I will monitor how big is performance impact on separate RAID arrays. I'm just a little bit sorry that I have not devided the first RAID1 array into two partitions...
Well, there is allways next time ;)
Business Accounts
Answer for Membership
by: CGLuttrellPosted on 2009-11-03 at 15:09:16ID: 25734916
I am leary of using c: for the sql backup directory, because depending on what your backup maintenance plan is and how long you may need to keep backups and the number of databases you may end up with, that could eventually take up all/too much space on the c: drive where the OS is and that causes the worst problems. I have seen this happen when not monitored properly.