2414702 - Tempdb system tables space continues to grow and has not been cleared out - SAP ASE

• The size of system tables in tempdb or user tempdb continues to grow
• Large size of index for system tables in tempdb
  
  
• Optdiag output shows large number of "Empty leaf page count" pages:
  
  Specified database:                     "tempdb_1"
  ...
  Table name:                               "syspartitions"
  

  Statistics for index:                   "csyspartitions" (clustered)
   Index column list:                      "id", "indid", "partitionid"
        Leaf count:                               1786
        Empty data page count:             136
  

  Statistics for index:                   "ncsyspartitions" (nonclustered)
   Index column list:                      "partitionid", "indid"
        Leaf count:                              1756
        Empty leaf page count:             1195      
  
  Statistics for index:                   "nc2syspartitions" (nonclustered)
   Index column list:                      "id", "indid", "name"
        Leaf count:                              4862
        Empty leaf page count:             48892

• Output from sp_spaceused shows large index sizes:

sp_spaceused syspartitions, 1

index_name           size                reserved
----------------------    ----------------   -----------------
csyspartitions                196 KB          1128 KB
ncsyspartitions        586824 KB      587944 KB
nc2syspartitions    2647056 KB    2647944 KB

• SAP Adaptive Server Enterprise (ASE)  ASE 15.7 & 16.0

1105, tempdb, reorg reclaim_space , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement