December 8, 2011 at 10:19 am
I am running the same SSIS package on both the servers and was very confused that why the server have higher resources runs very slow compare to the server who has very less resources.
Both are on SQL 2008 and have SSIS package running..
for example, when I run the same process on both the computer, it runs 3 times slower on computer B compare to computer A. Computer B has very high resources.
Appreciate if you could help me.
Computer Name : A
Processor : Itanium 2, 1.60 GHz
Memory : 16 GB
System type : 64 bit
Computer Name : B
Processor : Intel(R) Xeon(R) CPU X752 @ 2.67GHz (4 Processors)
Memory : 256 GB
System type : 64 bit
December 8, 2011 at 12:54 pm
There are a LOT of factors affecting performance. Does the packages use local databases only, or are there network traffic involved for only on of the servers? How fast is the disk subsystem, and how about the free bandwidth on the disk subsystem. How about free CPU resources?
December 8, 2011 at 1:28 pm
other factors that can influence performance:
- concurrent connections/users (b)locking on objects
- tempdb IO and tempdb sizing
- not using set based approaches
- organization of your tables, indexes, indexed views, ...
- over usage of view on view on ...
- to much parallel plans when such is not desired
- other services on your hosting server competing for cpu, io, ram
How about comparing the sqlplans that are used by your packages on the different servers
btw how up to date are your sqlinstances with regards to service packs and/or cumulative updates. The do matter!
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply