Posted by: Colin Smith
The other day I talked about Delphix. I think this is a great product and I have talked about how it can save you, the DBA time and money. You want to save time and make your life easier, as well as save the company money while you do that. It looks good for you to do that and it makes your job so much better. So now I wanted to talk about some use cases, and again I am just hitting the tip of the ice berg. I am sure that you all can think of so many other cases to use this product.
Develpement efforts. How often do your developers want the data refreshed to look like production, or better yet, they want multiple copies of a database to work in. Well with Delphix, you can make all that happen and it is so quick and easy. No matter the size of your source database, after the initial DSource creation, VDB provisioning will take about 5 to 10 minutes. That is so much faster then most refreshes take. You can have multiple copies of the same database for different developers and this costs you almost no disk.
Offloading DBA tasks. If you have a very large SQL Server Database, You know how hard it can be to get maintenance in all the time. Well why not spin up a VDB every night and do DBCC on that copy? No more DBCC running on your production database. When you are done with DBCC you drop it, then you provision again when you need to run it again.
Upgrade testing. I know that I have some 2005 and 2008 databases that I would love to test out in 2012. So why not just spin up a VDB in a 2012 instance and do you testing and have the application teams and users do testing against that VDB.
Emergency production troubleshooting. Many times I get requests to grant developers access into production so that they can troubleshoot an issue that they can not duplicat in DEV or QA for whatever reason. Well I really hate doing that but in some cases I have no choice. Well now I do. I can spin up a VDB from production and say here you go. I do not care if you break it worse and when you have the fix and it is tested, we can move it into prod.
So those are just a few use cases. I am sure that there are many many more. Let me know if you can think of anything you would use this for.