EUVIMEDEUVIMED entdecken
Open Access · CC BY 4.0

Performance Evaluation of On-Premise SQL Server and Azure SQL Database Using a .NET 8 E-Commerce Application

Ahmed Jawad Kadhim, Tayseer S. Atia

Computers · 24.07.2026 · 15 (8) · 469

DOI: 10.3390/computers15080469 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Computers, online erschienen am 24.07.2026. Verfasst von Ahmed Jawad Kadhim und 1 weiteren Autor:innen. Die Arbeit nennt 36 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

Empirical comparisons between cloud-based and on-premise database deployments under realistic e-commerce workloads remain limited. This study presents a controlled experimental evaluation of Microsoft SQL Server 2022 (on-premise) versus Azure SQL Database, using an identical .NET 8 e-commerce application (ASP.NET Core Web API, Blazor WebAssembly) with the same architecture, schema, and dataset (5000 product records, 10,000 transaction records). Performance was evaluated for SELECT, INSERT, UPDATE, and DELETE operations under workloads of up to 50 concurrent users, with each operation repeated 30 times, measuring query response time, throughput, and CPU utilization. Statistical analysis used repeated-measures ANOVA with Greenhouse–Geisser correction, Bonferroni-adjusted post hoc comparisons, and independent-samples t-tests (p < 0.001), with effect sizes reported using Cohen’s d. Azure SQL Database consistently outperformed the on-premise deployment: average SELECT response time decreased by 55% (203.5 ms vs. 452.3 ms), and throughput increased by 101.6% (987.6 vs. 489.8 operations/s). Although Azure showed higher average CPU utilization (20.4% vs. 4.9%), this reflects its dynamic resource allocation rather than reduced efficiency. Stress testing with 100,000 product records, 500,000 transaction records, and up to 500 concurrent users confirmed Azure’s superior scalability, reducing peak latency from 4850.7 ms to 580.4 ms. These findings provide strong empirical evidence supporting cloud migration for high-transaction e-commerce applications requiring low latency and high throughput.

Zitieren

APA

Kadhim, A. J., & Atia, T. S. (2026). Performance Evaluation of On-Premise SQL Server and Azure SQL Database Using a .NET 8 E-Commerce Application. Computers, 15(8), 469. https://doi.org/10.3390/computers15080469

Vancouver

Kadhim AJ, Atia TS. Performance Evaluation of On-Premise SQL Server and Azure SQL Database Using a .NET 8 E-Commerce Application. Computers. 2026;15(8):469. doi:10.3390/computers15080469

BibTeX
@article{Kadhim2026,
  author = {Kadhim, Ahmed Jawad and Atia, Tayseer S.},
  title = {Performance Evaluation of On-Premise SQL Server and Azure SQL Database Using a .NET 8 E-Commerce Application},
  journal = {Computers},
  year = {2026},
  volume = {15},
  number = {8},
  pages = {469},
  doi = {10.3390/computers15080469}
}
Kostenlos starten →