---
title: "What are the trade-offs of using Azure SQL Database versus a self-hosted SQL Server for ASP.NET Core?"  
description: "What are the trade-offs of using Azure SQL Database versus a self-hosted SQL Server for ASP.NET Core?"  
author: "Austin Dcruz"  
published: 2026-09-17  
canonical: https://answers.mindstick.com/qa/117206/what-are-the-trade-offs-of-using-azure-sql-database-versus-a-self-hosted-sql-server-for-asp-net-core  
category: "Databases"  
tags: ["Azure SQL", "database migration", "performance"]  
reading_time: 1 minute  

---

# What are the trade-offs of using Azure SQL Database versus a self-hosted SQL Server for ASP.NET Core?

## Database Choices in Azure

Deciding between a managed PaaS database and lifting your own SQL Server instance onto a VM changes how you handle backups, patching, and scaling. Both paths work, but the operational burden shifts dramatically.

### Cost and Performance Factors

[Azure SQL Database](https://www.mindstick.com/forum/244/sql) abstracts away the OS layer and handles automated backups, yet you pay per DTU or vCore and hit soft limits on connection pooling. A self-hosted instance on an Azure VM gives you full control over tempdb configuration and linked-server setups, at the cost of patching windows and storage management.

```sql
-- Example: querying Azure SQL Database for current DTU utilization.
-- This helps you decide whether to scale up or switch to a provisioned instance.
SELECT
    name AS database_name,
    CAST(avg_cpu_percent AS DECIMAL(5,2)) AS avg_cpu,
    CAST(avg_data_io_percent AS DECIMAL(5,2)) AS avg_io
FROM sys.dm_db_resource_stats
WHERE interval_id = (SELECT MAX(interval_id) FROM sys.dm_db_resource_stats);
-- If avg_cpu consistently exceeds 80%, consider upgrading the service tier.
```

For most greenfield ASP.NET Core projects, starting with Azure SQL Database and migrating later is cheaper than maintaining a VM from day one. Just watch out for long-running transactions that can throttle your DTU ceiling.


---

Original Source: https://answers.mindstick.com/qa/117206/what-are-the-trade-offs-of-using-azure-sql-database-versus-a-self-hosted-sql-server-for-asp-net-core

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.