mibuso.com
Home› SQL General
Options

sql 2005 standard v. enterprise version

ara3nara3n Member Posts: 9,255
edited 2007-10-15 in SQL General
Hello
Are there anybody out there who has done a comparison between enterprise vs. standard sql 2005 to see the performance difference?

Thanks.
Ahmed Rashed Amini
Independent Consultant/Developer


blog: https://dynamicsuser.net/nav/b/ara3n

Comments

  • Options
    kinekine Member Posts: 12,562
    Because it is still same engine, there will be no performance difference. Just the resource limits can have impact to the performance in this case and it means just if you need more than 4 CPUs you will have performance difference (standard use max 4 CPUs). Other features which are in Enterprise version are not used in NAV.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • Options
    Marije_BrummelMarije_Brummel Member, Moderators Design Patterns Posts: 4,262
    One of the most important decision factors will be online indexing. This cannot be done with standard.

    Customers who decide to use enterprise version should be on 64 bit anyway so resources etc. is not a limit anymore.
    Marije Brummel | Freelance Business Central Specialist
  • Options
    thaugthaug Member Posts: 106
    See the chart here:
    http://www.microsoft.com/sql/prodinfo/f ... tures.mspx
    There is no data, only bool!
Sign In or Register to comment.