SAP HANA Administration
Find out how SAP HANA is changing the Job of the CBA. Understand SAP HANA admin concepts and then learn how to apply them practically. A must-read for any administrator
(Sprache: Englisch)
Who says that a leopard can't change its spots? With the advent of SAP HANA, database administration is evolving-and you can evolve along with it. Learn how traditional administration concepts are applied in SAP HANA, and find out about the new concepts...
Leider schon ausverkauft
Buch
- Lastschrift, Kreditkarte, Paypal, Rechnung
- Kostenlose Rücksendung
Produktdetails
Produktinformationen zu „SAP HANA Administration “
Klappentext zu „SAP HANA Administration “
Who says that a leopard can't change its spots? With the advent of SAP HANA, database administration is evolving-and you can evolve along with it. Learn how traditional administration concepts are applied in SAP HANA, and find out about the new concepts relevant to an in-memory database. From the persistence layer to monitoring and root cause analysis, you'll get the background and practical examples you need to make your job easier. Whether you're an administration novice or a leopard trying to adapt to different surroundings, this book will help you sharpen your skills.
Topic Highlights
- Architecture
- Installation and updates
- Administration tools
- Persistence layer
- Objects and tables
- Sessions and transactions
- Scaling out
- Performance
- Security
- Monitoring and root cause analysisHighlights:
ArchitectureInstallation and updatesAdministration toolsPersistence layerObjects and tablesSessions and transactionsScaling outPerformanceSecurityMonitoring and root cause analysis
Inhaltsverzeichnis zu „SAP HANA Administration “
Preface ... 171. Architecture of the SAP HANA Database ... 23
1.1 The Basics ... 23
1.2 The Physical View: SAP HANA Servers ... 26
1.3 The Operating System View: Database Processes ... 29
1.4 The Logical View: Internal Architecture of the Database ... 36
1.5 Distributed SAP HANA Systems ... 41
1.6 The Appliance Concept of SAP HANA ... 46
1.7 Release Cycles of SAP HANA Database Software ... 53
1.8 Summary ... 55
2. SAP HANA Scenarios: Administration Considerations ... 57
2.1 SAP HANA as a Database in Application Servers ... 58
2.2 SAP HANA as a Development Platform ... 64
2.3 Mixed Scenarios ... 68
2.4 Summary ... 73
3. Installation and Updates ... 75
3.1 Preparing for Installation and Updates ... 75
3.2 Tools for Installing and Updating SAP HANA Systems ... 85
3.3 Installing an SAP HANA Database ... 88
3.4 Updating an SAP HANA Database ... 101
3.5 Installing Multiple Instances of an SAP HANA Database on the Same Physical Server (Nonproduction) ... 110
3.6 Installation and Update in Batch Mode ... 111
3.7 Installing and Updating Scale-Out Systems ... 116
3.8 Troubleshooting ... 119
3.9 Summary ... 121
4. Administration Tools ... 123
4.1 Introduction to SAP HANA Studio ... 124
4.2 Database Administration with SAP HANA Studio ... 135
4.3 Monitoring the Database with SAP HANA Studio ... 144
4.4 DBA Cockpit for SAP HANA ... 153
4.5 Summary ... 156
5. The Persistence Layer ... 157
5.1 Log and Data Volumes: The Data Image on Disk ... 158
5.2 Log Backup ... 186
5.3 Snapshots ... 189
5.4 Data Backup and Recovery of the SAP HANA Database ... 199
5.5 Disaster Recovery Setups and System Replication ... 236
5.6 Summary ... 254
6. Scale-Out Systems and High Availability ... 255
6.1 Scaling Out SAP HANA Systems ... 256
6.2 High Availability with Host Autofailover ... 268
6.3 Client Connect in Distributed Systems ...
... mehr
273
6.4 Summary ... 274
7. Objects ... 275
7.1 Common Properties of Database Objects ... 276
7.2 Tables ... 290
7.3 Triggers and Constraints ... 292
7.4 SQL Views ... 295
7.5 Column Views ... 302
7.6 Sequences ... 305
7.7 Procedures and Functions ... 312
7.8 Synonyms ... 313
7.9 Summary ... 315
8. Table Types ... 317
8.1 Common Properties of All Tables ... 318
8.2 Row Store Tables ... 319
8.3 Column Store Tables ... 324
8.4 Special Types of Tables ... 338
8.5 Summary ... 345
9. Working with Tables ... 347
9.1 Loading Tables to and from Memory ... 347
9.2 Running Delta Merges ... 356
9.3 Partitioning and Distributing Tables ... 365
9.4 Optimizing Table Distribution and Partitioning ... 381
9.5 Importing and Exporting Tables ... 395
9.6 Checking Tables for Consistency ... 409
9.7 Summary ... 411
10. Sessions and Transactions ... 413
10.1 Introduction to Sessions and Transactions ... 413
10.2 Processes and Threads ... 428
10.3 Monitoring Sessions and Transactions ... 445
10.4 Concurrency and Parallelism ... 451
10.5 Summary ... 465
11. Working with the Repository ... 467
11.1 Properties of the SAP HANA Repository ... 467
11.2 Creating and Editing Objects in SAP HANA Studio ... 477
11.3 Deleting Development Objects in SAP HANA Studio ... 486
11.4 Mechanisms for Exporting and Importing Objects ... 488
11.5 Change Recording and Transports ... 491
11.6 Summary ... 494
12. User Management and Security ... 497
12.1 Essential Security-Related Concepts ... 498
12.2 Database Users ... 498
12.3 Authentication Methods ... 516
12.4 Securing SAP HANA's Network Interfaces ... 525
12.5 Auditing in the Database ... 534
12.6 Summary ... 541
13. Roles and Privileges ... 543
13.1 Database Roles ... 543
13.2 Privileges in the Database Catalog and Repository ... 553
13.3 Types of Privileges in SAP HANA ... 560
13.4 Critical Privileges and Privilege Combinations ... 570
13.5 Standard Roles for SAP HANA Systems ... 575
13.6 Troubleshooting Authorization Issues ... 575
13.7 Summary ... 587
14. Planning and Setting Up an SAP HANA System Landscape ... 589
14.1 Preparation: Sizing, Hardware Choices, and More ... 590
14.2 Planning the System Landscape ... 601
14.3 Bootstrapping the System ... 615
14.4 Summary ... 638
15. Tools for Performance Analysis ... 639
15.1 Load Diagram ... 639
15.2 Alerts Tab ... 642
15.3 Expensive Statements Trace ... 642
15.4 EXPLAIN PLAN ... 644
15.5 PlanViz ... 645
15.6 Further Resources ... 668
15.7 Summary ... 669
16. Monitoring and Root-Cause Analysis ... 671
16.1 Monitoring ... 671
16.2 Error Messages ... 675
16.3 Diagnostic Files ... 681
16.4 Server Side Traces ... 692
16.5 Client-Side Traces ... 701
16.6 Summary ... 706
The Authors ... 709
Index ... 711
6.4 Summary ... 274
7. Objects ... 275
7.1 Common Properties of Database Objects ... 276
7.2 Tables ... 290
7.3 Triggers and Constraints ... 292
7.4 SQL Views ... 295
7.5 Column Views ... 302
7.6 Sequences ... 305
7.7 Procedures and Functions ... 312
7.8 Synonyms ... 313
7.9 Summary ... 315
8. Table Types ... 317
8.1 Common Properties of All Tables ... 318
8.2 Row Store Tables ... 319
8.3 Column Store Tables ... 324
8.4 Special Types of Tables ... 338
8.5 Summary ... 345
9. Working with Tables ... 347
9.1 Loading Tables to and from Memory ... 347
9.2 Running Delta Merges ... 356
9.3 Partitioning and Distributing Tables ... 365
9.4 Optimizing Table Distribution and Partitioning ... 381
9.5 Importing and Exporting Tables ... 395
9.6 Checking Tables for Consistency ... 409
9.7 Summary ... 411
10. Sessions and Transactions ... 413
10.1 Introduction to Sessions and Transactions ... 413
10.2 Processes and Threads ... 428
10.3 Monitoring Sessions and Transactions ... 445
10.4 Concurrency and Parallelism ... 451
10.5 Summary ... 465
11. Working with the Repository ... 467
11.1 Properties of the SAP HANA Repository ... 467
11.2 Creating and Editing Objects in SAP HANA Studio ... 477
11.3 Deleting Development Objects in SAP HANA Studio ... 486
11.4 Mechanisms for Exporting and Importing Objects ... 488
11.5 Change Recording and Transports ... 491
11.6 Summary ... 494
12. User Management and Security ... 497
12.1 Essential Security-Related Concepts ... 498
12.2 Database Users ... 498
12.3 Authentication Methods ... 516
12.4 Securing SAP HANA's Network Interfaces ... 525
12.5 Auditing in the Database ... 534
12.6 Summary ... 541
13. Roles and Privileges ... 543
13.1 Database Roles ... 543
13.2 Privileges in the Database Catalog and Repository ... 553
13.3 Types of Privileges in SAP HANA ... 560
13.4 Critical Privileges and Privilege Combinations ... 570
13.5 Standard Roles for SAP HANA Systems ... 575
13.6 Troubleshooting Authorization Issues ... 575
13.7 Summary ... 587
14. Planning and Setting Up an SAP HANA System Landscape ... 589
14.1 Preparation: Sizing, Hardware Choices, and More ... 590
14.2 Planning the System Landscape ... 601
14.3 Bootstrapping the System ... 615
14.4 Summary ... 638
15. Tools for Performance Analysis ... 639
15.1 Load Diagram ... 639
15.2 Alerts Tab ... 642
15.3 Expensive Statements Trace ... 642
15.4 EXPLAIN PLAN ... 644
15.5 PlanViz ... 645
15.6 Further Resources ... 668
15.7 Summary ... 669
16. Monitoring and Root-Cause Analysis ... 671
16.1 Monitoring ... 671
16.2 Error Messages ... 675
16.3 Diagnostic Files ... 681
16.4 Server Side Traces ... 692
16.5 Client-Side Traces ... 701
16.6 Summary ... 706
The Authors ... 709
Index ... 711
... weniger
Autoren-Porträt von Lars Breddemann, Richard Bremer
Bremer, RichardRichard joined SAP's Active Global Support in 2008 and moved to the SAP HANA Customer Solution Adoption team in 2010, focusing especially on DBA topics and data modeling. Since the beginning of 2013, he has led the SAP HANA program within CSA, which consists of about 20 product experts from around the world.Breddemann, LarsLars Breddemann has been working with database management systems since 1998 as a developer, DBA, supporter, and systems architect. Having worked in SAP AGS product support since 2003, he has experience with multiple database technologies (Oracle, SAP MaxDB/liveCache), SAP Business Warehouse, and, since 2010, SAP HANA. In 2011, he moved to the Customer Solution Adoption (CSA) team, where he assumed the role of SAP HANA expert. Specializing in core database technology, development, supportability, and performance analysis, Lars educated hundreds of users, partners, and colleagues and has been called into projects around the globe as the go-to authority. Lars is an acclaimed SAP TechEd speaker, a leading SCN contributor and moderator, and was appointed as one of the first SAP HANA Distinguished Engineers in 2012.
Bibliographische Angaben
- Autoren: Lars Breddemann , Richard Bremer
- 2014, 722 Seiten, Maße: 18,4 x 23,6 cm, Gebunden, Englisch
- Verlag: SAP Press
- ISBN-10: 1592299520
- ISBN-13: 9781592299522
- Erscheinungsdatum: 25.08.2014
Sprache:
Englisch
Kommentar zu "SAP HANA Administration"
Schreiben Sie einen Kommentar zu "SAP HANA Administration".
Kommentar verfassen