Tuning your systems for migration to BW 7.3:

Q&A with BI experts Joerg Boeke & Raymond Busher
September 13, 11:30-12:30 ET

How can you not only maintain your data performance but also enhance it in the migration to BW 7.3? What are the big performance hits to avoid when making the move to 7.3?

Register today for this exclusive Q&A on Thursday, September 13, 11:30-12:30pm ET with BI experts Joerg Boeke and Raymond Busher here in a one-hour online Forum. Post your questions and get advice on tuning your BW system for migration to 7.3!

Joerg Boeke and Raymond Busher of BIAnalyst will take your questions on September 13 from 11:30-12:30 ET here in the BI-BW Forum.  

Bonus download: Register  to also receive an excerpt from Joerg Boeke’s BI 2012 session  “A Technical Guide to SAP NetWeaver BW Landscape Optimization.” (Look for the download link in your confirmation email.)

Have a question now? To post an advance question, first log in to Insider Learning Network, then select the “Post Reply” button below. (Note: To participate in this exclusive live Q&A you must be a member of Insider Learning Network - join today for free.)

Moderated by Bridget Kotelly, Conference Producer, BI 2012 – Las Vegas, Milan, Singapore

Sponsored by 

At BI 2012, Joerg, your sessions on performance tuning have always included some great tips for BW teams wherever they were in the adoption cycle. But when prepping for a 7.3 upgrade, which one or two of these tips especially apply? 

Sep 13, 2012 -- 11:39AM, joergboeke wrote:

Sep 13, 2012 -- 11:31AM, BridgetKotelly wrote:

At BI 2012, Joerg, your sessions on performance tuning have always included some great tips for BW teams wherever they were in the adoption cycle. But when prepping for a 7.3 upgrade, which one or two of these tips especially apply? 

Well one of the biggest issues is to clean up the system before mifration / upgrade in development consolidation & production.

Especially the report SAP_DROP_TMPTABLES ( SE38) to drop all temporary tables in memory.

Most time customers try to find the stalling tables in DB and waste a lot of hours to spot such tables.

I recommend to schedule this report for weekly execution even without upgrade, just runing your BW

Hey Joerg that is correct, but don't forget to do it on all systems, development, integration and production. We had the case that this was forgotten on the integration system, und the upgrade stalled there until the tables could be cleaned up.

Also there are many other checks in the update documentation from the SAP that can be done beforehand, and must not necessarily wait until the upgrade process begins.

Good afternoon Joerg & Raymond,

what precautions we have to take with delta queue

in source system during upgrade?

Thanks,

Anil

Sep 13, 2012 -- 11:46AM, Dave Hannon wrote:

Thanks for joining us Joerg. I'll throw the HANA question out there. What should companies consider when upgrading BW 7.3 if they think SAP HANA might be in their future--but they're not sure yet (a position a lot of companies may be in) 

Thats a good question.

Thinking of upgrading to 7.3 will open the door for HANA.

There is no need to directly convert your DB to HANA technology.

Even without HANA 7.3 will bring a bunch of performance gains in loading data.

Especially the semantic DSO are a great use in case having huge data amounts