SQL Server Performance

SQL2K Developer Edition

Discussion in 'Performance Tuning for Hardware Configurations' started by esch, Oct 2, 2003.

  1. esch New Member

    I have an R&D box (MS 2000 Advanced Server, SQL2K Developer Edition, SP3,8GigsRAM 4 ZEON HT 1.4GHz), which I have been benchmarking some SPs against another box (MS 2000 Server, SQL2K Standard Edition, 1 Zeon 1.8GHz). I have noticed that the Developer Edition is 3x slower than my Standard Edition box. I've gone through alot of the Microsoft documentation and haven't found anything dealing performance type differences that would affect me.

    I have heard of Developer Edition having some governors in place, from a Non-MS source. The one thing I noticed during the test was that one processor was being used on the Developer Edition box. Can anyone tell me if there is anything along this line of reasoning that would suggest that SQL2K Developer Edition is not utilizing the hardware properly?
  2. ykchakri New Member

    I don't think there are any performance differences between developer and standard edition. But, please check the processor tab under server properties to see if the server is set to use 1 CPU instead of all 4.
  3. joechang New Member

    certain operations can have serious performance problems with HT enabled
    try OPTION (MAXDOP 1) if the execution plan shows parallel plan.
    also, with non-parallel plans, a single query will only run a single proc, so if you are testing individual queries, the faster cpu will run better
    in particular, an insert test may run faster on a single cpu HT enabled system than a 2-4 cpu HT enabled system
  4. satya Moderator

Share This Page