How Many Tenant Databases Can You Create in SAP HANA?
SAP HANA offers flexible database configurations, but understanding the limits and port allocations is crucial for effective system management. Here's a breakdown:
🔢 Default Tenant Databases Per Instance
Each tenant database requires 3 ports:
⚡ Internal Communication
⚡ SQL
⚡ HTTP via XS Classic Server
Default Port Range: 3<instance>40 to 3<instance>99.
➡️ Total Ports Available: 60
➡️ Maximum Tenants: 20 (60 ports ÷ 3 per tenant)
🛠️ Fixed System Database Port Numbers
These ports are reserved for the system database:
✅ 3<instance>01 (Internal Communication)
✅ 3<instance>13 (SQL)
✅ 3<instance>14 (HTTP via XS Classic Server)
📂 Tenant Database Ports (Auto-Assigned)
Each tenant database gets these ports automatically:
✅ 3<instance>03 (Internal Communication)
✅ 3<instance>15 (SQL)
✅ 3<instance>08 (HTTP via XS Classic Server)
⚙️ Extending Tenant Capacity with reserved_instance_numbers
By adjusting the reserved_instance_numbers property in the global.ini file, you can increase the port range for tenants:
Default (0): Ports 3<instance>40–3<instance>99
Value 1: Ports 3<instance>40–3<instance>199
Value 2: Ports 3<instance>40–3<instance>299
➡️ This allows for more tenant databases per instance!
💡 Pro Tip
Planning to host more than 20 tenants? Ensure your configuration is optimized by updating the global.ini file and managing port allocations effectively.
🔢 Default Tenant Databases Per Instance
Each tenant database requires 3 ports:
⚡ Internal Communication
⚡ SQL
⚡ HTTP via XS Classic Server
Default Port Range: 3<instance>40 to 3<instance>99.
➡️ Total Ports Available: 60
➡️ Maximum Tenants: 20 (60 ports ÷ 3 per tenant)
🛠️ Fixed System Database Port Numbers
These ports are reserved for the system database:
✅ 3<instance>01 (Internal Communication)
✅ 3<instance>13 (SQL)
✅ 3<instance>14 (HTTP via XS Classic Server)
📂 Tenant Database Ports (Auto-Assigned)
Each tenant database gets these ports automatically:
✅ 3<instance>03 (Internal Communication)
✅ 3<instance>15 (SQL)
✅ 3<instance>08 (HTTP via XS Classic Server)
⚙️ Extending Tenant Capacity with reserved_instance_numbers
By adjusting the reserved_instance_numbers property in the global.ini file, you can increase the port range for tenants:
Default (0): Ports 3<instance>40–3<instance>99
Value 1: Ports 3<instance>40–3<instance>199
Value 2: Ports 3<instance>40–3<instance>299
➡️ This allows for more tenant databases per instance!
💡 Pro Tip
Planning to host more than 20 tenants? Ensure your configuration is optimized by updating the global.ini file and managing port allocations effectively.
0 Comments