![]() Some things you will need Enterprise Edition for ![]() Memory and CPU core limits do not apply to SSAS and SSRS servers. However, the additional hardware and licensing may be no cheaper than biting the bullet and getting EE. edition supports distributed partitioned views, which gives you a basic read-only sharding capability. You can probably get away with (say) 100GB or so on BIE by applying brute force at the hardware level (fast disks).ī.I. edition, which makes it a bit more of a contender for data marts. By the look of the link, all SSAS features present in EE are present in B.I. edition seems to give you the clever aggregates (last non empty etc.) and other features that SE doesn't on the OLAP server. edition also has a limit on the number of CPU cores and memory that can be used by the database server, although this does not appear to apply to Analysis Services or Reporting Services.Ī more detailed breakdown of the S.E., B.I. If you have less than (say) 100GB of data then you can probably get by with BI edition. The EE features are mostly relevant to users with large data volumes. EE has partitioning and the rest of the large database features. Business Intelligence edition has some useful features, like Master Data Services and non-additive aggregations (i.e.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |