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.