SQL Server Express Experiences.

  • Hi,

    I am working on development of a web based solution for which SQL Serevr Express might - just might be enough for the database needs. My understanding are it's 1 GIG memory, 1 CPU and 4 GIG size restricted. Size wise I think this will be fine;

    Does anyone have experience of runnning a web based solution against SSE, and what would be reasonable balpark figures for the number of concurrent users that could be supported off the 1CPU, 1 GIG limits.

    The application is not really very data intensive - typically a web page is loaded from the db, the user adds/edits data and then at some point save.

    Thanks for any experiences/advice anyone can give.

    Kind Regards,

    Peter Clements

  • Microsoft have removed the concurrent user limit in SQL Server Express compared to MSDE because Asp.net developers worked around the limit, so to answer your question you only issue will the the 1gig ram because in RDBMS that is very small. So try load testing with actual use of your application features.

    Kind regards,
    Gift Peddie

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply