What is the Limitations with SQL on SBS2003 Premium

Discussion in 'Windows Small Business Server' started by Arcticflipper, Mar 4, 2005.

  1. Can anyone inform me what the restrictions are with the SQL Server that came
    with Small Business Server 2003 Premium Edition. I have heard that you are
    only allowed to have 16 Databases, and that these in total are only allowed
    to be 3 GB of data.

    Is there any URL where I can read up about this?
    Can anyone provide an answer to this?
     
    Arcticflipper, Mar 4, 2005
    #1
    1. Advertisements

  2. Where did you hear this?

    We're bog standard SQL 2000.
     
    Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP], Mar 4, 2005
    #2
    1. Advertisements

  3. I received this information from Comztek, they are the official Microsoft
    distributer in South Africa.

    This is the reason why I am trying to find more information with regards to
    this.
    Please note that we are running a Small Business Server 2003 Premium edition
    with the SQL 2000 that came with it.
     
    Arcticflipper, Mar 4, 2005
    #3
  4. Susan Bradley, CPA aka Ebitz - SBS Rocks [MVP], Mar 4, 2005
    #4
  5. I despair at some of MS's Official Distributors product knowledge.

    MSDE is 2GB limit ( per Database ) not 3.

    Performance throttling will occur when there are more than
    five concurrent workload batches in progress. (MSDE 2000a allow 32,767
    connections to an instance of the database engine, but only 5 concurrent
    ones.) - this varies between 5 & 8 depending on the MS Doc you read
    and probably relates to the inclusion of System threads or not.

    The delay the current is based on the number of concurrent threads.
    After 5 concurrent threads are started, a delay is added to each
    operation and this delay gets increasingly longer for each additional
    thread that's started.

    ....and yes, it is limited to 16 database server instances on a single
    computer.

    The SBS Sharepoint MSDE instance is a "Special" instance that is neither
    restricted to the 2GB limit nor throttled.

    SBS SQL Server is as you say SBS Standard with the additional benefits
    for SBS Premium Users that: - It can be used to backend a Public Web
    Application, Can have unlimited instances installed on the SBServer.
     
    Henry Craven [SBS-MVP], Mar 4, 2005
    #5
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.