Jim1234 (10/11/2013)
Thanks Koen. So if I increase the destination database size or the disk space, the package load performance can be improved? I'm asking this because if increasing the size will help the performance, I have to contact my DBAs to do the same.
Not necessarily.
Enlarging the size of the database file will stop your package from failing.
However, if the database file size is always a bit too small and it has to autogrow each time (I don't know what the settings are on the database) and the autogrow settings are inadequate, it is possible that the database file is more busy with trying to grow than storing data. So yes, choosing a decent size for the database file might improve performance, but not necessarily.
You need to test what the bottleneck of your package is. Is it the source, the destination or something in between?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP