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.