?
SolvedPrivate

SSIS performance issues on a virtual machine

Posted on 2013-10-23
3
Medium Priority
?
26 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:Sonali Patade
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 40

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:Sonali Patade
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 40

Accepted Solution

by:
lcohan earned 1500 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

770 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