Symptom
- 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: 136Statistics 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
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) ASE 15.7 & 16.0
Product
Keywords
1105, tempdb, reorg reclaim_space , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.