IT/SAP

[SAP HANA] Row Store Table Ratio

SAP_BASIS 2015. 8. 25. 16:39

 

 

 SELECT
  HOST,
  PORT,
  CASE WHEN (((SUM(FREE_SIZE) / SUM(ALLOCATED_SIZE)) > 0.30)
 AND SUM(ALLOCATED_SIZE) > TO_DECIMAL(10)*1024*1024*1024)
THEN 'TRUE'
ELSE 'FALSE'
END "Row store Reorganization Recommended",
  TO_DECIMAL( SUM(FREE_SIZE)*100 / SUM(ALLOCATED_SIZE),
  10,
 2) "Free Space Ratio in %",
 TO_DECIMAL( SUM(ALLOCATED_SIZE)/1048576,
  10,
  2) "Allocated Size in MB",
 TO_DECIMAL( SUM(FREE_SIZE)/1048576,
  10,
  2) "Free Size in MB"
FROM M_RS_MEMORY
WHERE ( CATEGORY = 'TABLE'
 OR CATEGORY = 'CATALOG' )
AND PORT LIKE '%03'
GROUP BY HOST,
  PORT
;

'IT > SAP' 카테고리의 다른 글

SAP Solution Manager SSO  (0) 2015.12.30
1911102 - Solution Manager application logs reorganization  (0) 2015.12.30
Install and Configuration SAProuter via SNC  (0) 2015.07.29
Using hdbalm  (0) 2015.02.10
Uninstall SAP HANA Plugins  (0) 2015.01.27