官术网_书友最值得收藏!

Choosing an edition of Analysis Services

Before we start developing with Analysis Services, we need a clear idea of which edition of Analysis Services we're going to be developing for. There are two choices: Standard Edition, which is cheaper but missing some features, and Enterprise Edition, which is more expensive but feature complete. Licensing cost is likely to be the major factor in this decision. If money is no object, then you should use Enterprise Edition. If it is an issue, then you'll just have to live with the limitations of Standard Edition. Of course, if we install Analysis Services on a server that already has SQL Server installed then there are no extra license costs involved, but as we'll see in Chapter 11, we have to be careful they don't compete for resources. This document on the Microsoft website gives a detailed breakdown of which features are available in each edition: http://tinyurl.com/sqlstdvsent.

Don't worry about having to use the Standard Edition though. Some of the features it lacks can be recreated with a little bit of extra work. The key features in Enterprise Edition are in the area of performance for very large or complex cubes, and you can go a long way with Standard Edition before you really need to use Enterprise Edition. The Deployment Server Edition project property, which is described below, will help you make sure you only use the features available in the edition of your choice.

主站蜘蛛池模板: 嵊州市| 进贤县| 景德镇市| 松滋市| 桂东县| 门头沟区| 常德市| SHOW| 阿尔山市| 安图县| 禄劝| 玛多县| 太白县| 通山县| 和平区| 咸阳市| 漳浦县| 汉阴县| 京山县| 田东县| 镇巴县| 巨鹿县| 辽中县| 郸城县| 中宁县| 涞源县| 昭苏县| 彰化市| 金湖县| 丹阳市| 武功县| 嘉禾县| 武汉市| 阜康市| 安福县| 延津县| 韶山市| 新干县| 客服| 巫山县| 黄龙县|