* Posts by remi9898

2 publicly visible posts • joined 16 Apr 2014

Database consolidation is a server gain. Storage vendors should butt out

remi9898

Oracle Database is licensed by core not server, so in your example there is no reduction of license cost. Same total number of cores before and after the server consolidation. Power and cooling are non-linear savings as the new servers are working harder than the old servers. Rack space is saved and sys admin burden reduced. The dba's job is going to be equal or harder post-consolidation.

Storage is part of a server and should always be considered when upgrading or replacing a server. Your points about what differentiates server and storage consolidation are valid, but not exclusive. True, they can be done independently, but they can also be done together.

Storage advances often fuel server migration or consolidation. For example, transactional databases are notorious for wasting CPU cycles while waiting for i/o to complete, and replacing legacy storage with modern low latency storage can dramatically cut cpu utilization and allow for database servers to be consolidated. There is no savings here in terms of database licenses, however, because database vendors like Oracle and Microsoft don't pay refunds.

Fusion-io: Ah, Microsoft. I see there's in-memory in SQL Server 2014... **GERONIMO!**

remi9898

Re: Perhaps I'm misunderstanding what they've done...

Yes, all RDBMS like Oracle keep a history of recent queries and their execution plans, and they also have a sizable block buffer cache in which they store the data fetched from storage into memory. These block buffer caches have algorithms to determine where data is placed in memory upon fetch and how the data will be "aged" out of memory. Without giving you the full 3-day Oracle Performance Tuning lecture suffice it to say these algorithms favor data on disk. If you ever tried to pin all of your tables and indexes in memory you'd notice just a fraction of the data actually stays in memory long term.

Along comes this up-start company saying "we will go ten times faster than Oracle or quit". They developed entirely new logic for keeping data in memory and reducing the communication or synchronization between those in-memory buffers and storage. And so Oracle bought them and offers two completely separate database products: Oracle Database Server, and Oracle TimesTen In-Memory Database. (These will be merging, but that's another story).

Microsoft is expanding its portfolio to match its rivals.