BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Sunset Ride 
Sunset Ride 

General Notice: BOB is going to retire...please see details here. All BOB forums have been converted to "read only" as of September 1st.
General Notice: No events within the next 45 days.

How many PROD repositories?

Search this topic... | Search DI: Performance and Tuning... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Author Message
Senior Member
Senior Member

Joined: 07 Dec 2007

Posts: 67

PostPosted: Wed Jul 17, 2019 3:22 am 
Post subject: How many PROD repositories?

Does anyone know what SAP recommends as the number of PROD repositories? Or what factors should be considered when choosing the number and separating the Jobs?

At present the support team have roughly one repository per business project and it’s caused some change control problems e.g. duplicated code objects with different behaviours and slow roll-outs because shared changes have to be applied to multiple repositories.

I’ve suggest they rationalise down to one repository in tandem with a version control initiative, but I don’t know if this represents a performance risk.

All of the repositories are currently hosted on the same DB, so the change would be moving their rows from multiple schemas into one schema, resulting in a bigger repository with bigger tables taking longer to query. But I don’t know how to quantify this risk, i.e. is repository size a big problem if you’re not going to open the repository in Designer?

I assume when a Job runs it queries the repository once and then runs with all of the subsequent overhead placed on the Job server process. Does that mean the only side effect of a big repository is a slower start time for Jobs?
My final option seems to be practical experimentation to see how the size of the repository affects performance, but if there’s guidance or advice I’m always interested to know.

Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Performance and Tuning  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0365 seconds using 17 queries. (SQL 0.0118 Parse 0.0008 Other 0.0239)
CCBot/2.0 (
Hosted by | Terms of Service
phpBB Customizations by the
Shameless plug for Moments of Light Logo