Sunday, March 26, 2017
 
Updates from SQL-SAP Team @ Microsoft
Facebook Twitter LinkedIn Google+ Addthis

Get Aggregated RSS

SAP Business Objects support of SQL Server 2016 and Azure products

Thursday, March 09, 2017

These days, we get a lot of questions around SAP Business Objects components supporting SQL Server 2016. As of February 2017, the support situation looks like: SAP BusinessObjects BI Platform 4.1: As of SAP BusinessObjects BI Platform 4.1 SP09, SAP introduced support for SQL Server 2016 which got released for SAP NetWeaver in 2016 already... Read more

Windows 2016 is now Generally Available for SAP

Tuesday, March 07, 2017

Windows 2016 has been released by Microsoft and is now Generally Available for any SAP NetWeaver 7.0 or higher components. Release information can be found in SAP Note 2384179 – SAP Systems on Windows Server 2016 This blog discusses the relevant SAP Notes and release information. For the official release status of individual SAP applications... Read more

BW Queries by factors faster using FEMS-pushdown

Monday, March 06, 2017

Complex SAP BW queries often contain FEMS-filters. These filters used to be applied on the SAP application server, which was not very efficient. A new SQL statement generator in SAP BW implements an optimized algorithm for FEMS processing. We have seen performance improvements up-to factor 100. The actual performance improvement varies heavily for different BW... Read more

Recent SAP BW improvements for SQL Server

Thursday, January 05, 2017

Over the course of the last few months we implemented several improvements in SAP BW. We already blogged about two improvements separately: https://blogs.msdn.microsoft.com/saponsqlserver/2016/11/14/simplified-and-faster-sap-bw-process-chains https://blogs.msdn.microsoft.com/saponsqlserver/2016/11/25/improved-sap-compression-tool-msscompress In this blog we want to describe a few, additional improvements BW query performance of F4-Help Some BW queries were not using intra-query parallelism, because the BW statement generator did not... Read more

SAP Now Supports Azure Resource Manager (ARM) for Windows and Linux

Friday, December 16, 2016

On 13/12 SAP updated SAP Note 1928533 (login required) to include support for SAP systems on Windows on virtual machines that are created using the Azure Resource Manager. The documentation on docs.microsoft.com was updated to reflect the change. You can now use virtual machines that are created using the Azure Resource Manager for both Windows... Read more

How to install or upgrade SAP Systems to SQL Server 2016 *updated*

Friday, December 09, 2016

On 4/10/2016, SAP released support for SQL Server 2016 for some SAP NetWeaver based systems. In this blog we will talk about how you can update your existing installations on SQL Server to SQL Server 2016, what you need to do when installing a new SAP NetWeaver based system on SQL Server 2016 and what... Read more

Top 14 Updates and New Technologies for Deploying SAP on Azure

Sunday, December 04, 2016

Below is a list of updates, recommendations and new technologies for customers moving SAP applications onto Azure. At the end of the blog is a checklist we recommend all customers follow with planning to deploy SAP environments on Azure. 1. High Performance & UltraPerformance Gateway The UltraPerformance Gateway has been released. This Gateway supports only... Read more

Improved SAP compression tool MSSCOMPRESS

Friday, November 25, 2016

SAP program MSSCOMPRESS is a tool for reducing disk space usage of SAP NetWeaver based systems. In addition, it is often used as a monitoring tool. MSSCOMPRESS has been released by SAP over 6 years ago. In the meanwhile, several improvements have been implemented. The latest version of MSSCOMPRESS is available as an attachment of... Read more

SAP OS/DB Migration to SQL Server–FAQ v6.1 November 2016

Wednesday, November 23, 2016

The FAQ document attached to this blog is the cumulative knowledge gained from hundreds of customers that have moved off UNIX/Oracle and DB2 to Windows and SQL Server in recent years. In this document a large number of recommendations, tools, tips and common errors are documented.  It is recommended to read this document before performing... Read more

Moving from SAP 2-Tier to 3-Tier configuration and performance seems worse

Sunday, November 20, 2016

Lately we were involved in a case where a customer moved a SAP ERP system from a 2-Tier configuration to a 3-Tier configuration in virtualized environments. This was done because the customer virtualized the system and could not provide VMs large enough on the new host hardware to continue with a 2-Tier SAP setup. Hence... Read more

HOME   |   SQL ARTICLES   |   SCRIPTS   |   DISCUSSIONS   |   SQL TEAMS   |   JOBS   |   ABOUT US
Copyright [2014] by SQLCOMMUNITY.COM