> We've created a sapdb which handle 500 transations per second > (combination of inserts/updates/deletes) it handles it for > about 15-20 minutes and then freezes with no error messages. > We've verified that we have not run out of disk space, dev > space, log file space, memory and cpu usage.
- Which version are you using (7.3 or 7.4)? - what's the output of "dbmcli -u <controluser,controlpw> <SID> show active" when the DB 'hangs' The only thing I can imagine (beyond a software bug) is some deadlock that's not detected or you're running out of DB locks. Is there something in knldiag or knldiag.err when it's hanging? > Is there a limitation on how many (simple -- no joins) > transactions per second can be applied? We need to get it up > to 2000 per second. We've only started testing with sapdb > and have limited knowledge of the parameters. There's nothing like a "soft limit". It depends on how you have built your DB, how many devspaces you have (one big or several little ones), how big your DATA_CACHE/CACHE_SIZE is and other things. Can you sum your config here, probably someone has some ideas what you can try. Greetz, SIEGENIA-AUBI KG Informationswesen i.A. Markus D�hr SAP-CC/BC, SAPDB-DBA Tel.: +49 6503 917-152 Fax: +49 6503 917-7152 E-Mail: [EMAIL PROTECTED] Internet: http://www.siegenia-aubi.com _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
