We are midsized company and looking to upgrade our current DI Server configuration ( current one sucks ).
We process quite a bit of data. A few of our data sources have upto 3 -4 million rows per day. We process quite a few data sources of that kind.
Please let me know what ur current server configuration is
i.e. Server ( eq. Dell Intel xxx , HP AMD xxx , NEC xxx)
OS
Number of CPU/ cores
Memory
Storage configuration.
Let me know.
Devendra (BOB member since 2009-06-25)
Take a look at
It would be a good idea for you also to add your benchmarking details as this then adds to the list of configurations/performance.
gpn01 
(BOB member since 2004-11-30)
Please search through these DI forums, as this question has been asked before.
Broadly speaking:
The answer, like always, is “it depends”. 3M rows per day isn’t that big a deal, but it depends if that’s in 1 table or in 100 tables. Depends on the complexity of the ETL job. Depends on the size/width of those tables being loaded. And so on.
If you have a reasonably-sized DI server, then the bottleneck is more likely to be with the database servers involved.
If you can, put DI on the same server as your target database server.
What is your current environment/specs? And what is the performance? Doing the benchmark comparison as suggested above may help tell you how your environment will perform relative to others.
dnewton 
(BOB member since 2004-01-30)