Abstract
Making changes in production database or changes in database system configuration often requires these changes to be priorly tested in a test system. This also requires to replay the original workload in the test environment by simulating client’s activity on many workstations. In the paper, we show how this task can be realized with the use of many Workload Replay Agents working in Microsoft Azure public cloud. We present model and architecture of widely scalable, cloud-based stress testing environment, called CloudDBMonitor, which allows controlled execution of captured SQL scripts against a specified database in Microsoft SQL Server database management system. The stress testing environment provides the possibility to investigate how the tested database works under a large pressure generated by many simulated clients.
This project was supported by Microsoft Research in USA within Microsoft Azure for Research Award.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Galanis, L., et al.: Oracle Database Replay. In: Proceedings of the 2008 ACM SIGMOD International Conference on Management of Data, pp. 1159–1170 (2008)
Gardikiotis, S.K., Lazarou, V.S., Malevris, N.: An agent-based approach for the maintenance of database applications. In: Proceedings of the 5th ACIS International Conference on Software Engineering Research, Management & Applications (SERA 2007), pp. 558–568 (2007)
Gardikiotis, S.K., Lazarou, V.S., Malevris, N.: Employing agents towards database applications testing. In: Proceedings of the 19th IEEE International Conference on Tools with Artificial Intelligence (ICTAI 2007), pp. 173–180 (2007)
Kumova, B.I.: Dynamic re-configurable transaction management in AgentTeam. In: Proceedings of the Ninth Euromicro Workshop on Parallel and Distributed Processing, pp. 258–264 (2001)
Mell, P., Grance, T.: The NIST definition of Cloud Computing. Special Publication 800-145 (accessed on November 25, 2014), http://csrc.nist.gov/publications/nistpubs/800-145/SP800-145.pdf
Mrozek, D., Małysiak-Mrozek, B., Mikołajczyk, J., Kozielski, S.: Database under pressure - Testing performance of database systems using Universal Multi-Agent Platform. In: Gruca, A., Czachórski, T., Kozielski, S. (eds.) Man-Machine Interactions 3. AISC, vol. 242, pp. 631–641. Springer, Heidelberg (2014)
Mrozek, D., Małysiak-Mrozek, B., Waligóra, I.: UMAP - A Universal Multi-Agent Platform for .NET Developers. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds.) BDAS 2014. CCIS, vol. 424, pp. 300–311. Springer, Heidelberg (2014)
Nambiar, R., Poess, M., Masland, A., Taheri, H.R., Emmerton, M., Carman, F., Majdalany, M.: TPC benchmark roadmap 2012. In: Nambiar, R., Poess, M. (eds.) TPCTC 2012. LNCS, vol. 7755, pp. 1–20. Springer, Heidelberg (2013)
Poteralski, A.: Optimization of mechanical structures using artificial immune algorithm. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds.) BDAS 2014. CCIS, vol. 424, pp. 280–289. Springer, Heidelberg (2014)
Poteralski, A., Szczepanik, M., Ptaszny, J., Kuś, W., Burczyński, T.: Hybrid artificial immune system in identification of room acoustic properties. Inverse Problems in Science and Engineering 21(6), 957–967 (2013)
SQL Server Distributed Replay, SQL Server 2012 Books Online, Quick Reference (June 2012), http://msdn.microsoft.com/en-us/library/ff878183.aspx (accessed on November 7, 2014)
Transaction Processing Performance Council, TPC-C/App/E BENCHMARKTM Standard Specification, http://www.tpc.org (accessed on November 7, 2014)
Virtual Machine and Cloud Service Sizes for Azure, http://msdn.microsoft.com/library/azure/dn197896.aspx (accessed on November 25, 2014)
Waligóra, I., Małysiak-Mrozek, B., Mrozek, D.: UMAP - Universal Multi-Agent Platform. Studia Informatica 31(2A(89)), 85–100 (2010)
What is Azure? http://msdn.microsoft.com/library/azure/dd163896.aspx (accessed on November 25, 2014)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2015 Springer International Publishing Switzerland
About this paper
Cite this paper
Mrozek, D., Paliga, A., Małysiak-Mrozek, B., Kozielski, S. (2015). Database Under Pressure - Scaling Database Performance Tests in Microsoft Azure Public Cloud. In: Kozielski, S., Mrozek, D., Kasprowski, P., Małysiak-Mrozek, B., Kostrzewa, D. (eds) Beyond Databases, Architectures and Structures. BDAS 2015. Communications in Computer and Information Science, vol 521. Springer, Cham. https://doi.org/10.1007/978-3-319-18422-7_6
Download citation
DOI: https://doi.org/10.1007/978-3-319-18422-7_6
Publisher Name: Springer, Cham
Print ISBN: 978-3-319-18421-0
Online ISBN: 978-3-319-18422-7
eBook Packages: Computer ScienceComputer Science (R0)