database performance, sql tuning and data visualization
Tuesday, December 28, 2010
Delphix deals before the end of year
It's let's make a deal time at Delphix. If you have ever had the fun of closing an Oracle deal at their fiscal year end, you know what happens. Not only is it fiscal year end but Delphix is also millimeters away from adding an extra figure to their end of quarter total and I'm betting that now is the last time these low of prices will ever be seen - just my view point from being inside the castle.
I'm not sure if you can imagine the ease and savings of virtualizing databases
1)Super fast provision – three clicks and a few minutes to stand up a fully functional, point-in-time 10g/11g database copy/clone
2)Storage savings- a new database copy basically only consists of some pointers and the space it takes for private redo and temp
Delphix doesn't require filesystem snashots or EMC or NetApps. It only requires x86 box with about the same amount of the disk space of the database you want to virtualize. The source database is copied onto the Delphix machine with RMAN calls, the data is compressed and Delphix handles the snapshots and provisioning of virtual databases. Virtual database can be provisioned from the original source copy, or any incremental snapshot or if log shipping is used, then any SCN or date in between. Then you can make as many copies as you want, with in reason, for almost free in terms of storage.
If you are a departmental head and some extra budget that will be lost at year end then Delphix is a good way to use that budget.
For these cut rate deals, everything has to be in by Friday at the absolute latest. For best info contact
This idea is being harnessed by more and more companies across different industries - we've be implemented this at Shopping.com (part of ebay), Tivo (consumer tech), Corporate Express (retail), Tagged (social networking), Clearwire (telcom), KLA Tencor (hardware), Holland America (travel) .
When I talk to customers who don't have development or QA copies of production I cringe. Usually developers work on subsets of production and often query performance on these subsets don't reflect the performance in production. Even if production is a full copy of development there is often just one copy shared by all the developers and QA. Any change to this copy has to go through a number of hoops and signoffs which slows down the development process and de-motivates developers. I don't know if you can imagine having a copy per developer of production where each developer can make and test as many changes as fast as they want on an exact copy of production - it's awesome and inspires the developers. After the developers are confident of there modifications then they can submit the final change request for review.
Delphix makes all of this easy with no changes on production and creation of virtual databases just a few clicks of a mouse in GUI .
Before working at Embarcadero I redesigned the performance pages in Oracles OEM 10g (see a before and after example). I am on the patent from the team for our tuning methodology (Patents: 20060059205) . I freely provide graphical monitoring tools such as ASHMON (TCL/TK) as well as scripts to profile database load such as S-ASH ie Simulated ASH (PLSQL). S-ASH, ASHMON and more are available at my old site http://ashmasters.com/ . I have made available C code to directly read profiling data out of Oracle's memory structures, called Direct Memory Access. I speak at conferences and give classes around the world.This blog has some of my new ideas on Visual SQL Tuning (VST), work on DB Optimizer, possibly some past material on DB performance monitoring as well as lots of references and pointers to other information on the web that I find important and worth emphasizing.