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

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: No events within the next 45 days.

CMS Server - BI 4.2 SP6 Environment


 
Search this topic... | Search XI Server Discussion... | Search Box
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades -> XI Server Discussion  Previous TopicPrint TopicNext Topic
Author Message
MIUSA
Principal Member
Principal Member



Joined: 30 Apr 2011

Posts: 287



PostPosted: Thu Mar 21, 2019 11:23 am 
Post subject: CMS Server - BI 4.2 SP6 Environment

Hi, All

We are on BI 4.2 SP6. Database(CMS & Reporting) is Sql server 2012. We have enough memory/CPU/disk space on Production env(clustered) and separate file server and CMS server.

On BI CMS server(4.1 CMS DB+4.1 Audit DB+4.2 CMS DB+4.2 Audit DB), we have 8GB of memory, out of which 6.8 gb memory is in used as per Task manager, Virtual Machine, Virtual Processors is 2.: 1. Checking to see will there be any issues with these configuration going forward. 2. Any recommended(best practices) changes need to be done in above configuration.

We have decommissioned BO 4.1 env(Dev, Prod env).

Thank you for the help!.
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6590
Location: Connecticut, USA


flag
PostPosted: Thu Mar 21, 2019 1:19 pm 
Post subject: Re: CMS Server - BI 4.2 SP6 Environment

Are you asking if 8GB will be enough to run BI4.2? The minimum required according to the PAM is 16GB.
Back to top
MIUSA
Principal Member
Principal Member



Joined: 30 Apr 2011

Posts: 287



PostPosted: Thu Mar 21, 2019 3:04 pm 
Post subject: Re: CMS Server - BI 4.2 SP6 Environment

Our BI 4.2 have Prod(Clustered): 96GB, Dev(24GB) memory available but checking best practice configuration for BI CMS database(separate server) which holds metadata for CMS/Audit database.
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6590
Location: Connecticut, USA


flag
PostPosted: Thu Mar 21, 2019 6:01 pm 
Post subject: Re: CMS Server - BI 4.2 SP6 Environment

Oh, you're asking about the space required for the database? The CMS isn't much, maybe a couple GB. Audit size will depend greatly on the volume of usage, and it will grow with time.
Back to top
JohnBClark
Forum Enthusiast
Forum Enthusiast



Joined: 27 Mar 2007
ASUG Icon
Posts: 1033
Location: Appleton, WI USA


flag
PostPosted: Fri Mar 22, 2019 8:29 am 
Post subject: Re: CMS Server - BI 4.2 SP6 Environment

MIUSA wrote:
On BI CMS server(4.1 CMS DB+4.1 Audit DB+4.2 CMS DB+4.2 Audit DB), we have 8GB of memory, out of which 6.8 gb memory is in used as per Task manager, Virtual Machine, Virtual Processors is 2.
It will, of course, depend on your usage.

Our Server Team/Database Team has only allocated 4 GB of RAM and 2 CPU cores (also virtual) for our database server. I can't say that we have had issues with it. I also can't say that our system might perform better if we had more.

If you go through the sizing exercises, it may recommend more memory than that, I know ours does. Documentation from the vendor isn't good enough for us to get more though.

_________________
BusinessObjects BI4.2sp4, SQL Server 2016 (CMS)
Clustered for fail over redundancy
Reporting Tools: Crystal Reports 2016sp4, Web Intelligence
Operating System: Windows 2016 running on VMWare
Reporting databases: SQL Server, Teradata, DB2, Oracle, Hive
Information Steward 4.2sp10
History: BO5, BO6, XIR2, XI3.1, BI4.1.x
Back to top
MIUSA
Principal Member
Principal Member



Joined: 30 Apr 2011

Posts: 287



PostPosted: Fri Mar 22, 2019 8:56 am 
Post subject: Re: CMS Server - BI 4.2 SP6 Environment

Thank you for the response. Currently, we are not experiencing any issues in BI platform, but since more memory(7GB) is been consumed at CMS server level. Checking on information on how to avoid future issue if allocated memory(8GB) is fully be in use.

I'll also look into sizing documentation.
Back to top
richardcottave
Principal Member
Principal Member



Joined: 30 Mar 2006

Posts: 298



PostPosted: Fri Mar 22, 2019 10:56 am 
Post subject: Re: CMS Server - BI 4.2 SP6 Environment

JohnBClark wrote:
MIUSA wrote:
On BI CMS server(4.1 CMS DB+4.1 Audit DB+4.2 CMS DB+4.2 Audit DB), we have 8GB of memory, out of which 6.8 gb memory is in used as per Task manager, Virtual Machine, Virtual Processors is 2.
It will, of course, depend on your usage.

Our Server Team/Database Team has only allocated 4 GB of RAM and 2 CPU cores (also virtual) for our database server. I can't say that we have had issues with it. I also can't say that our system might perform better if we had more.

If you go through the sizing exercises, it may recommend more memory than that, I know ours does. Documentation from the vendor isn't good enough for us to get more though.


We also have only 4GB allocated to the CMS db and FRS server. Yes I know SAP does not recommended running CMS and FRS on the same machine but it's working pretty well for us and they are on separate drives.
consistently uses about 3.6 GB.
Back to top
MIUSA
Principal Member
Principal Member



Joined: 30 Apr 2011

Posts: 287



PostPosted: Fri Mar 22, 2019 12:02 pm 
Post subject: Re: CMS Server - BI 4.2 SP6 Environment

Thank you for the information. Really helpful.
Back to top
Hayden_Gill
Forum Associate
Forum Associate



Joined: 15 Aug 2002

Posts: 620
Location: Brisbane, Australia


flag
PostPosted: Thu Apr 11, 2019 8:11 pm 
Post subject: Re: CMS Server - BI 4.2 SP6 Environment

I think you are saying that you are running SQL Server 2012 with CMS and Audit databases, on the same machine that the BO CMS service is running.

Best practice would be to have a dedicated DB server.

SQL Server will consume as much RAM as it has available, so that it can buffer 'hot data' to memory for performance. Therefore your CMS is clashing for memory resource with SQL Server.

This obviously depends on how much work your system is seeing, and performance may well be acceptable as is.

_________________
Hayden Gill
Associate Director, BI
The University of Queensland
Brisbane, Australia
http://pbi.uq.edu.au
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Server Administration, Installation, Upgrades -> XI Server Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

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

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0299 seconds using 17 queries. (SQL 0.0033 Parse 0.0009 Other 0.0257)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo