high availability in SQL Server 2008R2.

Dear expert consultation regarding high availability in SQL Server 2008R2.

We have installed a SQL Server 2008R2 Enterprise Edition, with eight virtual cores. And we need it on high availability.

SQL Server 2008R2 supports something similar to Oracle RAC? or just have an active scheme - passive, passive license required?

thanks for your help,
enrique_aeoAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mark ElySenior Coldfusion DeveloperCommented:
No SQL is per processor whereas Oracle is processor strength
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
enrique_aeoAuthor Commented:
I do not understand your answer, more detail please
0
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Mark ElySenior Coldfusion DeveloperCommented:
Under the new licensing terms, customers using high-end servers with 8-core and 10-core processors will pay about twice as much to license SQL Server 2012 Enterprise Edition than they paid per processor for SQL Server 2008 R2 Enterprise Edition, according to an analysis by Directions on Microsoft (and republished by Microsoft Certified Professional Magazine). There's a cost break for many customers now using SQL Server 2008 R2 Datacenter Edition, but costs are still higher for SQL Server 2012 deployments on 4-processor, 8-core and 4-processor, 10-core servers.
0
slightwv (䄆 Netminder) Commented:
>>whereas Oracle is processor strength

slight correction:  Oracle currently uses the same Core Factoring SQL Server does.
0
slightwv (䄆 Netminder) Commented:
Mark Ely,

The askers question is how to set up SQL Server for High Availability and what additional licenses might be required for that configuration.

It is not about general SQL Server licensing in general.
0
Mark ElySenior Coldfusion DeveloperCommented:
Opps.. my bad.. thanks for the catch.
0
enrique_aeoAuthor Commented:
Please support the correct answer
i am little confused
0
Mark ElySenior Coldfusion DeveloperCommented:
If your question is about how to setup High Availability then you should use the High Availability wizard.

You need to determine whether you want to create a MSDTC (Miscrosoft Distributed Transaction Corrdinator).  The MSDTC cluster resource is not required when you installed the Database Engine component.  If it is not install then install it.  A dsitributed transaction is a transaction that runs across multiple servers.  MSDTC is not required if transactions run across multiple instances hosted on the same server!  

You configure MSDTC to function in a cluster by using Failover Cluster Mangaer.  Failing to configure MSDTC by using the High Availability Wizard will not block you from installing SQL server on a cluster, but app functionality might be impaired.

Read this for step by step instructions:
https://gheeknet.wordpress.com/2011/08/12/how-to-setup-mssql-server-2008-r2-for-high-availability-using-mirroring/

If your question is about  High Availability Options then you should read this:
http://www.mssqltips.com/sqlservertip/2337/sql-server-2008-high-availability-options/

If your question is about licensing then read the first article I posted.
0
enrique_aeoAuthor Commented:
it you mean:
Nosql is per processor whereas processor Oracle is strength
strength processor ???
0
Mark ElySenior Coldfusion DeveloperCommented:
As a general rule, Oracle’s license pricing practices do not restrict the number of
database instances a customer installs on a server, nor do they differentiate
between single server and networked environments. Multiple environments
may be installed on the same server. All users of all environments must be
properly licensed.

The Oracle Standard Edition One, Standard Edition and Enterprise Editions of
the database can be licensed using the Named User Plus metric or the Processor
metric. The Personal Edition can only be licensed using the Named User Plus
metric.

http://www.oracle.com/us/corporate/pricing/databaselicensing-070584.pdf
0
Mark ElySenior Coldfusion DeveloperCommented:
Processor: This metric is used in environments where users cannot be identified
and counted. The Internet is a typical environment where it is often difficult to
count users. This metric can also be used when the Named User Plus
population is very high and it is more cost effective for the customer to license
the Database using the Processor metric. The Processor metric is not offered for
Personal Edition. The number of required licenses shall be determined by
multiplying the total number of cores of the processor by a core processor
licensing factor specified on the Oracle Processor Core Factor Table which can
be accessed at http://oracle.com/contracts. All cores on all multicore chips for
each licensed program are to be aggregated before multiplying by the
appropriate core processor licensing factor and all fractions of a number are to
be rounded up to the next whole number. When licensing Oracle programs
with Standard Edition One or Standard Edition in the product name, a
processor is counted equivalent to a socket; however, in the case of multi-chip
modules, each chip in the multi-chip module is counted as one occupied socket.
For example, a multicore chip based server with an Oracle Processor Core
Factor of 0.25 installed and/or running the program (other than Standard
Edition One programs or Standard Edition programs) on 6 cores would require
2 processor licenses (6 multiplied by a core processor licensing factor of .25
equals 1.50, which is then rounded up to the next whole number, which is 2).
As another example, a multicore server for a hardware platform not specified in
the Oracle Processor Core Factor Table installed and/or running the program
on 10 cores would require 10 processor licenses (10 multiplied by a core
processor licensing factor of 1.0 for ‘All other multicore chips’ equals 10).
Note on Minimums: Product Minimums for Named User Plus licenses (where
the minimums are per processor) are calculated after the number of processors
to be licensed is determined, using the processor definition.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Well, focusing only in the original question, High-Availability in SQL Server 2008R2 can be accomplished with a Windows Cluster.
In terms of licensing you should have licensing for each node for Windows Server. A Windows Enterprise Edition will be needed. For SQL Server it depends on the Edition that you have. SQL Server Standard Edition allows you to have clustered instance in two nodes only. For more nodes you'll need Enterprise Edition. You need License for all Active nodes. Passive nodes doesn't need licensing.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.