SAP Database Administration with Microsoft SQL Server 2000

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