 | |
SQL Clustering Options
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
SQL Clustering Options -
02-22-2005
, 09:03 PM
#2
| |||
| |||
|
|
I have read that SQL Server with MSCS supports an Active/Active setup via a NAS, however, DOES NOT support and Active/Active setup via a SAN. Can anyone shed light on this? Any support documentation that would help would be great! Thank you. |
#3
| |||
| |||
|
|
Can't point you to any doco off the top of my head, but I can say definitively that SQL 2000 running on an MSCS cluster can indeed talk to a SAN regardless of how many SQL instances you have on your cluster. Typically people either have a single instance (which most people refer to as "active/passive") or 2 instances (which most people refer to as "active/active") that they try to keep on separate nodes of the cluster. But you could have up to 16 instances running on a single cluster node - the number of instances doesn't really matter. Basically, all cluster aware SQL server needs is a shared disk to write data (& log) files to. Whether this is a NAS device or a SAN device is irrelevant to SQL server - that's managed by MSCS, not SQL. We've been running several "active/active" SQL clusters on top of MSCS talking to both HP & EMC SANs (as well as HP & Dell NAS arrays) for over 4 years now. It all works fine. As I said I don't have doco on it but I'm sure it wouldn't be too hard to find cruising around the Microsoft website. -- *mike hodgson* |/ database administrator/ | mallesons stephen jaques *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907 *E* mailto:mike.hodgson (AT) mallesons (DOT) nospam.com |* W* http://www.mallesons.com TABMCSE wrote: I have read that SQL Server with MSCS supports an Active/Active setup via a NAS, however, DOES NOT support and Active/Active setup via a SAN. Can anyone shed light on this? Any support documentation that would help would be great! Thank you |
#4
| |||
| |||
|
|
Hi SAN is fully supported by MSCS, as long as it is on the HCL. NAS is not. Look at http://support.microsoft.com/default...b;en-us;304261 Regards Mike "Mike Hodgson" wrote: Can't point you to any doco off the top of my head, but I can say definitively that SQL 2000 running on an MSCS cluster can indeed talk to a SAN regardless of how many SQL instances you have on your cluster. Typically people either have a single instance (which most people refer to as "active/passive") or 2 instances (which most people refer to as "active/active") that they try to keep on separate nodes of the cluster. But you could have up to 16 instances running on a single cluster node - the number of instances doesn't really matter. Basically, all cluster aware SQL server needs is a shared disk to write data (& log) files to. Whether this is a NAS device or a SAN device is irrelevant to SQL server - that's managed by MSCS, not SQL. We've been running several "active/active" SQL clusters on top of MSCS talking to both HP & EMC SANs (as well as HP & Dell NAS arrays) for over 4 years now. It all works fine. As I said I don't have doco on it but I'm sure it wouldn't be too hard to find cruising around the Microsoft website. -- *mike hodgson* |/ database administrator/ | mallesons stephen jaques *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907 *E* mailto:mike.hodgson (AT) mallesons (DOT) nospam.com |* W* http://www.mallesons.com TABMCSE wrote: I have read that SQL Server with MSCS supports an Active/Active setup via a NAS, however, DOES NOT support and Active/Active setup via a SAN. Can anyone shed light on this? Any support documentation that would help would be great! Thank you |
#5
| |||
| |||
|
|
Sorry, when I said NAS I meant DAS (direct attached storage) - like Dell PowerVault S220, Hewlett Packard RS12, etc. My bad - maybe I should quit while I'm still ahead (or should that be while I'm not too far behind yet?). -- *mike hodgson* |/ database administrator/ | mallesons stephen jaques *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907 *E* mailto:mike.hodgson (AT) mallesons (DOT) nospam.com |* W* http://www.mallesons.com Mike Epprecht (SQL MVP) wrote: Hi SAN is fully supported by MSCS, as long as it is on the HCL. NAS is not. Look at http://support.microsoft.com/default...b;en-us;304261 Regards Mike "Mike Hodgson" wrote: Can't point you to any doco off the top of my head, but I can say definitively that SQL 2000 running on an MSCS cluster can indeed talk to a SAN regardless of how many SQL instances you have on your cluster. Typically people either have a single instance (which most people refer to as "active/passive") or 2 instances (which most people refer to as "active/active") that they try to keep on separate nodes of the cluster. But you could have up to 16 instances running on a single cluster node - the number of instances doesn't really matter. Basically, all cluster aware SQL server needs is a shared disk to write data (& log) files to. Whether this is a NAS device or a SAN device is irrelevant to SQL server - that's managed by MSCS, not SQL. We've been running several "active/active" SQL clusters on top of MSCS talking to both HP & EMC SANs (as well as HP & Dell NAS arrays) for over 4 years now. It all works fine. As I said I don't have doco on it but I'm sure it wouldn't be too hard to find cruising around the Microsoft website. -- *mike hodgson* |/ database administrator/ | mallesons stephen jaques *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907 *E* mailto:mike.hodgson (AT) mallesons (DOT) nospam.com |* W* http://www.mallesons.com TABMCSE wrote: I have read that SQL Server with MSCS supports an Active/Active setup via a NAS, however, DOES NOT support and Active/Active setup via a SAN. Can anyone shed light on this? Any support documentation that would help would be great! Thank you |
#6
| |||
| |||
|
|
Hi You are still ahead......and all you said is correct. NAS is supported, but with such a restrictive set of rules, it makes NAS not very useful. SAN is still the most correct choice IMHO. Cheers Mike "Mike Hodgson" wrote: Sorry, when I said NAS I meant DAS (direct attached storage) - like Dell PowerVault S220, Hewlett Packard RS12, etc. My bad - maybe I should quit while I'm still ahead (or should that be while I'm not too far behind yet?). -- *mike hodgson* |/ database administrator/ | mallesons stephen jaques *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907 *E* mailto:mike.hodgson (AT) mallesons (DOT) nospam.com |* W* http://www.mallesons.com Mike Epprecht (SQL MVP) wrote: Hi SAN is fully supported by MSCS, as long as it is on the HCL. NAS is not. Look at http://support.microsoft.com/default...b;en-us;304261 Regards Mike "Mike Hodgson" wrote: Can't point you to any doco off the top of my head, but I can say definitively that SQL 2000 running on an MSCS cluster can indeed talk to a SAN regardless of how many SQL instances you have on your cluster. Typically people either have a single instance (which most people refer to as "active/passive") or 2 instances (which most people refer to as "active/active") that they try to keep on separate nodes of the cluster. But you could have up to 16 instances running on a single cluster node - the number of instances doesn't really matter. Basically, all cluster aware SQL server needs is a shared disk to write data (& log) files to. Whether this is a NAS device or a SAN device is irrelevant to SQL server - that's managed by MSCS, not SQL. We've been running several "active/active" SQL clusters on top of MSCS talking to both HP & EMC SANs (as well as HP & Dell NAS arrays) for over 4 years now. It all works fine. As I said I don't have doco on it but I'm sure it wouldn't be too hard to find cruising around the Microsoft website. -- *mike hodgson* |/ database administrator/ | mallesons stephen jaques *T* +61 (2) 9296 3668 |* F* +61 (2) 9296 3885 |* M* +61 (408) 675 907 *E* mailto:mike.hodgson (AT) mallesons (DOT) nospam.com |* W* http://www.mallesons.com TABMCSE wrote: I have read that SQL Server with MSCS supports an Active/Active setup via a NAS, however, DOES NOT support and Active/Active setup via a SAN. Can anyone shed light on this? Any support documentation that would help would be great! Thank you |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.