SAP application servers occasionally lose connections to the SQL Server database server. This paper discusses how to approach the problem of solving intermittent connection loss, and some common causes of connection problems. Important SAP notes and the preferred problem-solving approach are identified. 19 Feb 2014
The Database Performance Warehouse uses the SAP BW content of the SAP Solution Manager to store database specific performance metrics. The DBA Cockpit within Solution Manager provides flexible analysis reports for these metrics based on BW technology. Learn more about how you can use the report content for capacity planning, trending analysis, troubleshooting, etc.. 15 Feb 2013
SQL Server 2012 introduced a new storage format for data. Besides the traditional row-oriented store, there is now also a column-oriented store available. The column-oriented store is optimized for aggregating mass data, while the row-oriented store can be optimally used when accessing just a single row. SQL Server 2012 column-store support has been integrated into all major SAP BW releases. You can now benefit from increased query performance and reduced disk space requirements. 05 Nov 2012
SAP now supports SQL Server 2012 with SAP products based on SAP NetWeaver 7.0 (including all Enhancement Packages). For more information, see SAP Notes 1651862, 1684545, and 1676665 (SMP login required). Microsoft SQL Server is known as an out-of-the-box and easy-to-use database solution with low TCO. SQL Server 2012 offers many new features such as AlwaysOn, a set of functions for high availability and disaster recovery. For more information, see the FAQs and the following link. 13 Jul 2012
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.
For information about SAP DPW for the previous SAP Solution Manager version 7.0 EHP1, see the following presentation. 26 Jan 2012
Database compression dramatically reduces the disk space needed for an SAP NetWeaver system running on Microsoft SQL Server. As of SQL Server 2008 R2, this uses an improved encoding algorithm for Unicode, also known as Unicode-compression. This results in less storage requirements for SAP Unicode systems. Therefore, SAP databases containing some non-Latin1 data even shrink during an SAP Unicode conversion. For more information, see this blog. In May 2011, SAP also changed the default compression type from ROW to PAGE compression, which led to an additional dramatic reduction in the database size. For more information about the different SQL Server compression types and how to implement compression for an SAP NetWeaver system, see this document. 22 Sep 2011
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
|SAP with Microsoft SQL Server 2008 and SQL Server 2005: Best Practices for High Availability, Maximum Performance, and Scalability - Part I: SAP Architecture and SQL Server Basic Configurations, Features Used, and Windows Configurations 1 year ago||by Juergen Thomas|
|Could not find the "Generic Installation Options" in SWPM? 9 months ago||by Eduardo Rezende|
|SuccessFactors - Useful Resources and Documents 4 hours ago in SAP ERP Human Capital Management (SAP ERP HCM)||by Luke Marson|
|SQL Anywhere Web Edition is No Longer Available 9 hours ago in SAP SQL Anywhere||by Jose Ramos|
|Re: Multiplying two columns by CE functions 14 hours ago in ABAP for SAP HANA||by Peter Murphy|
|Re: Multiplying two columns by CE functions 15 hours ago in ABAP for SAP HANA||by Bilen Cekic|
|HCM EHP5, EHP6 and HR Renewal,Fiori Important links and documents 6 days ago in SAP ERP HCM Employee Self-Service||by Siddharth Rajora|