February 17, 2010 at 12:16 pm
Hi All,
we are facing a weird situation in our environment
to give a background we have a poduction server with 4 processors and 4 gb of ram, ther when we run a package which will process a text file contains 100,000 row to a table and this ssis package have a lookup with another table, at the end the process took 2 mins 55 seconds.
now we brought a new server with 64 gb ram and 6 dual core processors
we have restored the DB from here current to new server
when we try to run the package it is taking 9 minutes to run for the same package for same 100,000 rows.
could anybody tell me what might be the issue?
your help is more appriciateble.
February 17, 2010 at 12:25 pm
While I am far from an expert in SSIS Performance, my experience has been that a package's performance is very sensitive to the batching and other settings on the dataflow task. And that their optimal settings can be very different on different configurations. For instance, I believe that the more cores that you have, then the smaller you want these values to be.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
February 17, 2010 at 2:58 pm
One of the post-migration steps I always take is to run a full update stats on the DB.
That might help.
Craig Outcalt
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply