An IQ service that almost always provides a dramatic result story
It’s time to share some results from the design and deployment service for SAP Sybase IQ. This service is designed to help customers plan, implement and optimize an end-to-end business intelligence solution, ensuring the customer is maximizing their investment in the SAP Sybase IQ (IQ) product.
- As an example of great metrics, in one delivery of this service, the customer deployed IQ with our consultants’ guidance in planning, design of the data model, and implementing their business queries. This customer saw a reduction by 30% in their data storage space and reduced typical query response times from 40 minutes to just 13 seconds.
- Another example of metrics results is where the delivery of this IQ service assisted a customer re-vamp their system by implementing SAP products to reduce data warehouse load time from 3 DAYS to 3 HOURS.
- An example of the great story: the customer said, after a SAP database consultant guided them through a completely new data warehouse and developed analytical reporting capabilities in just 8 weeks using this service, “This was probably one of the fastest data warehouse implementations in history.”
As I’ve mentioned in previous entries on this blog, sometimes the results of our services are described with very numerical language with lots of statistics about system availability, query response times, and hardware usage as in these 2 results but sometimes it’s just a great story of how pleased the customer is with the service.
Three Dramatic results – yes?
Are you missing out on an opportunity for a SAP Services expert to help you get a business intelligence or analytics solution in place and enjoy the sort of dramatic results other customers are experiencing?
If you are enjoying this blog, I recommend that you investigate the blogs of my colleagues. You can find a consolidation of links at Database Services Content Library
Great stories - thanks! I wanted to also share a recent PoC effort where a customer in South Africa tested the new SAP Sybase IQ 16 release in comparison to the previous 15.4 release as it relates to ingest (load) rates. They found that while IQ 15.4 achieved a respectable 505,000 rows per second on a 40-core HP DL class system, IQ 16 blew that number away loading an aggregate 12.3 MILLION rows per second on a larger 60-core HP DL class system. Perhaps not so obvious, this was a highly parallelized load that may not bear much resemblance to every production system but it was a fascinating result nonetheless.
I would highly encourage our services colleagues to explore how this extreme capability could be leveraged for our customers' success.