SQL Server 2008 R2 SP2 standard capability for DB consolidation projects

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,
LVL 9
Senior IT System EngineerIT ProfessionalAsked:
Who is Participating?
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.

hspoulsenCommented:
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.
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
Senior IT System EngineerIT ProfessionalAuthor Commented:
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.
0
hspoulsenCommented:
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...
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

From novice to tech pro — start learning today.