Post reply

Why does Express show better performance than Stardand when DB size < 2G?

  • July 24, 2008 at 12:04 am

    #194330

    I have done a test about Express and Stardand, when DB size <2G, or concurrent user numbers <5, the performance of Express is better! I really want to know why....

    Thanks

  • July 24, 2008 at 12:32 am

    #847543

    Same database, same data, same hardware, same queries?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 24, 2008 at 12:50 am

    #847547

    Yes! So I am curious about this 🙂

  • July 24, 2008 at 12:55 am

    #847550

    Were you testing on the same machine or different? Were the settings of the 2 SQL instances the same?

    I can't really offer a suggestion without more info. What did you test and what was the performance difference?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 24, 2008 at 1:09 am

    #847555

    You can consider they are the same except that edition. If 2G stardand edtion perform better.

    We test Average CPU Consumption and Average Available Mbytes when we do the same SQL operation on two editions.

    I guess when small DB, express edition simplifies the operation process, and save some resources. However I didn't find any official document about this topic...

  • July 24, 2008 at 1:11 am

    #847556

    If db 2G stardand edtion perform better

  • July 24, 2008 at 1:16 am

    #847559

    Available memory's a bad measure. SQL will, by design, take memory if it is available and if the max memory has not been set.

    Express is limited to 1 GB (on 32 bit) and may no allocate more than that, while Standard edition is only limited by the amount of memory that the OS supportes

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • July 24, 2008 at 2:20 am

    #847576

    That is resonable, however how about the CPU ?

    Is there any possible Express edition does better than Stardand? They are using the same engine. Sadly MS didn't provide documents.

  • July 24, 2008 at 2:24 am

    #847577

    Not offhand. It could be a throttling within express. Lower avg CPU but the same overall CPU usage. Don't know for certain, just a guess.

    If you want to test performance, try watching CPU time, Duration and IOs done.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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