HI ,
Currently setup sql server express edition 2012 R2 with O.S. installed 2008 r2 std.
I am aware about express edition database size limit is 10 GB, Constrained to a single CPU , and Maximum memory utilized by SQL Server Database Engine is 1GB .
As of now 8 GB of ram installed and customer wants to increase ram on server.
From SQL instance we have set the default allocation for memory like it's use maximum.
Sometime when work loads, memory utilization on server was 80-90% and its only used by SQL server. at that time slowness issue occurred.
So my question is if i am increase the ram on server that may be helpful on express edition. Performance will increase on server or not ?
Thanks,
Bhautik Shah