Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
2lazydba
Yak Posting Veteran
62 Posts |
Posted - 2006-10-04 : 17:10:48
|
Hi,Can any one point out a whitepaper/article or something which describes in detail the metrics in SSIS related to CPU usuage, Memory usage, page faults etc depending on the volume of load.We are planning to use SSIS for ETL purposes and DB size is around 3 TB. Plan is to have ssis packages continously run E-T-L...so wanted to understand how SSIS would behave.Thanks |
|
2lazydba
Yak Posting Veteran
62 Posts |
Posted - 2006-10-06 : 13:16:37
|
anybody listening??????? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-06 : 14:44:56
|
I doubt any whitepaper/article exists for this. You will need to test it to see what kind of performance that you will get. Besides, it's going to be hardware dependent, database design dependent, etc..., so no article would be able to tell you exactly what to expect on your specific system.Tara Kizer |
|
|
|
|
|