• Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 38
  • Last Modified:

SSIS performance issues on a virtual machine

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
Sonali P
Asked:
Sonali P
  • 2
1 Solution
 
lcohanDatabase AnalystCommented:
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
 
Sonali PDatabase AdministratorAuthor Commented:
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
 
lcohanDatabase AnalystCommented:
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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now