- configure memory limit for DEV、QAS
目前总内存为1367.19GB,
DEV和QAS为同一数据库
我们将设置DEV为600GB
QAS也为600GB
=================
Create new database S4Q with HANA studio
2175606 - HANA: How to set allocation limit for tenant databases
< SPS11
ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'DATABASE', '') SET ('memorymanager', 'allocationlimit') = '8192' WITH RECONFIGURE;
= SPS11
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'DATABASE', '') SET ('memorymanager', 'allocationlimit') = '8192' WITH RECONFIGURE;
For SPS09, you need to restart HANA database to take effect.
For later SPS, memory alignment will happen on the fly, but take some time. To make it happen immediately, you can restart the database.
To confirm the changes with systemdb connection, you can use SQL query:
SELECT * FROM "SYS_DATABASES"."M_SERVICE_MEMORY";
Alternatively you can check it with column "Allocation Limit(MB)" in Sevices tab under Landspace in HANA studio by logging on to the tenant DB.
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'DATABASE', 'S4Q') SET ('memorymanager', 'allocationlimit') = '600000' WITH RECONFIGURE;
SELECT * FROM "SYS_DATABASES"."M_SERVICE_MEMORY";
- begin t check SR with HANA studio:
reboot SiteA
测试结果:
节点1reboot后,能发生切换,并重启后能自动加入到集群成为备节点
节点2reboot后,能自动加入到集群成为备节点
备节点HDB stop无法停止数据库,能自动起来
主节点HDB stop,主数据库切换到备节点,并SR失效,
---解决方案1. reboot原来的主节点
---解决方案2. 用hdbnsutil -sr_register 注册到新的主节点,并清除管理段::7630下相应的报错