HP ProLiant DL980 G7 Server - Manual (Page 46)

Estimated Size
The estimated size of the partition in megabytes.
Proactive Caching
Proactive caching provides automatic MOLAP cache creation and management for OLAP objects.
The cubes immediately incorporate changes that are made to the data in the database, based
upon notifications received from the database. The goal of proactive caching is to provide the
performance of traditional MOLAP, while retaining the immediacy and ease of management offered
by ROLAP.
ESO database recommendation statements
Database File on OS Drive
HP ESO recommends that you store the database file in a location other than the system (OS) drive.
If a database file is found on the system drive, HP ESO displays a recommendation statement to
use a non-system drive for the database.
Multiple Files
HP ESO recommends that each database file be located on a separate, dedicated drive. If multiple
database files are found on a drive, HP ESO displays a recommendation statement to use a
dedicated drive for each database file and to use 80% of the drive space as the initial size of each
database file.
Create Column Store Index
The Column Store index in the SQL Server Database Engine can be used to significantly speed up
the processing time of common data warehousing queries. Typical data warehousing workloads
require summarizing large amounts of data. The techniques typically used in data warehousing
and decision support systems to improve performance are pre-computed summary tables, indexed
views, OLAP cubes, and so on. The HP ESO recommendation is to create a column store index
for data warehousing if its Analysis Services instance is running in Tabular mode.
tempdb Data File
HP ESO recommends that the number of tempdb data files be the same as the socket number or
core number in the socket.
Split the Partition
If the Partition size is greater than 3GB, HP ESO recommends splitting the partition. This
recommendation statement appears only when the database of the Analysis Services instance has
a database cube built inside.
Enable Proactive Caching
Turn on Proactive Caching for partitions. This recommendation statement appears only when the
database of the Analysis Services instance has a database cube built inside.
Viewing high availability and disaster recovery configurations
HP ESO Database page can provide information about high availability and disaster recovery
configurations for SQL Server and Analysis Services databases.
Availability Group
An Availability Group, a feature introduced with SQL Server 2012, provides high availability for
application databases. Availability Groups support a failover environment for a discrete set of user
databases known as availability databases. An Availability Group provides all the benefits of
Database Mirroring but also comes with a powerful set of new options that increase application
46 Using HP ESO