Data warehouse Server Spec
Hi Guys,
I'm looking for some assistance on a server spec I should use for a Data warehouse server, the server will be used by around 20 - 40 users. I need something that will be fast when running reports and wont lag.
The data warehouse itself will hold big databases with updates of 40 Million + records a day going into them.
Can someone please recommend a spec for me: hard disk space, scalability to add in additional disks if necessary, processor spec, memory etc.
Thanks
Jay Eire
I'm looking for some assistance on a server spec I should use for a Data warehouse server, the server will be used by around 20 - 40 users. I need something that will be fast when running reports and wont lag.
The data warehouse itself will hold big databases with updates of 40 Million + records a day going into them.
Can someone please recommend a spec for me: hard disk space, scalability to add in additional disks if necessary, processor spec, memory etc.
Thanks
Jay Eire
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
It's impossible to guess, your 40 million records may be 10 bytes each or they may be 100MB each. If the current server copes with the load give us the spec of it and we can find a similar spec server that's available now and add a bit of redundancy and extra performance.
>The budget is as much as it costs on this one...
OK, HP Integrity Sperdome plus an XP12000 will do the job. Cost you about $4,000,000.
>The budget is as much as it costs on this one...
OK, HP Integrity Sperdome plus an XP12000 will do the job. Cost you about $4,000,000.
ASKER
here is the details of the current server.............
OS Name Microsoft Windows 2000 Server
Version 5.0.2195 Service Pack 4 Build 2195
OS Manufacturer Microsoft Corporation
System Manufacturer Compaq
System Model ProLiant DL380 G2
Processor x86 Family 6 Model 11 Stepping 1 GenuineIntel ~1258 Mhz
Processor x86 Family 6 Model 11 Stepping 1 GenuineIntel ~1258 Mhz
Total Physical Memory 1,048,092 KB
Available Physical Memory 18,748 KB
Total Virtual Memory 3,570,148 KB
Available Virtual Memory 1,254,208 KB
Page File Space 2,522,056 KB
OS Name Microsoft Windows 2000 Server
Version 5.0.2195 Service Pack 4 Build 2195
OS Manufacturer Microsoft Corporation
System Manufacturer Compaq
System Model ProLiant DL380 G2
Processor x86 Family 6 Model 11 Stepping 1 GenuineIntel ~1258 Mhz
Processor x86 Family 6 Model 11 Stepping 1 GenuineIntel ~1258 Mhz
Total Physical Memory 1,048,092 KB
Available Physical Memory 18,748 KB
Total Virtual Memory 3,570,148 KB
Available Virtual Memory 1,254,208 KB
Page File Space 2,522,056 KB
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Above assuming you haven't got any external storage like a MSA 30 attached to the current machine that would give more than the 6 internal disks it would have by default of course.
ASKER
thanks guys.
ASKER
The OS for the new server will be Windows 2003 and the databases will be SQL Server 2000, the insertion of the 40million + records each day will be run as DTS packages overnight taking in updates from different data sources text files and other SQL servers.
The current server we have is a windows 2000 server with SQL server 7 running it.
The budget is as much as it costs on this one, the server wanted has to be reliable fast and able to coup with the 40 million plus records being added each day.