Solved

Virtual Machine - Need advise

Posted on 2016-10-13
4
59 Views
Last Modified: 2016-10-16
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?
0
Comment
Question by:Manju
  • 2
4 Comments
 
LVL 95

Accepted Solution

by:
Lee W, MVP earned 500 total points
ID: 41842251
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.
0
 
LVL 6

Author Comment

by:Manju
ID: 41842275
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)
0
 
LVL 95

Assisted Solution

by:Lee W, MVP
Lee W, MVP earned 500 total points
ID: 41842709
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/
0
 
LVL 2

Expert Comment

by:Alex Smith
ID: 41846152
Its might be depends on your server location. Host your server nearby your work
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Every morning - Cannot get online - Need to reboot Dell XPS PC 5 81
BIOS Flasher Utility problem 5 65
How do I hook up a bluetooth speaker? 20 131
Adobe Premier GPU Issues 6 28
Every server (virtual or physical) needs a console: and the console can be provided through hardware directly connected, software for remote connections, local connections, through a KVM, etc. This document explains the different types of consol…
In the modern office, employees tend to move around the workplace a lot more freely. Conferences, collaborative groups, flexible seating and working from home require a new level of mobility. Technology has not only changed the behavior and the expe…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

803 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