Hey everyone, I'm mostly an AWS person but my new project uses Azure. I'm trying to set up a small database for an internal dashboard that also needs to run some weekly analytical queries.
I've used AWS Aurora for this before, but now I'm looking at Azure SQL Database. The documentation mentions it can handle both OLTP and "lightweight analytics." What does "lightweight" actually mean in practice?
Has anyone here tried running analytical queries (like aggregations, GROUP BY on decent-sized tables) directly on Azure SQL Database? How was the performance? Did you have to do anything special with indexing, or did you just run the queries?
Also, coming from Terraform, my config for a basic one looks like this:
```hcl
resource "azurerm_sql_database" "main" {
name = "myappdb"
resource_group_name = azurerm_resource_group.main.name
location = "East US"
server_name = azurerm_sql_server.main.name
edition = "Standard"
requested_service_objective_name = "S2"
}
```
Would I need to change the edition or objective for analytical workloads, or is scaling up the DTU/s vCore thing the main lever? Any gotchas?