Today’s IT departments are under increasing pressure to reduce operational and capital costs, while still providing a high level of service to their user communities. Data centers must be efficient in their use of available hardware resources, be resilient to system outages, and adaptable to changing business needs and an evolving technology landscape. For all these reasons, virtualization of enterprise applications and databases is more critical than ever. Virtualization has the following characteristics, which provide a variety of benefits:
VMWare vSphere is the industry’s leading virtualization platform. SAP Sybase IQ is SAP’s extreme scale analytics database that can handle petabyte scale data sets, a large number of concurrent users, and ad hoc queries with impressive performance. VMWare and SAP recently joined forces to test SAP Sybase IQ 15.4 Multiplex on VMWare vSphere 5.1. Multiplex is IQ’s grid deployment option for massive parallel processing utilizing a shared everything architecture. The testing methodology was designed primarily to validate functional correctness of IQ in a virtual environment. Additional testing down the road will focus on optimizing performance. Although performance was a secondary goal, performance differences between running IQ on a physical machine and running IQ on a virtual machine were measured. The test results were very positive. IQ performed correctly, and with minimal degradation in a virtualized environment. Here are some highlights of the test:
o Note: TPC-H was used only to provide a standard set of data and queries. This IQ/vSphere validation test was not audited by the TPC-H council (see: http://www.tpc.org/tpch/ for more information on the TPC-H benchmark).
o Load: load all the data for the TPC-H tables
o Power: perform a sequential run of TPC-H queries
o Throughput: perform a run of TPC-H queries in parallel
With the technology trends of large CPU and memory systems, data center efficiency and resiliency, and cloud computing, SAP Sybase IQ users will be happy to learn that IQ Multiplex can be deployed successfully to VMWare’s virtualized infrastructure. To learn more, here is a link to VMWare’s white paper documenting the validation test: http://scn.sap.com/docs/DOC-42439
Courtney Claussen | SAP Sybase IQ Product Management | Email: courtney.claussen@sap.com
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
40 | |
25 | |
17 | |
13 | |
8 | |
7 | |
7 | |
7 | |
6 | |
6 |