Hey all,
Context
We are a small utility company with 3000 km pipes and are migrating to ArcGIS Utility on ArcGIS Enterprise. We need an Enterprise Geo Database running on Azure SQL Database. Currently we are trying to configure the right size for the Azure SQL Database. We heard from other ArcGIS Utility users that they use a SQL database with 8 vCores and 96GB memory.
We would prefer a stable database (Provisioned option and not Serverless option) to keep performance high all the time. Serverless is probably too slow to scale up quickly when you want to do a large network trace? For data storage in SQL Database we expect 500GB.
SQL database options
1) General Purpose (GP_Gen5_18)
- Specs: 18 vCores with 91,8GB memory.
- Price compute: 1699 per month including 37% discount from Visual Studio license (Visual Studio License is 45 euro per month). Total price: 1744 euro per month
- Price storage: 0,10 euro per GB * 500 GB = 50 euro per month
- Total price: 1794 euro euro per month
2) Hyperscale with memory optimized (HS_MOPRMS_10)
- Specs: 10 vCores with 102GB memory.
- Price compute: 1576 euro per month. Total price: 1576 euro per month
- Price storage: 0,23 euro per GB * 500 GB = 115 euro per month
- Total price: 1691 euro euro per month
Question
Currently we are thinking of going for option 2 with hyperscale Azure SQL Database for EGDB? Do other people have experience what SQL database size/type for EGDB works well with ArcGIS Utility?
