Symptom
The dbcc checkstorage command for a very large database is not completing.
When checking the cmd field using sp_who, it shows as COMPILING.
Running dbcc stacktrace against the spid shows mem_freepages freeing memory for the procedure cache.
sp_who (extract):
spid kpid status cmd
------ ----------- ------------ -----------
123 1234567890 background COMPILING
dbcc stacktrace:
Start dbcc stacktrace...
pc: 0x00000000016221bc upyield
pc: 0x000000000152f308 mem_freepages
pc: 0x0000000001ae17e4 free_mempage
pc: 0x0000000001ae1c3f free_memchunk
pc: 0x0000000001c50a80 s_chooselocks
pc: 0x0000000001c3f918 s_compile_stmt
pc: 0x0000000001c3a43f s_compile
...
Read more...
Environment
SAP Adaptive Server Enterprise 16.0
Product
Keywords
CR830358, CR#830358, 830358, COMPILING, mem_freepages, mempmctrl_free , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview