I get that Limits of Running of SQL express for SharePoint 2013 makes you limited in some ways.

But what does that mean in terms of sharepoint usage? If using Sql express would that explain random 500 errors from sharepoint?

What will be the actual result for users? I want to save that money if I can of course.

1 Answer 1


As you know limitation of CPU and Memory usage by SQL express edition may cause you 500 errors. Due to memory limitation on express edition (1Gb) then too many requests on the SQL can cause the issue...you may get 500 errors or server too busy or the page cannot display.

It is not recommended use the SQL express in your production. You can read the SQL server 2012 express edition limitation here: https://msdn.microsoft.com/en-us/library/cc645993(v=SQL.110).aspx

  • Even in a development / test environment, random 500 errors makes it really hard to use. Mar 27, 2017 at 13:29
  • It's depend what u doing? May be problem with Sharepoint servers rather sql...
    – Waqas Sarwar MVP
    Mar 27, 2017 at 14:43
  • we are running a test that uses the sharepoint api to go through some files and do some processing. if any of the files doesn't appear, it will fail the test. sometimes 2 out of say 70 files will error when requesting them thus the failure. Mar 27, 2017 at 20:33

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.