pdf Download case study PDF

During the week of December 2nd 2012, performance benchmarks were carried out to demonstrate the scalability of InsFocus BI’s insurance optimized data warehouse model on Microsoft SQL Server 2012. Tests were carried out in MTC (Microsoft Technology Center) in Bangalore, India, by a team of professionals from InsFocus Systems (Israel), Nous Infosystems (India) and Microsoft Technology Center (India).

The results demonstrated that InsFocus BI over Microsoft SQL Server 2012 can be used for very large insurance companies, with up to 100 million policy transactions in their data warehouse.

Preparation

  • Tests were conducted on standard, albeit powerful, Windows servers made available at MTC.
  • Database environment used was SQL Server 2012 Enterprise version using its standard optimization features available off the shelf.
  • Queries were run on three data warehouse sizes, measured in number of policy transactions:
    • L – 4.5 million
    • XL – 23 million
    • XXL – 93 million
  • 12 different InsFocus BI analytic queries of varying complexity levels were run, simulating a variety of reports and queries typical to insurance companies.
  • Tests were run on original line-by-line data with no pre-aggregations – real-world performance could be better.

Results Summary

Test results categorized reports into three groups – Simple, Intermediate and Complex (query times in seconds).

Category

L – 4.5 Million

XL – 23 Million

XXL – 93 Million

Simple

0.5 – 4.4

1.1 – 5.2

2.2 – 12.1

Intermediate

3.3 – 7.4

11.0 – 26.6

20.2 – 59.6

Complex

7.4 – 9.2

31.0 – 41.4

91.9 – 124.1

Performance Benchmarks Chartperformance-benchmarks-chart