X hits on this document

Word document

SAP with Microsoft SQL Server 2005: Best Practices for High Availability, Maximum Performance, and ... - page 4 / 76

236 views

0 shares

0 downloads

0 comments

4 / 76

Multi-instance support for SAP components35

SAP database configuration35

SQL Server configuration for SAP35

SAP settings for the SQL Server lock manager44

SQL Server 2005 Data-Availability Features45

Backup and recovery improvements45

Online backups45

Media reliability46

Database snapshots47

Online indexing47

Performance Monitoring and Tuning49

SQL Server performance monitoring49

SQL Server Profiler49

Dynamic management views49

Monitoring index usage50

sys.dm_db_index_usage_stats51

SAP performance tuning52

Common performance problems52

System performance is poor53

Database server causes slowdown55

CPU is pegged55

I/O is very slow56

Slow SAP transactions hamper the user experience58

Special Considerations for SAP BW63

SAP BW queries63

SAP BW table partitioning64

Range partitioning64

Missing or outdated optimizer statistics65

Creating aggregates65

Loading and maintaining infocubes67

64-Bit Computing Configurations68

32-Bit computing architecture68

64-Bit computing architecture68

SQL Server 2005, Enterprise Edition (64-bit)69

SAP applications on a 64-bit platform71

SAP availability and support of 64-bit platforms71

Related Links and Online Resources72

Document info
Document views236
Page views236
Page last viewedSun Dec 04 18:57:51 UTC 2016
Pages76
Paragraphs1372
Words23715

Comments