[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1343
  • Last Modified:

HYPER-V VM slow performance with flat file database

Hi All,

We have  a brand new server running Server 2012 with HYPER-V role installed on it.
The configuration is HP ML350G8P, INTEL XEON E5-2620V2, 16GB RAM (2/8), 2 X 300 GB 6G SAS 15K HDD (RAID 1)

There is only 1 x VM in this server to which we have allocated 12 GB RAM, 140 GB HDD (Virtual IDE and Fixed Disk size) and 2 Core CPUs and it is also running Server 2012.

Now this VM is acting as a terminal server with a special software program running on it which runs a Flat file database. Everything is getting read and written to the C:\ drive of this server, ut this program is taking 7-8 times longer to fetch queries/generating report etc. Additionally Outlook seems to be running slow as well. What can we do to increase the performance, so it performs same as our old server which was 6 years old, running Server 2003 OS?

I have checked Resource Monitor and none of the components - RAM, CPU, DISK etc. are in stress.
Not sure what the issue is here.
0
manav08
Asked:
manav08
  • 22
  • 8
  • 3
  • +3
1 Solution
 
Sabi GorayaCommented:
is the host server under constraint when you check Resource Monitor for the host server ?
0
 
manav08Author Commented:
yes, already checked, no stress on that either
0
 
David Johnson, CD, MVPOwnerCommented:
you say that it is writing to the root of c:\  the root of c:\ is a protected area. can you write to a subfolder of c: instead
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
manav08Author Commented:
Hi David,

On the C:\ drive of this VM Server we have a subfolder and this application is getting read of there.
So, the application path is c:\subfolder\file.exe
0
 
Vaseem MohammedCommented:
Making a wild guess here.,
If there is no specific requirement of 2 Cores, try to reduce the core config from 2 to 1CPU core.
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Add more sockets.

or switch to a physical server. (yes, Hypervisors do have some constraints!),
0
 
manav08Author Commented:
One says change to 1 core. Other says increase the cores. What should I do??
I will test application soon on the HYPER-V itself and let you know the result
0
 
manav08Author Commented:
The VHDX wouldn't e any different to VHD speed wise would it?
Also, when we moved the software to HYPER-V itself, the speed is fine. What the hell is going on :(
0
 
manav08Author Commented:
CPU has 6 cores, so tried adding 5 Virtual CPUs to VM and that didn't help.
Then tried adding 1 Virtual CPU only and that didn't help either.
0
 
Vaseem MohammedCommented:
The special software program that you are running is compatible with windows 2012 OS?
0
 
manav08Author Commented:
yes ofcourse which is why we can run in HYPER-V of Server 2012 at fast speeds. It is a simple flat file database that runs in a folder.
0
 
manav08Author Commented:
If it helps you, I just now also tried attaching a SCSI FIXED DISK and moved our Flat file database there to test speeds. No difference at all. So VHD or VHDx doesn't matter I suppose, niether does CPU. What shall we do now??
0
 
Vaseem MohammedCommented:
I hope you don't have snapshots associated with the OS disk (vhd).
See if you can post the screenshot of CPU, RAM and Hyper-V Switch configuration settings.
0
 
AbhishekJhaCommented:
First of all verify whether the integration service is update to latest version or not as 2012 is hyper-v compatible it doesn't ask to install integration services by default. Also check integration service is enabled or disabled.

If above not fixes the problem then check processor setting that whether it is running in compatible mode or not.

open resource monitor & add filter to disk I/O read & write & check try using your application to monitor the speed throughout.
0
 
manav08Author Commented:
@Abhishekjha - Just checked and we are running latest version of integration services, so it wont reinstall on top. All services are enabled.
Resource monitor shows 1% disc usage and 20% CPU Usage and 20% RAM usage.

@Vaseem

There is nothing uncommon about the config. It is standard config
0
 
manav08Author Commented:
Also I am now changing RAID stripe size to 64Kb. By default on HP Server this is set to 256 Kb.
I noticed that DELL servers have stripe size set to 64KB.
Not sure if this will change anything. Fingers crossed though.
Anyone else got any ideas?
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
do you have a BBWC enabled and installed, as 75% Write, 25% Rread
0
 
manav08Author Commented:
I dont believe so, how do we check?
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
If you have the Array Configuration Utilities installed, you can check if you can set the cache....

these are usually available as options, unless you purchased a performance edition, where it comes as standard.

Battery Backup Write Cache
0
 
manav08Author Commented:
Hi Andrew,

Checked and cached ration os like you said, however I am thinking if it is worth changing it to 75% read and 25% write, given that the flat file database has problems when fetching data/generating reports/queries etc.??

Also what is your opinion on stripe size?
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
As for stripe size, it depends on the workload.
0
 
manav08Author Commented:
so what is your opinion on changing BBWC to 75% read and 25% write and changing Stripe size to 512 or higher?
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
We always change the BBWC cache to 75% read and 25% write always, on all smart array controller.

As for stripe size we've always left as default.
0
 
manav08Author Commented:
How long does it take to see the effect of this BBWC change?
0
 
manav08Author Commented:
I see no difference in performance so far.
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
It's immediate.
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
if you run the application on the HOST, and not as a Guest VM, does it run better ?
0
 
manav08Author Commented:
Hi Andrew,

It runs better but still not as good as our Windows Server 2003 Server before.
Same Queries/Reports are taking 25 seconds on host, 78 seconds in VM Guest as opposed to 13 seconds on our old Server.

Old server was a whitebox server with RAID 1 drives (Just standard SATA drives)
Also it only had 4GB Ram and Xeon CPU 3.2 Ghz
0
 
manav08Author Commented:
Another strange thing I notice on the Guest VM is that when I run the report once it is running fast now @25 seconds but the second time I run same report it takes @78 seconds. Wierd!!

Software vendors as usual are not very helpful with this. They just say, look it works fine on my Windows 8 PC which is not even RAID, so problem is with your server.. go and fix it!!
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Does the performance need to equal that of the older server ?
0
 
manav08Author Commented:
Hi Andrew,

Not precisely, but it should be close. If it is 6 time slower than users start complaining.
0
 
manav08Author Commented:
We are no closer to resolving this Speeds were worse today when everyone was logged in.
0
 
manav08Author Commented:
ok guys this issue has really had me stumped.

I moved the whole program to the physical layer i.e. HYPER-V host machine.
Joing it to domain and enable remote desktop services.
Now this application is running excrutiatingly slow.

When we tried yesterday running the same application on HYPER-V host with no terminal services or it being joined to domain, the speeds were really good.

Does anyone know if RAM distribution in terminal services could be causing this issue. Testing was done with only a single user logged on, so not like the server was under some kind of stress. Also Resource monitor has no stress on CPU, RAM or DISK
0
 
manav08Author Commented:
Tried another virtual instance of the server and same issue.
As soon as terminal services is installed, the application slows down.
You take off terminal services and application goes back to normal
0
 
manav08Author Commented:
As I am recieving no response, I am posting another question here... http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Windows_Server_2012/Q_28510654.html
0
 
manav08Author Commented:
Hi All,

I would love to give points for effort, but doing so in the past I have got in trouble.
So I would be requesting closure of this question as it was resolved in http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Windows_Server_2012/Q_28510654.html by another user.
The issue it seems was not HYPER-V related but Terminal Services related and caused by FAIR SHARE.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 22
  • 8
  • 3
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now