Symptom
- Updating statistics on table with 2800 rows with inlined image but some fields overflowing rows takes more than 10 minutes.
- The stack trace of the process running the UPDATE STATISTICS command looks like this:
1> dbcc stacktrace (1138)
2> go
Start dbcc stacktrace...
pc: 0x000000000179ac8f upsleepgeneric+0x52f()
pc: 0x0000000000b2e9b8 getpage_with_validation+0xc88()
pc: 0x0000000000ef3ab7 pg_oamscan_nextpage+0x287()
pc: 0x0000000000bcafbc dol_oamscan_getnext+0x1cc()
pc: 0x0000000000b220e3 getnext+0x403()
pc: 0x0000000001675f05 ups_deadlock_getnext+0x45()
[Handler pc: 0x(nil) installed by the following function:-]
pc: 0x000000000166bbc3 ups_calctabdata+0x6b7()
pc: 0x000000000166000c ups__updstats+0x65c()
pc: 0x0000000001668d2e ups__updstats_driver+0x131()
[Handler pc: 0x0x00000000016bacb0 ut_handle installed by the following function:-]
pc: 0x000000000165f1d0 update_statistics+0x640()
[Handler pc: 0x0x00000000016bacb0 ut_handle installed by the following function:-]
pc: 0x0000000001666622 ups_main+0x372()
pc: 0x00000000012bfa48 s_execute+0xb748()
[Handler pc: 0x0x0000000001368cf0 hdl_stack installed by the following function:-]
[Handler pc: 0x0x00000000012fa650 s_handle installed by the following function:-]
pc: 0x00000000012ffcc8 sequencer+0x2958()
[Handler pc: 0x0x0000000001596574 intsql__handle installed by the following function:-]
pc: 0x0000000001595a49 internal_sql+0x5c9()
pc: 0x00000000012b77aa s_execute+0x34aa()
[Handler pc: 0x0x0000000001368cf0 hdl_stack installed by the following function:-]
[Handler pc: 0x0x00000000012fa650 s_handle installed by the following function:-]
pc: 0x00000000012fffaf sequencer+0x2c3f()
pc: 0x00000000012c56d3 execproc+0x8e3()
pc: 0x00000000012b7efd s_execute+0x3bfd()
[Handler pc: 0x0x0000000001368cf0 hdl_stack installed by the following function:-]
[Handler pc: 0x0x00000000012fa650 s_handle installed by the following function:-]
pc: 0x00000000012ffcc8 sequencer+0x2958()
pc: 0x00000000007ea159 tdsrecv_language+0x1e9()
[Handler pc: 0x0x00000000016bacb0 ut_handle installed by the following function:-]
pc: 0x000000000080bfa0 conn_hdlr+0x1100()
dbcc stacktrace finished.
- This is an SAP BW installation.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE)
- SAP Business Warehouse
Product
Keywords
CR798889, CR#798889, 798889, in-row, inrow, performance , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BW-SYS-DB-SYB , BW on Adaptive Server Enterprise , Bug Filed
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