Viewing and controlling database parameters and – HP ProLiant DL980 G7 Server User Manual
Page 43
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
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
.
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.
Optimizations pages: Viewing and controlling optimization recommendations
43