SQL Server 2022 Standard Edition on Azure VM
We want to deploy our data warehouse that uses SQL Server 2022 Clustered ColumnStore Indexes on a VM with Sql Server 2022 Standard and we don’t know which Azure instance type (series) is better for our requirements where we have :
- Jobs that run every 1 minute to add data.
- Reports running on Clustered Column Index tables for 15 users for 8-12 hours per day with computations.
Our annual size in database is about 20GB (clustered column index tables)
Since this is our first project with this technology it is unknown for us which instance type (series) to use
Any suggestion would be highly appreciated.
Thanks in advance
Read more here: Source link
