Analysis of Server Performance with Different Techniques of Virtual Databases
Sonali Vyas · 2014
Database virtualization is understood by different people in different ways; either it is executing or storing databases on virtual machine or a full virtualization of database. It helps in masking the actual physical location of the databases from the programs and users using it. With the aid of virtualization, databases can be decentralized thus increasing availability and usability of databases. But as we step into the world of virtualization, the central requirement becomes performance. It becomes an important task for DBA to provide excellent performance by putting minimum efforts and cost. Performance confines various extensions. A database residing in a virtual machine must act commensurable with the application which is using it. It is also considered that resource sharing between multiple virtual machines running on same host must be effective and efficient. In this paper, the performance criteria on the basis of parameters involved in running queries on virtual databases are discussed and a report is prepared analyzing the results of different tuning techniques.