Post reply

SQL Server Developer vs Enterprise vs Standard Editions

  • February 22, 2005 at 3:28 pm

    #85479

    All,

    I have a couple of questions about SQL Server 2000 editions.

    1) I have a dual processor development db server with SQL Server 2000 Developer Edition installed. It seems SQL Server does not utilize both processors. Is it possible for the developer version to utilize more than one CPU?

    2) Is the Developer Edition of SQL Server 2000 equivalent to the Enterprise Edition or the Standard Edition? What is the main difference between the Standard Edition and the Enterprise Edition (other than price!)?

    Any help on these questions would be greatly appreciated.

    Thanks,

    Jason

  • February 22, 2005 at 5:05 pm

    #543585

    SQL Server Developer Edition is equivalent to Enterprise Edition.

    For details on the different editions take a look at this document from the resource kit,

    http://www.microsoft.com/sql/techinfo/planning/SQLReskChooseEd.asp

     

    --------------------
    Colt 45 - the original point and click interface

  • February 22, 2005 at 7:35 pm

    #543596

    Hai,

    By default, SQL Server 7.0 and 2000 are set to use "Use All Available CPUs" on a server. If this is not your current setting, then this has been changed by someone.

    Essentially, this setting tells SQL Server whether or not to try and attempt to execute queries in parallel using multiple processors. If the default "Use All Available CPUs" option is selected, then SQL Server will attempt to run queries in parallel, using multiple CPUs. This can sometimes result in dramatic performance differences in a query's performance. But if this option is turned off, then SQL Server will only use one CPU to execute a query, which can be much slower.

    Keep in mind that if SQL Server is set to use parallelism, that it may not always use it. If the server is very busy, it may not be used, but when the server is less busy, it may be used. This means that sometimes the view will be fast, and other times, slow (depending if parallelism is being used or not).

    Also, be sure that you have the latest Service Pack on your SQL Server

     


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

  • February 23, 2005 at 12:56 am

    #543619

    I have sql 7 dev. edition and also have never seen both processors used...

    All settings have both processors turned on.

    If anybody has the answer I would shure appreciate it..

    Have wanted an answer to this question for a long time..

    I see nothing from Microsoft about this limitation..

  • February 23, 2005 at 3:46 pm

    #543795

    As Helen mentioned, just because you have two CPU doesn't mean that they will be used by SQL Server every time. If the DB engine determines that it can accomplish the task using one CPU, then there's no need for it to split the task across the two CPUs.

    One thing you might try is to run a union query on one of the larger tables in the database. Generally the query optimiser will split the union into to seperate queries that run on each CPU.

     

    --------------------
    Colt 45 - the original point and click interface

Viewing 5 posts - 1 through 4 (of 4 total)

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