Hp ProLiant DL980 G7 Server Bedienungsanleitung Seite 44
- Seite / 81
- Inhaltsverzeichnis
- FEHLERBEHEBUNG
- LESEZEICHEN
Bewertet. / 5. Basierend auf Kundenbewertungen
Updating statistics ensures that queries compile with up-to-date statistics. However, updating statistics
causes queries to recompile. HP recommends that you avoid updating statistics too frequently:
there is a performance trade-off between improving query plans and the time it takes to recompile
queries. The specific trade-offs depend on your application. UPDATE STATISTICS can use tempdb
to sort the sample of rows for building statistics.
Auto Update Statistics Async
This parameter applies to the SAP Database Engine only. When you enable this option (select
ON), the SQL Server will start updating statistics asynchronously, using a separate background
thread. Client queries will not have to wait for the process to complete, and they can continue
using the current statistics while the update is processing in background. When the update process
completes, the Query Optimizer can start using the updated statistics. This means that until the
update process is complete, the Query Optimizer will produce execution plans based on the
current/old statistics. To disable this parameter, select OFF.
Analysis Services properties
The following properties are informational only; they are not settable from HP ESO.
Tabular Compatibility Level Number
Analysis Services instances with SQL Server 2012 support compatibility levels 1100 and 1103.
The SQL Server Database page displays the database version as “SQL Server 2012 (1100)” or
“SQL Server 2012 (1103)”.
Data Dir
The Data Dir property indicates where Analysis Services data is stored per server instance.
Temp Dir
The Temp Dir property indicates where Analysis Services places temporary files that it uses during
processing operations.
Log Dir
The Log Dir property indicates where Analysis Services logs and traces are stored.
Measure Group
A Measure Group (MeasureGroup object) is composed of basic information, measures, dimensions,
and partitions.
• Basic information includes the name of the measure group, the type of measures, the storage
mode, the processing mode, and others.
• Measures are the actual set of measures that compose the measure group. For each measure
there is a definition for the aggregate function, the formatting attribute, the data item source,
and others.
• Dimensions are a subset of cube dimensions used for creating the processed measure group.
• Partitions are the collection of physical splits of the processed measure group.
Partition
A partition is a container for a portion of the measure group data. Partitions are not seen from
MDX queries; all queries reflect the whole content of the measure group, regardless of how many
partitions are defined for the measure group. The data content of a partition is defined by the
query bindings of the partition and by the slicing expression.
Estimated Rows
The estimated number of rows in the partition.
44 Using HP ESO
- User Guide 1
- Contents 3
- 4 Contents 4
- Contents 5 5
- 1 Introduction 6
- New features in release 3.5 7
- New features in release 3.0 7
- 8 Introduction 8
- 2 Installing HP ESO 10
- Installing the software 11 11
- Uninstalling the software 12
- Upgrading the software 12
- Silent installation 13
- In desktop mode 14
- In tile mode 14
- 4 Using HP ESO 18
- Getting started 19
- 20 Using HP ESO 20
- Getting started 21 21
- Getting Started pages 22
- HP ESO SQL Login page 23
- 24 Using HP ESO 24
- Getting started 25 25
- 26 Using HP ESO 26
- Getting started 27 27
- 28 Using HP ESO 28
- Services instances 29
- 30 Using HP ESO 30
- 32 Using HP ESO 32
- 34 Using HP ESO 34
- ◦ Data Warehouse (DW) 37
- ◦ SAP Database Engine 37
- 38 Using HP ESO 38
- 40 Using HP ESO 40
- ◦ Data Warehouse 42
- Analysis Services properties 44
- Figure 38 Mirrored database 47
- Cluster Network Name 48
- Computer Name 48
- Computer Role 48
- 50 Using HP ESO 50
- 52 Using HP ESO 52
- Overview 53
- 54 Using HP ESO 54
- 56 Using HP ESO 56
- Trace flag 8048 57
- Trace flag 834 57
- Trace flag 1117 58
- Trace flag 1118 58
- Trace flag 2371 58
- Trace flag 2549 58
- Trace flag 2562 58
- Database RAID level 59
- User Write Cache Setting 59
- Cache Power Protection 59
- Drive free space 59
- Volume mount point 60
- Drive Latency 60
- Port affinity 61
- Receive-Side Scaling 62
- NIC teaming 63
- 64 Using HP ESO 64
- PCI Controller Information 66
- Software Discovery 66
- SQL configurations 67
- 68 Using HP ESO 68
- Save/Rollback Configuration 69
- 70 Using HP ESO 70
- Accessing online help 71
- 72 Using HP ESO 72
- 76 Using HP ESO 76
- 5 Troubleshooting 78
- 6 Support and other resources 79
- Related information 80
- Typographic conventions 80
- 7 Documentation feedback 81
Verwandte Produkte und Handbücher für Computerhardware Hp ProLiant DL980 G7 Server
(37 Seiten)© 2020, manymanuals.de. Alle Rechte vorbehalten. | 0.567 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Kommentare zu diesen Handbüchern