Hp ProLiant DL980 G7 Server User Manual download pdf (Page 40)

that read data from disk into the system file cache, thereby lowering contention on the cache.

Available only on SQL 2012 and later.

Low Memory Limit

Specifies the amount of memory allocated by Analysis Services at startup. When this limit is reached,

the instance starts to slowly clear memory out of caches by closing expired sessions and unloading

unused calculations. The server will not release memory below this limit. The default value is 65,

which indicates the low memory limit is 65% of physical memory or the virtual address space,

whichever is less.

Total Memory Limit

Defines a threshold that, when reached, causes the server to deallocate memory more aggressively.

The default value is 80% of physical memory or the virtual address space, whichever is less.

Coordinator Query Balancing Factor and Coordinator Query Boost Priority Level

When multiple users access SQL Server Analysis Services concurrently, an expensive query that

needs to scan large number of partitions can monopolize the system and block other users. To

avoid this problem and achieve high concurrency, HP recommends that Coordinator Query

Balancing Factor be set to 1 and Coordinator Query Boost Priority Level to 0.

Enable Rolap Distinct Count On DataSource

Queries that include DistinctCount in a ROLAP process can run faster, assuming certain criteria

are met. Performance is improved because more of the operation has been off-loaded to the

relational database engine, where COUNT(DISTINCT column) is used to return unique non-null

values, eliminating the need for more expensive ordering operations that degrade query

performance. This optimization is disabled by default because the query results produced by the

new and older algorithms are not always identical. Transact-SQL counting can vary for NULL values

and different collations. If you want to use the optimization, set the OLAP\ProcessPlan\Enable

Rolap Distinct Count On DataSource property to 1.

Process Min Threads

A signed 32-bit integer that determines the minimum number of threads for queries. HP ESO always

recommends that the value be equal to the total number of logical CPUs on the local system.

Vertipaq Memory Limit

If you use VertipaqPagingPolicy mode 0 (Vertipaq is the Microsoft xVelocity in-memory analytics

engine), the VertiPaq Memory Limit defines the total amount of memory Vertipaq is allowed to lock

in the working set (this is the total that can be used for in-memory databases; the Analysis Services

service might use more memory for other reasons).

If you use VertipaqPagingPolicy mode 1 (the default), this defines a limit for the physical memory

used by VertiPaq, allowing paging for the remaining memory (virtual committed memory) above

this limit. This property is specific to Tabular mode Analysis Services only.

The VertipaqPagingPolicy mode is not settable by the HP ESO interface. You can set or change

the mode using the msmdsrv.ini file.

Resource Monitor

Resource Monitor provides a communication, monitoring, and processing layer between the Cluster

service and one or more resources. HP ESO always recommends it be disabled (OFF). The property

is specific to SQL 2012.

40 Using HP ESO

1 2 ... 35 36 37 38 39 40 41 42 43 44 45 ... 80 81

Comments to this Manuals

No comments

Hp ProLiant DL980 G7 Server User Manual Page 40

Comments to this Manuals

Related products and manuals for Computer hardware Hp ProLiant DL980 G7 Server