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.
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.
Member for
16 years 3 monthsSteve you are correct the
Steve you are correct the limt has increased fom 4 gigs to 10 gigs
Member for
8 years 1 monthZoltan,The original post
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
Member for
16 years 3 months10 gig is only for express
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
Member for
8 years 1 monthZoltan, Please see the table
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
Member for
16 years 3 monthsare uo sure about that for
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
Member for
8 years 1 monthZoltan, The 4GB database size
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
Member for
16 years 3 monthsget the full blow version of
get the full blow version of microsoft sql and have unlimited capabilities express limits you to 4 gigs of data
Member for
9 years 8 monthsThank you Steve, will discuss
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.
Member for
8 years 1 monthMorné, It depends on how
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