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.