temporary1

SELECT HOST, ROUND(INSTANCE_TOTAL_MEMORY_USED_SIZE/1024/1024/1024,2) AS USED_GB, ROUND(ALLOCATION_LIMIT/1024/1024/1024,2) AS ALLOC_LIMIT_GB FROM SYS.M_HOST_RESOURCE_UTILIZATION;

1. 各服务内存（indexserver/nameserver 等）

 

SELECT

  HOST, SERVICE_NAME,

  ROUND(TOTAL_MEMORY_USED_SIZE/1024/1024/1024,2) AS USED_GB

FROM SYS.M_SERVICE_MEMORY ORDER BY USED_GB DESC;

 

 

步骤 2：查找该 SQL 的活跃连接

-- 查找当前正在执行 9aaf8105 的连接
SELECT
C.CONNECTION_ID,
C.START_TIME,
SECONDS_BETWEEN(C.START_TIME, CURRENT_TIMESTAMP) AS RUNNING_SEC,
C.USER_NAME,
C.CLIENT_HOST,
T.THREAD_ID,
T.STATEMENT_HASH,
T.THREAD_TYPE,
T.THREAD_METHOD,
T.DURATION AS THREAD_DURATION_US
FROM M_CONNECTIONS C
JOIN M_SERVICE_THREADS T ON C.CONNECTION_ID = T.CONNECTION_ID
WHERE T.STATEMENT_HASH = '9aaf8105bdad5308ab706eea28078d28'
OR C.CURRENT_STATEMENT_HASH = '9aaf8105bdad5308ab706eea28078d28'
ORDER BY RUNNING_SEC DESC;

如果上面没结果（因为 Statistics Server 线程可能没有关联 CONNECTION_ID），用：

-- 直接查 Statistics Server 的长时间运行线程
SELECT
THREAD_ID,
CONNECTION_ID,
THREAD_TYPE,
THREAD_METHOD,
THREAD_STATE,
STATEMENT_HASH,
DURATION, -- 单位：微秒
DURATION / 1000000 AS DURATION_S
FROM M_SERVICE_THREADS
WHERE THREAD_TYPE = 'WorkerThread (StatisticsServer)'
OR STATEMENT_HASH = '9aaf8105bdad5308ab706eea28078d28'
ORDER BY DURATION DESC;

记录输出的 CONNECTION_ID（或 THREAD_ID）。

 

-- 在 SystemDB 执行，查看所有租户的内存使用
SELECT DATABASE_NAME, HOST, USED_MEMORY_SIZE/1024/1024/1024 AS USED_GB
FROM SYS_DATABASES.M_SERVICE_MEMORY
ORDER BY USED_GB DESC;

 

 

措施6（监控）：持续观察内存碎片

-- 监控碎片率
SELECT SERVICE_NAME,
HEAP_MEMORY_ALLOCATED_SIZE/1024/1024/1024 AS HEAP_ALLOC_GB,
HEAP_MEMORY_USED_SIZE/1024/1024/1024 AS HEAP_USED_GB,
(HEAP_MEMORY_ALLOCATED_SIZE - HEAP_MEMORY_USED_SIZE)/1024/1024/1024 AS HEAP_UNUSED_GB,
FREE_PHYSICAL_MEMORY/1024/1024/1024 AS FREE_PHYS_GB
FROM SYS.M_SERVICE_MEMORY
ORDER BY HEAP_ALLOC_GB DESC;

 

SELECT sm.SERVICE_NAME, ROUND(sm.HEAP_MEMORY_ALLOCATED_SIZE / 1024 / 1024 / 1024, 2) AS HEAP_ALLOC_GB, ROUND(sm.HEAP_MEMORY_USED_SIZE / 1024 / 1024 / 1024, 2) AS HEAP_USED_GB, ROUND((sm.HEAP_MEMORY_ALLOCATED_SIZE - sm.HEAP_MEMORY_USED_SIZE) / 1024 / 1024 / 1024, 2) AS HEAP_UNUSED_GB, ROUND(hr.FREE_PHYSICAL_MEMORY / 1024 / 1024 / 1024, 2) AS FREE_PHYS_GB FROM SYS.M_SERVICE_MEMORY sm JOIN SYS.M_HOST_RESOURCE_UTILIZATION hr ON sm.HOST = hr.HOST ORDER BY sm.HEAP_ALLOC_GB DESC;

 

 

SELECT sm.SERVICE_NAME, ROUND(sm.HEAP_MEMORY_ALLOCATED_SIZE / 1024 / 1024 / 1024, 2) AS HEAP_ALLOC_GB, ROUND(sm.HEAP_MEMORY_USED_SIZE / 1024 / 1024 / 1024, 2) AS HEAP_USED_GB, ROUND((sm.HEAP_MEMORY_ALLOCATED_SIZE - sm.HEAP_MEMORY_USED_SIZE) / 1024 / 1024 / 1024, 2) AS HEAP_UNUSED_GB, ROUND(hr.FREE_PHYSICAL_MEMORY_SIZE / 1024 / 1024 / 1024, 2) AS FREE_PHYS_GB FROM SYS.M_SERVICE_MEMORY sm JOIN SYS.M_HOST_RESOURCE_UTILIZATION hr ON sm.HOST = hr.HOST ORDER BY HEAP_ALLOC_GB DESC;

 

 

SELECT
SERVICE_NAME,
ROUND(HEAP_MEMORY_ALLOCATED_SIZE/1024/1024/1024, 1) AS HEAP_ALLOC_GB,
ROUND(HEAP_MEMORY_USED_SIZE/1024/1024/1024, 1) AS HEAP_USED_GB,
ROUND((HEAP_MEMORY_ALLOCATED_SIZE - HEAP_MEMORY_USED_SIZE)/1024/1024/1024, 1) AS HEAP_UNUSED_GB
FROM SYS.M_SERVICE_MEMORY
ORDER BY HEAP_ALLOC_GB DESC;

 

Archive Verification

The SAP archives are signed with digital signatures. Mark the checkbox below if you want to check the authenticity of all the archives in the download directory. In addition, you can download the Certificate Revocation List from here and provide it in the download directory, if you want to perform an additional check for revoked signatures.

For more information, see in the SUM guide the chapter "Verifying SAP Archives".

Check the authenticity of SAP archives.

 

https://help.sap.com/docs/ABAP_PLATFORM_NEW/77b3972f873044acb3a70258f3984c64/47c56a6938fb2d65e10000000a42189c.html?locale=en-US

 

 

Prerequisite up-to-date SAP Note 2972792 for Financial Data Quality is not installed.

Character String as Message