Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

New Primavera 17.12.1 set-up with SQL 2014

9 replies [Last post]
Tue, 2018-07-17 07:53
Morne Johann Bees...
User offline. Last seen 9 weeks 4 days ago. Offline
Joined: 25 Feb 2016
Posts: 16
Groups: None

Hi all,

I am installing Primavera PPM V17.12.1 with SQL 2014 Express database on our company server.

Q1: Is this a workable longterm solution. Will the Express SQL DB be able to handle a large program of projects over the long term? 

Q2: Any specific issues users have found in setting this up?

Q3: Bandwidth requirements?

Thank you for any relevant responses.

Morné

Top

Replies

Fri, 2018-08-17 12:47
#1
Zoltan Palffy
User offline. Last seen 3 weeks 4 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

Steve you are correct the limt has increased fom 4 gigs to 10 gigs

Top
Fri, 2018-08-17 11:48
#2
Steven Auld
User offline. Last seen 6 weeks 2 days ago. Offline
Joined: 13 Sep 2017
Posts: 126
Groups: Petro-Chem / Oil & Gas, TURNAROUND & SHUTDOWN (T/A & S/D)

Zoltan,

The original post related to the Express version, so all comments were based only on the Express Edition of SQL Server.

The data limits you have mentioned are for the Full SQL Server Versions.

Agree that only Express is limited to 10 GB, but this is higher than the original 4 GB limit on the express editions up to SQL Server Express 2008.

Steven

Top
Mon, 2018-08-13 13:33
#3
Zoltan Palffy
User offline. Last seen 3 weeks 4 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

10 gig is only for express not the full blown express look at the standard column

Maximum memory utilized (per instance of SQL Server Database Engine) standard 128 Gig

Maximum memory utilized (per instance of Analysis Services) 64 gig 

Maximum memory utilized (per instance of Reporting Services) 64 gig

Maximum relational Database size 524 PB 

Top
Thu, 2018-07-19 18:26
#4
Steven Auld
User offline. Last seen 6 weeks 2 days ago. Offline
Joined: 13 Sep 2017
Posts: 126
Groups: Petro-Chem / Oil & Gas, TURNAROUND & SHUTDOWN (T/A & S/D)
Zoltan,
Please see the table “Cross-Box Scale Limits” in the following link:
https://docs.microsoft.com/en-us/sql/getting-started/features-supported-...
Maximum relational Database size = 10GB
All 3 versions of Express are quoting 10GB limit.
In Wikipedia, it indicates that anything from SQL Server Express 2008R2 onwards had the limitation increased to 10GB.
Steven
Top
Thu, 2018-07-19 11:56
#5
Zoltan Palffy
User offline. Last seen 3 weeks 4 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

are uo sure about that for slq EXPRESS the oracel slq is 10G but I dont think that the microsoft sql express is can you confirm please

Top
Wed, 2018-07-18 19:55
#6
Steven Auld
User offline. Last seen 6 weeks 2 days ago. Offline
Joined: 13 Sep 2017
Posts: 126
Groups: Petro-Chem / Oil & Gas, TURNAROUND & SHUTDOWN (T/A & S/D)
Zoltan,
The 4GB database size was for the 2008 version. The 2008R2 onwards had the total database size increased to 10GB.
Think the RAM limit of 1GB would be far more limiting in a multiuser setup.
Agree that the full blown SQL Server would be required.
Steven
Top
Wed, 2018-07-18 12:46
#7
Zoltan Palffy
User offline. Last seen 3 weeks 4 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

get the full blow version of microsoft sql and have unlimited capabilities express limits you to 4 gigs of data 

Top
Wed, 2018-07-18 05:55
#8
Morne Johann Bees...
User offline. Last seen 9 weeks 4 days ago. Offline
Joined: 25 Feb 2016
Posts: 16
Groups: None

Thank you Steve, will discuss with our IT and see what our options are. Should have full SQL licenses. Bandwith has been a definite issue on previous projects as the lag time it introduces is very frustrating.

Top
Tue, 2018-07-17 21:28
#9
Steven Auld
User offline. Last seen 6 weeks 2 days ago. Offline
Joined: 13 Sep 2017
Posts: 126
Groups: Petro-Chem / Oil & Gas, TURNAROUND & SHUTDOWN (T/A & S/D)
Morné,
It depends on how large & how many projects you are looking at having in the database at the same time & how many concurrent users you have.
The express version is limited to a maximum of 10GB for the database size and is limited in the amount of RAM it can use (1GB) & CPU / Cores limits.
Bandwidth may be an issue if you have large numbers of Global codes when you need to open all codes - I have seem Primavera using a high amount of desktop RAM (3.5 GB) which all is fed over the network, so if you are dealing with really large projects then it may be an issue.
Steven
Top