SolvedPrivate

SSIS performance issues on a virtual machine

Posted on 2013-10-23
3
20 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help with Sorting Full Text results 2 15
T-SQL--Two Different Totals Even with the Same Concept 6 46
SQL Server stored proc 2 13
SQL Field Length for Email Address 3 18
My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how the fundamental information of how to create a table.

863 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

19 Experts available now in Live!

Get 1:1 Help Now