Post reply

Maximum size of the database, maximum amount of users (SQL Standard)

  • April 19, 2004 at 5:12 am

    #84807

    Dear specialists,

    I really have an urgent problem of which I cannot seem to find an answer to:

    For clients of ours I am looking which version of SQL they should use. At this moment in time they are all using the SQL-Standard version. There are two main problems:

    1) when the database grows over 2 Gb lots of errormessages are generated. Updates on the database are processed however. Systems start to 'stutter' so to speak.

    What's the limit of that database? (standalone computer, lots of diskspace, 2 Gb RAM)?

    2) how many users are physically possible to work with the Standard (no Enterprise edition) version at the same time? I know each users consumes about 37 Kb, so I guess it's about 30 or so. Can anybody please tell me whether that's true o false and why?

     

    Thanks very much for the information!

     

    *** Ziegel Ziegelaar ***

    ***    Netherlands   ***

  • April 19, 2004 at 5:24 am

    #503292

    Take a look at 'Maximum Capacity Specifications' in BOL.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • April 20, 2004 at 7:50 am

    #503485

    In addition to Frank's suggestion to looking in BOL the following may be helpful.

    1. Look at the error messages that are being generated.  These should provide insight into why your customer's database is encountering errors that appear to be related to the size of the database.  (Note: MSDE limits the database to 2 GB.)

       Is the application issuing SQL requests that will not scale?  I have frequently seen this type of problems and it is often blamed on the database engine instead of the application.

    2. SQL Server Standard Edition can support hundreds of concurrent users.  Again, performance is typically more dependent upon what the users are doing than how many concurrent users. 

    3. Rahul Sharma's article on "SQL Server: Enterprise vs. Standard" may help identify other benefits of SQL Server Enterprise Edition that would help your customer. http://www.sqlservercentral.com/columnists/rsharma/enterprisevsstandardedition.asp

    In summary, I would suggest identifying the root cause of your customer's performance problems.  If the customer upgrades to SQL Server Enterprise Edition and the problems continue, you have probably lost a customer.

    Regards,

    Mike

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

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