Is it fine to run a public high traffic website on a sql server 2008 express db? enter image description here

  • 2
    You need to define "high traffic." Sep 15 '11 at 21:58
  • I mean something with traffic as this website but the website will access the db from each user browser every few second to get updated data. Sep 15 '11 at 22:02
  • 1
    You can run a public website off SQL Express with great performance. You can run a public website off a DataCenter edition with fusionio SSDs and terrabytes of RAM and the site can perform like crap. As long as the database has a sound design, the engine and response time should be fine. It might make sense to do some caching in your app, maybe not but just because it's free, doesn't mean it's dreck. It's your design and your access methodology that will make all the difference.
    – billinkc
    Sep 15 '11 at 23:13

Here is a partial list of restrictions of this version:

  • Number of CPUs: 1
  • Maximum memory utilized: 1 GB
  • Maximum database size: 10 GB
  • Replication: Subscriber only
  • Backup compression: N/A
  • Most of performance features is not available.
  • ...

See comparison list for more details


Depending on your definition of high traffic, it is likely that you will see awful performance. If there is any transactional writes that happen often, you'll cap out the max database size rather quickly, and as mentioned above there are many hardware restrictions on express. Not to mention you don't have all the creature comforts for a professional enterprise instance (SQL Agent, etc.).

SQL Server express is more for embedded applications, or very small low-budget intranet applications.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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