Hp ProLiant DL980 G7 Server User Manual download pdf (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

1 2 ... 37 38 39 40 41 42 43 44 45 46 47 ... 80 81

No comments

Hp ProLiant DL980 G7 Server User Manual Page 42