question

clayp56 avatar image
clayp56 asked

SQL Server 2012 SAN configuration

Just wanted to check in and get some advise. I also wanted to pick your brain about SQL Server layout. Specifically if SSD drives are involved. I am currently getting quotes for a SAN and plan to upgrade our database to SQL Server 2012 Standard running on 2008 R2 server. What would you recommend for a layout of the SAN drives? Currently we have this running on a standalone IBM server with direct attached storage. All drives are 15k SAS Raid 1 (2 drives) - OS and System databases Raid 1 (2 drives)- tempdb Raid 1 (2 drives)- log files The database itself is broken into three files. DBB_1010.mdf, DBB_INDEX, DBB_OVERFLOW. Each are on separate Raid 10 arrays Raid 10 (4 drives)—DBB_1010 Raid 10 (4 drives)- Index Raid 10 (4 drives)- overflow Thanks!
san
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I'm a little confused, you are mentioning quotes for a SAN but talking about drives that are more like an external RAID rather than a SAN. Can you provide any links to the kind of solution that you are looking at? Additionally, if you know your i/o requirements that would be useful.
0 Likes 0 ·

1 Answer

· Write an Answer
clayp56 avatar image
clayp56 answered
Thanks got my answer here at the office!!
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Glad to hear you solved it. Can you edit the answer here so that if others have the same issue they know what the solution was?
2 Likes 2 ·
Agreed. What was the answer? Post it here so that others can see... and you can get more points here too.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.