SolvedPrivate

SSIS performance issues on a virtual machine

Posted on 2013-10-23
3
19 Views
Last Modified: 2016-02-11
Hi,

I have been having performance issues while running  SSIS packages meant for incremental load for a datawarehouse on a virtual machine.
The time taken for the job to run is varying from 45 mins to an hour and sometime drags to 3 hours. there are no locks or deadlocks seen during that time but the servers seems to be very slow.
I suspect this to be an issue with the performance of the virtual machine, while my supervisor would like me to trigger some windows performance monitoring from inside sql server.
My question is  can collecting performance related  information from withing the virtual guest help find the performance bottleneck or does it need to be done from the host.

Thanks.
0
Comment
Question by:isonali
  • 2
3 Comments
 
LVL 39

Expert Comment

by:lcohan
ID: 39595534
My (obvious) guess is due to heavy T-log operations during  "...incremental load for a datawarehouse..." which means IO and could you at least check and make sure the VM mirroring is disabled? Also check anti virus exclusions and all it may apply to you listed in the KB below:

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1008360

Could you also check if there are (lots) of snapshots on that host? Please see more details at link below:

https://communities.netapp.com/thread/16975
0
 

Author Comment

by:isonali
ID: 39595634
Thanks for the reply.
Could you please elaborate regarding vm mirroring , the disks on the host are on the SAN,

The anitivirus is enabled on the host and are configured to exclude the virtual machine files.
Also there are 0 snapshots on the host.

How do i monitor windows performance from within the vm when the incremental jobs are running.?
I use perfmon to monitor baseline of the vm,

Please advise.

Thanks
0
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 39597948
Please see details here and I would monitor for sure Average Disk Queue Length on that VM image aside of Memory and CPU.

http://searchvmware.techtarget.com/tip/VMware-vSpheres-built-in-performance-monitoring-tools


As far as "vm mirroring" I may have used an improper term and what I meant was to check and see if vMotion is not cloning/moving your vm to another host just because of these performance issues and it will make it actually a lot worse. Not very easy to explain for me and please look at details from link below

http://www.vmware.com/products/vsphere/features-vmotion
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
My client sends data in an Excel file to me to load them into Staging database. The file contains many sheets that they have same structure. In this article, I would like to share the simple way to load data of multiple sheets by using SSIS.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

708 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now