SP_2018 .
asked on
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.
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.
ASKER
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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