Shared or local SQL storage

I host several SQL Server 2008 instances.  Each instance runs about 150 databases. They each average about 10GB in size and get moderate usage.  Would it be advantagous to use shared storage or local storage?  I'm concerned that IO shared storage would traffic jam and bottleneck my SQL performance.  I could easily fit a 1000 databases onto a 4GB HBA file cluster, but should I?
Phil5780Asked:
Who is Participating?
 
GugroCommented:
when you are talking about "shared storage", what are you exactly mean ?
Currently you have two disks which yield 143 IOPS.
Sure if you throw in 8 disks you will have 1000 IOPS, but
if you have to share these disks with other applications who
will throw 900 IOPS on your "shared storage" you databases will loose performance...
0
 
andyalderCommented:
If it's only one server and you don't intend to cluster or take snapshots or use any of the replication facilities of a SAN then DAS is just as good and costs a lot less.

Having no idea about your shared storage I can't tell whether it would be a bottleneck or not, those 4GB could be spread over 100 hard disks or they could be on just 4, and it's the number of disks you have that makes the difference. At only 4GB I'd be empted to put a couple of SSDs in your server and put the data on them.
0
 
Phil5780Author Commented:
'4GB HBA' refers to the storage server which has a 4Gbit Host Bus Adapter network connection.
0
Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

 
andyalderCommented:
Oh, you confused me by calling it GB rather than Gb.

How much data and how many IOPS are required?
0
 
Phil5780Author Commented:
A single SQL server is running 150 databases which adds to ~680GB.  My max IOPS on 2 7200k disk is 143 IOPS.  If I used 8x 10000k disks (8 x 130 = 1040 IOPS), would that really be a 5 fold increase?  The IOPS on MLC SSD's is sky high.  Is it true that 2 OCZ SSD's would provide 16,000+ IOPS?  Seems fast enough to good to be true.
0
 
Phil5780Author Commented:
All disks are RAID 10.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.