Table of Contents

Search

  1. Abstract
  2. Supported Versions
  3. Informatica® Big Data Management 10.2.1 on Microsoft Azure: Architecture and Best Practices

Informatica® Big Data Management 10.2.1 on Microsoft Azure: Architecture and Best Practices

Informatica® Big Data Management 10.2.1 on Microsoft Azure: Architecture and Best Practices

Sizing: SQL Database VM Instances

Sizing: SQL Database VM Instances

This section describes several considerations and recommendations for configuring VMs dedicated to SQL databases.
SQL databases are required to contain the domain repository, the Model repository, the monitoring Model repository, and the Hive metadata repository.
Azure SQL databases are categorized as Basic, Standard, or Premium. These categories are based on database transaction units (DTU). Higher DTU means higher performance, as well as higher cost. You should balance performance needs with your budget.
The following table shows a range of Standard instances:
Instance Level
DTU
S1
20
S2
50
S3
100
S4
200
S5
400
Standard DB instances, which are available in a range of instance sizes, will suit most of your needs. For I/O-intensive workloads, you can scale up to a Premium DB type.
The following table lists the minimum DTU requirements for the VM on which each repository database resides:
Repository
Sandbox
Basic
Standard
Advanced
Domain
50
50
100
200
Model
100
200
400
800
Monitoring
100
200
400
800
Hive metadata
50
50
100
200

0 COMMENTS

We’d like to hear from you!