SAP Database Administration with Microsoft SQL Server 2000

Paul Read (Autor)

Media-Kombination

328 Seiten

2002
SAP Press
978-1-59229-005-5 (ISBN)

Infos

This book offers you expert information about SAP database administration using Microsoft SQL Server 2000. The book treats all aspects of SQL Server and the SAP system that play a part in coordinating the two systems productively.You will learn how to handle routine administration tasks using SAP system tools, with the help of SQL Server tools. Besides providing guidance for practical administration, the author also gives suggestions for developing a database strategy tailored to your specific system landscape. Valuable techniques and indispensable tips for dealing with crises make this book especially useful. The Appendix describes all the parameters that are important for configuring Windows, the SAP instance profiles, and SQL Server.The book is based on SQL Server 2000. Where the 2000 version differs appreciably from SQL Server 7.0, this release is also considered.

Inhalt

Foreword ... 11Preface ... 13Acknowledgements ... 171. SAP Architecture ... 19... 1.1 SAP R/3 System Architecture ... 19... 1.2 SAP Work Processes ... 22... 1.3 SAP Instances ... 30... 1.4 SAP Transactions ... 32... 1.5 SAP Buffers ... 35... 1.6 SAP Clients ... 382. ABAP Dictionary ... 41... 2.1 Database Tables ... 42... 2.2 Data Elements and Domains ... 51... 2.3 Structures ... 54... 2.4 Views ... 55... 2.5 Search Helps ... 563. SQL Server Architecture ... 57... 3.1 SQL Server as an Operating System Process ... 57... 3.2 SQL Server Database Engine ... 58... 3.3 Connection Technology ... 67... 3.4 Memory Management ... 70... 3.5 Access Security ... 76... 3.6 Storage Allocation ... 78... 3.7 Indexes ... 87... 3.8 Stored Procedures ... 92... 3.9 Lock Management ... 94... 3.10 SQL Server Client Tools ... 1004. Installation and Configuration ... 109... 4.1 Planning ... 110... 4.2 Preparation ... 114... 4.3 Installation ... 117... 4.4 Post-installation Activities ... 1205. How the SAP System Uses SQL Server ... 131... 5.1 Components of an SAP Work Process ... 131... 5.2 Connections from SAP Work Processes to SQL Server ... 136... 5.3 Statement IDs ... 140... 5.4 Stored Procedures and ABAP Statements ... 143... 5.5 Stored Procedure Name Cache ... 1576. Database Administration ... 161... 6.1 Space Management ... 162... 6.2 Transaction Log Management ... 174... 6.3 Verifying Important SQL Server Settings ... 188... 6.4 Storage Allocation ... 2037. Performance Monitoring and Tuning ... 211... 7.1 Main Performance Indicators ... 214... 7.2 Database Response Times ... 222... 7.3 Histories of Performance Values ... 225... 7.4 Tuning ... 226... 7.5 Analyzing Expensive Statements ... 239... 7.6 Solutions for Expensive Statements ... 2548. Database Backup ... 259... 8.1 General Guidelines for Database Backup ... 259... 8.2 Backup Types ... 262... 8.3 Verifying Database Backups ... 269... 8.4 Database Backup Scenarios ... 273... 8.5 Archiving ... 2829. Database Restore ... 287... 9.1 Planning and Testing ... 287... 9.2 When will a Restore be Necessary? ... 288... 9.3 Outline of Restore Procedures and Scenarios ... 289... 9.4 Restore with and without msdb ... 293... 9.5 Restoring the master Database ... 295... 9.6 Point-in-Time Recovery ... 296... 9.7 Storage Media Failures ... 29810. Appendix ... 301... 10.1 Naming Conventions for Stored Procedures ... 301... 10.2 Parameters ... 304... 10.3 Overview of Parameters in SQL Server 2000 and SQL Server 7.0 ... 312... 10.4 RAID Technology ... 3148... 10.5 Tape Labeling Conventions ... 31811. Bibliography ... 321Index ... 323

Produkt-Details

• Erscheint lt. Verlag: 28.7.2002
• Sprache: englisch
• Maße: 168 x 240 mm
• Themenwelt: Informatik ► Datenbanken ► SQL Server
• Themenwelt: Mathematik / Informatik ► Informatik ► Netzwerke
• Schlagworte: Datenbank; Administration • Microsoft SQL Server 2000 • SAP R/3 Release 4; Systemadministration
• ISBN-10: 1-59229-005-1 / 1592290051
• ISBN-13: 978-1-59229-005-5 / 9781592290055
• Zustand: Neuware