locked
Sql 2008 Standard vs Enterprise RRS feed

  • Question

  • I read that on the same hardware the SQL Enterprise Edition is "faster" to complete a task  than the corresponding Standard edition. Is this true? If so, why?

    TIA,

    barkingdog

    Wednesday, September 23, 2009 6:44 AM

Answers

  • Only of you happen so be exposed of a functionality which EE had but SE doesn't have (like enhanced scan, parallell index rebuild, deeper pre-fetch etc). For instance, for SQL Server 2008 the list is here:
    http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

    Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi
    Wednesday, September 23, 2009 7:36 AM
  • Only of you happen so be exposed of a functionality which EE had but SE doesn't have (like enhanced scan, parallell index rebuild, deeper pre-fetch etc). For instance, for SQL Server 2008 the list is here:
    http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

    Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi

    Add to that database compression which reduces the size of the database on disk which equates to less physical reads to perform the same operation.  In one of my databases, compressing the largest two tables reduced a 140GB database to 42 GB and improved performance times of common queries against these tables significantly.  We also see reduced IO but with a slightly higher CPU cost (about 3%)
    Jonathan Kehayias
    http://sqlblog.com/blogs/jonathan_kehayias/
    http://www.twitter.com/SQLSarg
    http://www.sqlclr.net/
    Please click the Mark as Answer button if a post solves your problem!
    Wednesday, September 23, 2009 2:16 PM

All replies