The SAP Database Performance Warehouse (DPW) contains key database performance indicators of your SAP system landscape for status reporting and long term performance analysis. It is used by the Solution Manager Diagnostics (SMD) back-end and is therefore an integrated part of SAP Solution Manager. 26 Jan 2012
Immense Disk Space Savings with SQL Server 2008 R2
SQL Server 2008 R2 uses an improved encoding algorithm for Unicode, also known as Unicode-compression. This results in less storage requirements for SAP Unicode systems. An SAP database therefore even shrinks during an SAP Unicode conversion. For more information, see the following blog. 22 Sep 2011
The DBA Cockpit and Microsoft SQL Server
The DBA Cockpit is a powerful feature for SAP NetWeaver applications. The following presentations provide tips and advice on how system administrators can use the DBA Cockpit for local monitoring and analysis of Microsoft SQL Server systems. Each presentation includes a PowerPoint with audible narration.
31 Aug 2011
Database compression dramatically reduces the disk space needed for an SAP NetWeaver system running on Microsoft SQL Server. In particular, SAP Unicode systems benefit greatly from database compression. Space savings of 75% and higher have been observed on customer systems. This document describes the different SQL Server compression types and how to implement compression for an SAP NetWeaver system. Customer feedback regarding PAGE compression was always positive. Therefore, SAP changed the default compression type from ROW to PAGE compression in May 2011. 05 May 2011
The SAP Database Performance Warehouse (DPW) contains key database performance indicators of your SAP system landscape for status reporting and long term performance analysis. It is used by the Solution Manager Diagnostics (SMD) back-end and is therefore an integrated part of SAP Solution Manager.
This presentation explains the Database Performance Warehouse (DPW) functionality and focuses specifically on monitoring Microsoft SQL Server based systems. 03 Jan 2011
SQL Server 2008 R2 now supported by SAP
SAP encourages its customers to upgrade to SQL Server 2008 R2 to benefit, for example, from more efficient Unicode-handling and new BI features. For more information about the new SQL Server 2008 R2 features, see the FAQs. SQL Server 2008 R2 is an enhancement to SQL Server 2008 and has the same code base. Therefore, there will be no entry for SQL Server 2008 R2 Enterprise Edition in the SAP Product Availability Matrix (http://service.sap.com/PAM). The support information for the SQL Server 2008 Enterprise Edition in the PAM automatically applies to the SQL Server 2008 R2 Enterprise Edition as well. For more information, see SAP note 1076022. 03 Jan 2011
Now available in its third edition with information both for SQL Server 2008 and SQL Server 2005. Read this white paper to know the best practices to install a high-availability SAP system on SQL Server 2008 or 2005, and to improve performance, scalability, and security. 09 Oct 2009
Loading...
Jairo Pedroza
12