Tabular Modeling with SQL Server 2016 Analysis Services Cookbook by Unknown

Author:Unknown
Language: eng
Format: epub
Publisher: Packt Publishing

Limitations of in-memory

While in-memory mode is highly effective for creating BI solutions, there are limitations. First, since all data is cached in-memory, you have to ensure your server has adequate memory, not only for the dataset. Be sure to include the operating system, Analysis Services, and any other third-party software your company may require. If loading very large datasets into memory, you can exceed available memory and the deployment and processing will fail. If you are using the same Analysis Services server for multiple models, you will need to monitor the total size of data being loaded into memory. You could have a small model fail to deploy because other models have used most of the available free memory.

Another limitation of in-memory mode is having to keep the data refreshed. If your data needs to be kept near real time, it can be difficult to reprocess the data in the memory cache.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.