Post reply

SQL Server - Multiple Users Contention

  • July 12, 2012 at 12:19 pm

    #277676

    I am developing an ASP.NET app with back-end SQL 2008 Express. I expect eventually around 100 users to use this app.

    From the config point, do I need to do anything to the DB to ensure multi-user access concurrent access?

    Any suggestions are greatly appreciated. I installed the SQL Express with default settings. I only changed RPC setting to add and use a Linked Server with SQL 2005 DB.

    Sorry I do not have any more details. But I am not sure what details would help answer this query.

    Thanks much.

  • July 12, 2012 at 12:53 pm

    #1512259

    Here is a link posted by Steve Jones on 12/31/2007 12:43 PM

    http://www.sqlservercentral.com/Forums/Topic437598-324-1.aspx#bm437640

    which in turn contains this link:

    http://technet.microsoft.com/library/Cc966393

    With no workload governor, there should be no limit as far as the database is concerned, however the operating system on which it is installed could of course slow things down.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

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

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