Title :
Testing the Performance of an SSAS Cube Using VSTS
Author_Institution :
Microsoft Corp., Redmond, WA, USA
Abstract :
SQL server analysis services (SSAS) is a popular technology, which has been deployed more and more by various BI (Business Intelligence) projects. For a newly designed data warehouse with dimension, cell, and cube, as well as MDX as a query language, it is crucial to benchmark and measure the cube performance. This article will present a method to test the performance of a SSAS cube. Visual Studio Team System (VSTS) will be used as a test platform. A unit test as well as some load and stress tests measure the cube performance under load and stress to ensure a high quality.
Keywords :
SQL; data warehouses; program testing; MDX query language; SQL server analysis services; SSAS cube; business intelligence; data warehouse; load test; performance testing; stress test; unit test; visual studio team system; Automatic testing; Bismuth; Data warehouses; Database languages; Information analysis; Information technology; Performance analysis; Software testing; Stress; System testing; Performance testing; SSAS cubes; software quality; software testing; test automation;
Conference_Titel :
Information Technology: New Generations (ITNG), 2010 Seventh International Conference on
Conference_Location :
Las Vegas, NV
Print_ISBN :
978-1-4244-6270-4
DOI :
10.1109/ITNG.2010.27
