HP ProLiant DL980 G7 Server - Manual (Page 42)

Figure 35 Analysis Services mode types
Database page: Viewing and controlling database parameters and optimization
recommendations
The Database page contains parameters related to database files in each SQL Server and Analysis
Services instance. The SQL instances displayed on the page are grouped into the following types:
•
SQL Server instances
Database Engine ◦
◦ Data Warehouse
◦ SAP Database Engine
•
Analysis Services instances
Figure 36 (page 43) shows an example of the Database page.
When Availability Groups and database mirroring are in use, the Database page displays
information about them. Availability Groups and database mirroring contribute to higher availability
and more reliable disaster recovery for databases. For more information about availability groups,
database mirroring, and viewing information about high availability and disaster recovery
configurations, see
“Viewing high availability and disaster recovery configurations and
recommendations” (page 45) .
IMPORTANT: Whenever major SQL Server configuration changes are made while the current
ESO Admin Session is active, rerun data collection. (Examples of major configuration changes
include adding or removing an SQL instance, database, or database file.) Data that was collected
prior to a major configuration change will likely be obsolete. Rerunning the data collection ensures
that optimization recommendations and reports are aligned to the current configuration and
workload.
42 Using HP ESO