SAP Database Administration with MS SQL Server 2000

• Gebundenes Buch

Produktbeschreibung

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.

Produktdetails

• Verlag: Rheinwerk Verlag
• Seitenzahl: 328
• Englisch
• Abmessung: 240mm
• Gewicht: 674g
• ISBN-13: 9781592290055
• ISBN-10: 1592290051
• Artikelnr.: 34009647

Autorenporträt

Paul Read has worked for SAP AG for twelve years. Having written technical documentation and coordinated its production at SAP, he is now with SAP Active Global Support. For the last two years he has been responsible for technical support and training for SQL Server.

Inhaltsangabe

Foreword ... 11 Preface ... 13 Acknowledgements ... 17 1. 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 ... 38 2. 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 ... 56 3. 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 ... 100 4. Installation and Configuration ... 109 ... 4.1 Planning ... 110 ... 4.2 Preparation ... 114 ... 4.3 Installation ... 117 ... 4.4 Post-installation Activities ... 120 5. 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 ... 157 6. 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 ... 203 7. 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 ... 254 8. 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 ... 282 9. 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 ... 298 10. 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 ... 318 11. Bibliography ... 321 Index ... 323