• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 102
  • Last Modified:

Virtual Machine - Need advise

Team - I need your advise for the below:

We had a VM(old server) with the below config:
Processor: [Intel(R) Xeon(R) CPU E5-4657L v2 @ 2.40GHz, 2400 Mhz, 2 Core(s), 1 Logical Processor(s)"]
OS: Microsoft Windows Server Enterprise
SQL: SQL Server 2008 Enterprise

We now have a VM(New server) with the below config:
Processor: [Intel(R) Xeon(R) CPU E5-2697 v2 @ 2.70GHz, 2700 Mhz, 2 Core(s), 2 Logical Processor(s)"]
OS: Microsoft Windows Server 2012 R2 Standard
SQL: SQL Server 2014 Standard

RAM on both servers: 64GB

VM is being accessed by ~30 users at various intervals and are complaining about latency issues in the new server. We also have an excel file in each user's machine which is connected to VM SQL via data connection. What used to take 5 mins in old server, now takes more than 45 mins.

I would like to get your opinion if the new server is actually better / worse than the old one.

We know for sure, SQL needs to be upgraded to enterprise. anything apart from that?
  • 2
2 Solutions
Lee W, MVPTechnology and Business Process AdvisorCommented:
VMWare or Microsoft Hyper-V?  If the latter, there's a known issue with performance of networking using Broadcom Chipsets.  Default drivers perform HORRIBLY.  Update the drivers - direct from broadcom if you have to.

I've seen IBM/Lenovo and Dell servers both experience this problem.
ManjuIT - Project ManagerAuthor Commented:
It says, Without Hyper-V.  btw, is the new server processor better than old one? (coz old says 8 processor and new says 5 processor)
Lee W, MVPTechnology and Business Process AdvisorCommented:
Huh?  I was asking what the HOST virtualization platform is?  Is it VMWare ESXi or is it Hyper-V.  What do you mean new one says 5 processor?  Do mean someone allocated  5 processors?  That's WAY too much (most likely).  Start with 2 allocated processors and increase as necessary based on CPU usage.

Read: http://www.zdnet.com/article/virtual-cpus-the-overprovisioning-penalty-of-vcpu-to-pcpu-ratios/
Alex SmithHosting Solution ProviderCommented:
Its might be depends on your server location. Host your server nearby your work
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now