Overview
This article is designed to be a high-level overview of the Azure components required for a deployment within a production environment. We provide recommended sizing guidance, but it is important to understand that these components can be scaled based on your workloads and needs. The following will assist with preparing your Azure environment:
- Reference Architecture with Azure
- 1. Create Application Server - Azure VM
- 2. Create Project Repository Database - Azure SQL DB
- 3. Create Data Warehouse Database - Azure SQL DB
- 4. Create Azure Analysis Services instance
- 5. Estimating Azure Costs
Reference Architecture with Azure
The visual below depicts the architectural components required for an Azure deployment.
Preparing your Azure environment
The below details each Azure resource required along with recommended sizing. VM and database sizing can and should be adjusted to support the performance objectives of the business.
1. Create Application Server - Azure VM
The application server will host the Jet Data Manager application. This application is the data modeling tool used by developers to build the underlying data structures that will support the business.
Considerations for application server:
- Recommended Sizing: D2s_v3 (for moderate workloads). See: Azure VM Sizes for additional details.
2. Create Project Repository Database - Azure SQL DB
The project repository database is an Azure SQL Databases. This database will contain the project metadata for the application.
Considerations for the project repository database:
Property |
Value |
Purchase Model |
vCore |
Compute Tier | Provisioned |
Service Tier | General purpose |
vCores |
Min 2 vCores |
Data Max Size |
50 GB |
3. Create Data Warehouse Database - Azure SQL DB
The data warehouse is an Azure SQL Database. This database will contain your report ready data.
Considerations for the data warehouse database:
Property |
Value |
Purchase Model |
vCore |
Compute Tier | Provisioned |
Service Tier | General purpose |
vCores |
10 |
Data Max Size |
50 GB |
4. Create Azure Analysis Services instance
Azure Analysis Services is the service that hosts your Semantic models.
Considerations for the Analysis Services instance:
For standard production workloads we recommend starting with an instance of SO, or S1
5. Estimating Azure Costs
Azure provides a pricing calculator to estimate your costs. See: Azure pricing calculator
Comments
0 comments
Article is closed for comments.