We help IT Professionals succeed at work.

Performance Issues w/ Hyper-V VM

832 Views
Last Modified: 2013-11-06
We have an ETL process that kicks off at 4am every Sunday Morning.  This process used to take 2 - 2 1/2 hours to run, not it is taking 5-6 hours.  This issue seemed to start after upgrading the VM from Virtual Server 2005 R2 to Hyper-V.    Months ago we were trying to fix the SAN performance issues by upgrading the VM, but that didn't fix the problem.   The Hyper-V VM is running 4 procs, 6 gig ram and using high speed LUN's.  The ETL job is kicked off as a MS scheduled job.  The VM is running Server 2003 Standard R2 Standard SP2 w/ SQL server 2005 sp2.  When monitoring the process as it is running, the CPU usage and RAM usage is minimal to moderate,  never even close to utilizing the full CPU or RAM usage.   There is a massive amount of I/O taking place, which is typical in an ETL process.  So the problem seems to be through-put, however, we cannot find a solution.   We are using high-speed luns on the SAN.  We also added the /3gb switch to the startup.   Actual CPU utilization is hovering from 30 to 65%, ram usage is minimal.  TempDB is getting hammered and disk load is maxxed out.   The I/O wait states are very high.  


Comment
Watch Question

Author

Commented:
Additional Info: 2 - 4Gbps fiber connections to the Pillar (SAN)
>Tempdb is getting hammered
Is it configured optimally? with lot of file size and 1 data file per CPU?

Author

Commented:
Yes, it is configured optimally with data files spread across 4 cpu's
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.