HP ProLiant DL980 G7 Server User Manual
Page 35
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\EnableRolapDistinctCountOnDataSource property to 1.
Database page: Viewing and enabling database 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.
Figure 32 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
“Database page: Viewing high availability and disaster recovery configurations”
.
The following subsections describe database parameters and recommendations that might be seen
on the Database optimization page. Parameters pertaining to Availability Groups and database
mirroring are described in
“Database page: Viewing high availability and disaster recovery
. Cluster-related parameters (Cluster Network Name, Computer Name,
Status, and Computer Role) are described in
“Clustered SQL Server instance” (page 40)
.
Optimizations pages
35