SQL 2008 R2 Performance | CPU

Experts -

We've SQL server 2008 r2/6bit/4CPU VM on of our Prod system. What is the best method to update this to 8CPU?

The DB size is around 50G. The recovery mode is SIMPLE/single instance.

We wanted to AVOID the downtime.

Thanks,

~sve.
LVL 18
sventhanAsked:
Who is Participating?
 
OriNetworksConnect With a Mentor Commented:
I thought you wanted to simply upgrade the existing install to 8 virtual CPUs. That would be simplest and cause maybe 5 minutes of downtime to restart the virtual machine.

If you create a new instance on another server, you might be able to:
1. install the new instance and setup replication between inself and the production database. (WARNING: with 50GB of data it may cause the application to run slowly as data replicates for hours rather than the few minutes needed to restart the VM in my suggested solution)
2. Setup the same user accounts on the new SQL server.
3. Add an additional DNS record so that applications referencing SQLSERVER1 will now point to SQLSERVER2
4. Hope that it works correctly. Theoretically it should but every environment configuration is different.


I would risk the few minutes of downtime at the time of day with lowest use. If the uptime really was that critical that you couldnt have it down for a few minutes then it would already be setup as a cluster anyway. Kudos for being proactive though.
0
 
OriNetworksCommented:
The only way I know of to completely avoid downtime is if your SQL instance was on a cluster. To change the amount of CPUs on the server you would have to shut down the virtual machine.
0
 
sventhanAuthor Commented:
Thanks.

We also thinking about create a New server with 8 CPU / new instance 2008 R2 and try mirroring /replication / anything to minimize the downtime  ...

Any ideas?
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
This is more of a system issue than a SQL issue.
0
 
sventhanAuthor Commented:
@ Racimo

My Question is once the new server is ready with 8 CPU how can I move the DB from old server to new server? Any known best method to follow?  
0
 
Anthony PerkinsConnect With a Mentor Commented:
That is still going to require downtime.  In fact I would venture that you would have less downtime if you just added the CPU.
0
 
Racim BOUDJAKDJIConnect With a Mentor Database Architect - Dba - Data ScientistCommented:
<<Any known best method to follow?  >>
If using VMWare consider using  HA native Failover solution .  Thanks to its buffering capabilities, you should be able to move the VM to a new platform transparently for SQL Server.
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
The product is called VMOTION.  

http://www.vmware.com/products/vmotion/
0
 
sventhanAuthor Commented:
Thanks to all for the valuable comments/suggestions.


Our server is running on (just to add little more info)
OS < === Windows server 2008 Standard Edition .

0
 
OriNetworksCommented:
So its correct to assume the virtual platform is based on hyper-v
0
 
sventhanAuthor Commented:
Thanks for ALL the help. Very much appreciated.
0
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.

All Courses

From novice to tech pro — start learning today.