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.
SP_2018 .IT ConsultantAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
SP_2018 .IT ConsultantAuthor 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Development

From novice to tech pro — start learning today.