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 |
|
Sonu619
Posting Yak Master
202 Posts |
 Posted - 2010-06-02 : 18:36:24
|
| Hi all, Quick question. How long it take to 400gb data to populate Dim & Fact through ETL Process?Thanks in advance. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-06-03 : 02:01:59
|
What is your hardware?
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
Sonu619
Posting Yak Master
202 Posts |
Posted - 2010-06-05 : 01:32:08
|
| ITS REALLY DEPEND ON HARDWARE?Hardware: IBM System x3755 4 processors - Six-Core AMD Supports both 32 bit and 64 bit applicationsinternal storage of 1.2TBmemory 128GB DDR-II 667MHz |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-06-05 : 06:43:43
|
Yes, of course it depends on the hardware.Do you think loading 400GB of data takes equally long time on a brand new 256 core, 1TB RAM server with fibre-channel SAN, than on my 12 year old 386 server with IDE harddrive and 256MB memory?
N 56°04'39.26"E 12°55'05.63" |
|
|
|
Sonu619
Posting Yak Master
202 Posts |
Posted - 2010-06-07 : 21:41:26
|
| I thought that requirement of hardware to install SQL Server 2005/2008 is good enough. Yes you are 100% right. What you think or what is your close guess to load 400GB? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2010-06-08 : 03:44:51
|
Anywhere between one minute and 48 hours.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
Sonu619
Posting Yak Master
202 Posts |
Posted - 2010-06-08 : 18:01:59
|
| Thanks for your answer!!!): |
|
|
|
|
|
|
Populate Dim & Fact