SQL 2012 Clusters

Question

SQL 2012 Clusters

Chandra Sekhara Vyas Dhara

SSChampion

Points: 10207
More actions
July 9, 2015 at 12:10 am

#302220

Comments posted to this topic are about the item SQL 2012 Clusters

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 1

Thanks for the question!

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 2

I thought it had to do with letters of the alphabet.

William Vach SSCertifiable Points: 5538 More actions · Answer 3

I got it wrong. Missed the part about shared storage.

david.gugg SSCertifiable Points: 6096 More actions · Answer 4

What is the difference between Shared Storage and SMB File Share? The link on that msdn page goes to https://msdn.microsoft.com/en-us/library/ms143506(v=sql.110).aspx#storagetypes, but it doesn't really describe them, it just names them.

Be still, and know that I am God - Psalm 46:10

RK Mandava SSCarpal Tunnel Points: 4153 More actions · Answer 5

david.gugg (7/9/2015)
What is the difference between Shared Storage and SMB File Share? The link on that msdn page goes to https://msdn.microsoft.com/en-us/library/ms143506(v=sql.110).aspx#storagetypes, but it doesn't really describe them, it just names them.

http://www.iscsi.com/resources/File-Level-Storage-vs-Block-Level-Storage.asp

SQL_Hunt SSC-Dedicated Points: 33518 More actions · Answer 6

https://msdn.microsoft.com/en-us/library/ms143432.aspx

25 instances on a failover cluster when using a shared cluster disk as the stored option for you cluster installation SQL Server supports 50 instances on a failover cluster if you choose SMB file shares as the storage option for your cluster installation.

Thanks.

TomThomson SSC Guru Points: 104773 More actions · Answer 7

RK Mandava (7/9/2015)
david.gugg (7/9/2015)
What is the difference between Shared Storage and SMB File Share? The link on that msdn page goes to https://msdn.microsoft.com/en-us/library/ms143506(v=sql.110).aspx#storagetypes, but it doesn't really describe them, it just names them.
http://www.iscsi.com/resources/File-Level-Storage-vs-Block-Level-Storage.asp

That reference doesn't appear to answer David Gugg's question, all it tells us is that SMB storage is storage shared at the file level. In other words, it's a particular case of shared storage.

The original question is not very good, since getting it right requires one to pretend that SMB/CIFS isn't a form of shared storage. I guessed that the author thought shared files weren't shared storage so the question wouldn't count SMB/CIFS as shared storage, which seemed a safe bet as some BOL pages seem to have been written by people who believe that, so I got a point. But giving an answer that is clearly wrong (because shared files are just as much shared storage as are shared drives) just to get a point is not something I liked doing.

I don't now where all the 8 and 16 answers came from though. More people so far have picked one of those two numbers than have picked 50 or 25, which suggests too many people don't know about SQL Server 2012 capacity limits.

Tom