This session explores key considerations in a consolidation project and common oversights that derail the project.
The consolidation of these databases can be achieved in several ways.
But here are some general guidelines on how to accomplish this task by using Exadata in the most optimal way in order to maximize cost reduction, high availability, secure separation of administrative duties and ease of performance tuning, management and monitoring.
Looking for best practice advice for a sprawling network. The practice has been to just stand up a new VM instance any time a database was needed or add a new SQL instance for every database.
The administration challenge is huge so was hoping to hear some feedback on approach.
Each vendor you talk to claims they have the best solution and/or technology for SQL Server consolidation while others are just selling snake oil. What exactly is the relationship between consolidation and virtualization? If so, then why are there so many different technologies, each employing different strategies?
Should I get the biggest server or build a server farm?It is really surprising how slowly companies adopt database consolidation granted the pressure IT management has in every possible direction.We can speculate for hours why so, but what I will concentrate on, are the technical aspects of Exadata consolidation.Storing trend data makes it possible to report on trends in users' Internet activity throughout the course of a day, week, or longer period, but storing trend data increases the size of the Log Database.The longer the data is stored, the greater its effect on database size.Titus Maccius Plautus, a roman poet and philosopher who lived from 254 BC to 184 BC, said: “Wisdom is not attained by years, but by ability”. Corporate IT departments would not surprise anyone if they support a couple of thousand databases.