i ain't jerking around... serious stuff...
the Tera RAMSAN, how much is that going for?
the clients want us to improve the performance and I/O is one of our biggest bottlenecks. To clients if processing data [~1TB which they don't care how big] takes over couple of hours, it is slow and inefficient. Currently we are running things that take over 19+ hours of processing. So that basically ties up a day. And that needed to be redone due to some changes, you can see how this would get on their nerves. This is a financial institute, so time is money.
Let me give you more information as to why I have posted this request:
There is a company named Netezza, who is pitching one of their products, 8050, at us. This is a pure Database Storage solution, end to end [hardware to software specifically designed]. The performance #s look good, but we want something to compare against. From the concept of the product, I can say that what they have done applied the clusters concept and minituarized it.
The Cons of the system are: properitary software and hardware; No programmable query processing support [PL/SQL, ...] ie only SQL'92 support; is only meant as a database solution which only solves portion of the problem as there are other time consuming processing needed to be done.
The Pros of the system are: Simple clusters high performance database solution.
I am trying to pitch to my manager that it would make more sense into buying a storage cluster or similar products to improve our I/O performance and this will affect all the components we run, ie not just the DB component. Basically I am vouching for 65% budget spent on a storage cluster and 35% of the budget spent on the processing power, ie memory and cpu.
so $227,500 for storage cluster; $122.5 on processing power and well this would also need to pay for software and other hardware.