You install a SQL Server Analysis Services (SSAS) instance in tabular mode on a server. While processing a very large tabular model, you receive an out-of-memory error. You identify that the amount of

To allow paging to disk and minimize out-of-memory errors for a large tabular model, configure the following server properties in sequence: 1. In Object Explorer, right-click the Analysis Services instance and then click Properties. 2. Change the value of the Memory VertiPaqPagin

Configure and maintain an analysis services database

Question

You install a SQL Server Analysis Services (SSAS) instance in tabular mode on a server. While processing a very large tabular model, you receive an out-of-memory error. You identify that the amount of physical memory in the server is insufficient. Additional physical memory cannot be installed on the server. You need to configure the server to allow paging to disk by using the operating system page file (pagefile.sys). You need to minimize the number of errors. Which four actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

Explanation

To allow paging to disk and minimize out-of-memory errors for a large tabular model, configure the following server properties in sequence:

In Object Explorer, right-click the Analysis Services instance and then click Properties.
Change the value of the Memory VertiPaqPagingPolicy configuration option to 1. (Setting this to 1 enables paging to disk using the operating system page file, preventing processing failures when physical memory is insufficient).
Change the value of the Memory VertiPaqMemoryLimit configuration option to 0. (When VertiPaqPagingPolicy is 1, setting VertiPaqMemoryLimit to 0 means paging will occur as needed, effectively using the page file whenever memory pressure arises, rather than waiting for a specific memory consumption threshold like the default 60%).
Restart the Analysis Services instance. (Changes to these configuration properties require a restart of the Analysis Services instance to take effect.)

Topics

#memory configuration#tabular mode#paging to disk#server configuration

Community Discussion

No community discussion yet for this question.

Full 70-466 Practice