SQL Server 2008 R2 SP2 standard capability for DB consolidation projects

Posted on 2013-09-01
Medium Priority
Last Modified: 2013-09-09
I wonder if anyone can assist me in clarifying this SQL Server 2008 features for the database consolidation project which put ~ 110 DB files into one node and then mirrored across 1 GB WAN link:

My company is planning to consolidate all of the SQL Server 2000-2008 edition ranging from Enterprise to Standard in just two node only spread across different sites for both Production and DR sites. So at the end of the project there will be just 2x SQL Server database stand alone servers.

Rather than using the 2x Enterprise nodes in each sites (in total of 4x nodes cluster) to minimize downtime during the base Windows OS patching, we are seeking cheaper option by using the Standard edition only, In terms of database recovery, the business accept that during the specific non business hours window, no more than 20 minutes of downtime is accepted.

1.      Can we achieve the availability above with just using 2x Standard edition nodes set to replicate with Synchronous mirroring only ?

2.      The head server is very powerful with 4x 16 core CPU (in total of 64 CPU) and 256 GB of RAM, does the SQL Server 2008 R2 SP 2 Standard Edition 64 bit capable of utilizing that features ?

Thanks in advance,
  • 2

Accepted Solution

hspoulsen earned 2000 total points
ID: 39457514
if you ever want to upgrade your SQL Server to SQL Server 2012 or 2014, the standard edition will only use 16 cores in total.

I do not know much about mirroring, but 20 minutes does not sound as a long time.

Author Comment

by:Senior IT System Engineer
ID: 39457591
exactly, I'm worries as at the moment cost is the limitation, so I am forced with no other option to use any features outside the Enterprise Edition.

using Enterprise Edition with 64 cores would blow up the budget so bad, hence I am asking the assistance and idea of what are my options.

Assisted Solution

hspoulsen earned 2000 total points
ID: 39457676
Yes, it is really expensive now.

But that makes it worth-wile to hunt down unnecessary I/O, which we've found to be plentiful on our systems.
Then you no longer need all the 64 cores...

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

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.

Join & Write a Comment

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

597 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question