Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Clustering / May 2006

Tip: Looking for answers? Try searching our database.

SQL 2005 clustering or mirroring

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Hassan - 14 Apr 2006 05:42 GMT
What are organizations using today for HA ? I guess organizations who have
money to spend ;)

Are they using clustering or mirroring or both ?

I would really like to know.

Thanks
Andrew J. Kelly - 14 Apr 2006 12:51 GMT
You will definitely find more using clustering than Mirroring simply due to
the fact that Clustering has been around so much longer than Mirroring.  But
what good is asking what someone is using without knowing why?  Like any
feature both have pro's & Cons.  Just because someone else is using
clustering does not mean it is the best for you or the next guy.

Signature

Andrew J. Kelly  SQL MVP

> What are organizations using today for HA ? I guess organizations who have
> money to spend ;)
[quoted text clipped - 4 lines]
>
> Thanks
Geoff N. Hiten - 14 Apr 2006 16:27 GMT
You would be surprised at the current cost of clustering.  You can get a
two-node cluster with dual-core, dual proc hosts for around $35-40K,
including SQL licenses.  If you need quad-proc hosts, the price jumps to
around $100k.  Before SQL 2005,  it would take $80K just for the lSQL
icenses.  The cost of clustering has come way down in the last year.  Of
course, you still need the personnel and infrastructure to support a highly
available system, but that is never going to change.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

> What are organizations using today for HA ? I guess organizations who have
> money to spend ;)
[quoted text clipped - 4 lines]
>
> Thanks
Michael Hotek - 14 Apr 2006 23:58 GMT
Are people eating apples or oranges?  This isn't a simple plug it in and it
works.

I've seen clusters that worked very well and ones that were complete
disasters.  Niether one had anything to do with the technology.  The ones
that were complete disasters deployed clustering, without ever considering
what it was they were trying to accomplish or if it would even meet their
business requirements.

I've seen the same thing happen with replication, log shipping, 3rd party
products, and backup/restore.  95% of the work you do for HA has absolutely
nothing whatsoever to do with a particular technology.  5% of HA is the
technology you deploy.  So, the question becomes, which makes more sense
worrying about the technology (5%) or figuring out all of the business
requirements along with what you are protecting and why (95%)?

Signature

Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject.  It does not represent the views of any other person
or entity either by inference or direct reference.

> What are organizations using today for HA ? I guess organizations who have
> money to spend ;)
[quoted text clipped - 4 lines]
>
> Thanks
Linchi Shea - 17 Apr 2006 22:26 GMT
If I may interpret 'mirroring' broadly (more broadly than as is used in the
SQL2005 Database Mirroring feature), we use disk level mirroring between
geographically dispersed data centers, and clustering locally within a data
center. This combination has worked out very effectively.

Linchi

> What are organizations using today for HA ? I guess organizations who have
> money to spend ;)
[quoted text clipped - 4 lines]
>
> Thanks
Hassan - 18 Apr 2006 07:53 GMT
what solution do you use for disl level mirroring ? Can you tell me more
about this ?

> If I may interpret 'mirroring' broadly (more broadly than as is used in
> the
[quoted text clipped - 14 lines]
>>
>> Thanks
Linchi Shea - 18 Apr 2006 16:22 GMT
EMC SRDF synchronous between data centers.

Linchi

> what solution do you use for disl level mirroring ? Can you tell me more
> about this ?
[quoted text clipped - 17 lines]
> >>
> >> Thanks
Steve Cook - 26 May 2006 01:31 GMT
We use IBM Continuous Availability for Windows
Here are some links to more info.

Business Continuity Products, go down to the Brochures list for CAW
http://www-03.ibm.com/servers/storage/solutions/business_continuity/resources.html

Solution PDF
ftp://ftp.software.ibm.com/common/ssi/rep_sp/n/TSS01058USEN/TSS01058USEN.PDF

Regards,
-Steven D Cook

> what solution do you use for disl level mirroring ? Can you tell me more
> about this ?
[quoted text clipped - 17 lines]
>>>
>>> Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.