+1-888-365-2779
Try Now
More in this section

Forums / Deployment / IS SQL Server 2008 R2 Express Good Enough

IS SQL Server 2008 R2 Express Good Enough

6 posts, 0 answered
  1. Abraham
    Abraham avatar
    29 posts
    Registered:
    11 Aug 2010
    22 Mar 2011
    Link to this post
    I just realized that Sitefinity 4.0 does not support SQL server 2000 at this time.  I also realized that I cannot restore a 2008 backup onto a SQL 2000 server.  How large can I expect the average large Sitefinity db to grow to over time?  Is the 10GB limitation of SQL Server Express 2008 R2 going to be a problem?  What about performance?  Could you give me any examples of a large Sitefinity site running on Express?

    Abraham
  2. Steve
    Steve avatar
    3037 posts
    Registered:
    03 Dec 2008
    22 Mar 2011
    Link to this post
    IMO, the only thing that will cause your DB to bloat that large will be storing Images\Documents into the database via the libraries...and as of right now that's the only place you can store them until they re-impliment the FileSystem provider or the AmazonS3 (RackSpace CloudFiles?) Providers...
  3. Ivan Dimitrov
    Ivan Dimitrov avatar
    16072 posts
    Registered:
    25 Nov 2016
    22 Mar 2011
    Link to this post
    Hi Steve,

    Running large corporate websites on the SQL Express editions is not preferred. For large websites it is better to use dedicated servers.

    Kind regards,
    Ivan Dimitrov
    the Telerik team
  4. Steve
    Steve avatar
    3037 posts
    Registered:
    03 Dec 2008
    22 Mar 2011
    Link to this post
    Yeah, that would be nuts, I assumed he meant shared hosting
  5. Abraham
    Abraham avatar
    29 posts
    Registered:
    11 Aug 2010
    22 Mar 2011
    Link to this post
    I am talking about running an installed instance of SQL Server Express 2008 on a dedicated server with the database running as a normal attached database in SQL.  Why would that be nuts? 

    The only limitations on SQL Server Express 2008 are 1 CPU, 1 GB of RAM and 10 GB of storage.  Is one of those a problem?
  6. SelAromDotNet
    SelAromDotNet avatar
    912 posts
    Registered:
    18 Jul 2012
    23 Mar 2011
    Link to this post
    I think what they mean is that performance-wise, SQL Express is not designed to maintain high server loads from a busy website. It's great for small sites on shared hosting, and I don't believe there is anything in those limitations that will prevent Sitefinity from running.

    I think old versions limited incoming connections but I think that has been done away with. Still, if your site explodes with popularity, performance might suffer, not because of Sitefinity but because SQL Express is not designed to support that much traffic.

    hope this is helpful!
6 posts, 0 answered