Standard VS Web Edition

  • Hi

    I am costing the purchase of a few new servers and stumbled opon the web edition option. It somehow had slid under my radar in the past.

    The MS website and some preliminary investigation have just mentioned the fact that SSIS and SSAS aren't included, however this isn't an issue for me as all I'd require (possibly) is SSRS.

    In summary my question is ,what are the differences (if any) between the Web edition and Standard Edition from the Database engine point of view?

    I'm thinking there must be a catch because there is a large difference in cost for my company as all our db servers have to use the per processor licencing model

    Thanks in advance

    Eoin

  • Hi Eoin,

    There are some additional differences, fi, you cannot cluster web edition, you can only use web edition as a witness in mirroring, etc... For a complete list, please look at http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

    Tom

    Tom Van Zele | Blog | Twitter | LinkedIn

  • Tom Van Zele (9/9/2010)


    Hi Eoin,

    There are some additional differences, fi, you cannot cluster web edition, you can only use web edition as a witness in mirroring, etc... For a complete list, please look at http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

    Tom

    Good link, thanks. I am mainly concerned with the difference (if any) from a performance point of view.

    One area of concern from the comparison above would be the lack of profiler. I presume I could still be able to run Server Side Traces without profiler (True/False?)

  • Yes you can run server side traces. Only the SQL Trace tool is not included.

    Tom

    Tom Van Zele | Blog | Twitter | LinkedIn

  • Tom Van Zele (9/9/2010)


    Yes you can run server side traces. Only the SQL Trace tool is not included.

    Tom

    Thanks Tom.

    This looks like a runner for us.

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

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