Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
malraff
Starting Member
10 Posts |
 Posted - 2010-04-07 : 17:21:21
|
| hi alli will soon be moving our sql databases to a SAN. and would appreciate some advice on how ill divide the disks!we have approx 10 databases - 3-4 are intensively usedwhat i plan to do is divide the 12 * 360GB 15000rpm discs into 4 logical drivesC will be 2 discs in raid 1 - for windowsD will be 6 discs in raid 10 - for databasesE will be 2 discs in raid 1 - for logsF will be 2 discs in raid 1 - for tempdbcan anyone advise if my plan is ok? |
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-07 : 17:40:05
|
quote:
Originally posted by malraff
hi alli will soon be moving our sql databases to a SAN. and would appreciate some advice on how ill divide the disks!we have approx 10 databases - 3-4 are intensively usedwhat i plan to do is divide the 12 * 360GB 15000rpm discs into 4 logical drivesC will be 2 discs in raid 1 - for windowsD will be 6 discs in raid 10 - for databasesE will be 2 discs in raid 1 - for logsF will be 2 discs in raid 1 - for tempdbcan anyone advise if my plan is ok?
What's the total size of your databases? Will the backups be stored locally? How often do you backup the logs? How big are the log backups?There are 10 types of people in the world, those that understand binary, and those that don't. |
 |
|
|
malraff
Starting Member
10 Posts |
Posted - 2010-04-07 : 17:52:26
|
| hitotal space needed for databases currently would be approx 150gbno backups locally, i need to check with the guy that sorts all the backups - i dont think we actually back up the logs currently |
|
|
|
DBA in the making
Aged Yak Warrior
638 Posts |
Posted - 2010-04-07 : 18:07:06
|
quote:
Originally posted by malraffi dont think we actually back up the logs currently
That would be the first thing I'd sort out. General rule is, the more often you modify the data, the more often you need to backup the logs. If they're not backed up, then they just keep growing and growing. Every 15 minutes isn't uncommon for intensive databases. Aside from that, I can't see anything wrong with your disk layout.There are 10 types of people in the world, those that understand binary, and those that don't. |
|
|
|
malraff
Starting Member
10 Posts |
Posted - 2010-04-07 : 18:08:47
|
| thanks for input DBA! |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2010-04-07 : 22:48:29
|
| Are you planning on having the server setup to boot from SAN? I have seen most systems setup to boot from local disk.If you are planning on boot from SAN, you might want to read this: http://support.microsoft.com/kb/305547CODO ERGO SUM |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-04-08 : 03:08:35
|
quote:
Originally posted by DBA in the making
quote:
Originally posted by malraffi dont think we actually back up the logs currently
That would be the first thing I'd sort out.
Seconded! |
|
|
|
|
|
|
SAN setup