Re: Data warehouse hardware

On 24 May 2002 15:08:13 -0700, craywa_at_yahoo.com (M. Brooks) wrote:

Processor speed is important but don't forget about the disk performance. And OS and Hardware that supports a list 1m max io size along with generous strip widths and strip sets.

What is your OS of choice? Fors instance if you are Sun you should be at Solaris 2.8 which eliminates the UNIX Write File lock. Also having Veritas or some LVM to work with your HVM works well.

Key will be your design. If you have a bad design the baddest hardware in the land won't save you.

>Hello,
>
>We are looking at options for hardware for our data warehouse. We are
>projecting the warehouse to be about 5TB after the initial load and
>grow to around 70TB when fully implemented. At this stage I am
>interested in hearing what hardware platforms other folks are using
>for their data warehouses to help us focus our search.
>
>Thanks in advance.
>
>MB
Received on Sat May 25 2002 - 10:28:28 CDT