The Curious Engineer

All blogs / Databases

Running SAP Applications on the Microsoft Platform

learn.microsoft.com/en-us/archive/blogs/saponsqlserver

This blog provides information about running SAP Applications on the Microsoft Platform. The blog is written by people who are working with SAP on the Microsoft Platform for decades.

DatabasesDevOps / SRE / infrastructureMicrosoft blogsMSDN archive

’10’15’20’25
Posts
267 from 22 May 2007 to 20 May 2019
Posting
archived, read-only
Kind
company blog
Feed
https://learn.microsoft.com/en-us/archive/blogs/saponsqlserver/feed.xml

2019 3

  1. New BLOG location
  2. SAP on Azure High Availability Systems with Heterogenous Windows and Linux Clustering and SAP HANA
  3. S/4H Installation in Azure - SETUP AND CONFIG IN ONE DAY

2018 14

  1. SAPS ratings on Azure VMs – where to look and where you can get confused
  2. Moving SAP on SQL Server and Windows into Azure – what SQL Server and Windows release should I use
  3. Orica’s S/4HANA Foundational Architecture Design on Azure
  4. SAP Support for SQL Server 2017
  5. SAP on SQL Server on Azure – How to Bypass Proxy Server During Backup to URL
  6. Installation and Setup of Oracle 12.2 ASM on Oracle Linux on Azure – Installation Videos & Backup Strategies
  7. Installation Procedure for Sybase 16. 3 Patch Level 3 Always-on + DR on Suse 12. 3 – Recent Customer Proof of Concept
  8. SAP on Azure: General Update – June 2018
  9. Flat Cube became default in SAP BW
  10. Columnstore became default in SAP BW
  11. Very Large Database Migration to Azure – Recommendations & Guidance to Partners
  12. Setting Up Hana System Replication on Azure Hana Large Instances
  13. SAP on Azure: General Update – January 2018
  14. Improve SAP BW Performance by Applying the Flat Cube

2017 22

  1. Customer Experience with Columnstore on ERP
  2. SAP NetWeaver Installation on HANA database
  3. File Server with SOFS and S2D as an Alternative to Cluster Shared Disk for Clustering of an SAP (A)SCS Instance in Azure is Generally Available
  4. Distributed Availability Groups extended
  5. Few interesting findings on HANA with MDC
  6. New SQL Server 2016 functionality helps SAP supportability
  7. High Available ASCS for Windows on File Share – Shared Disk No Longer Required
  8. Migrating to SAP HANA on Azure
  9. Customer experience with SAP BW FEMS-Pushdown
  10. End to End Setup for SAP HANA Large Instances
  11. Parallel Processing in SAP
  12. Performance evolution of SAP BW on SQL Server
  13. SAP OS/DB Migration to SQL Server–FAQ v6.2 April 2017
  14. SAP on Azure: General Update for Customers & Partners April 2017
  15. Transparent Data Encryption (TDE) acceleration for SQL 2016 in Windows Azure
  16. Using Columnstore on ERP tables
  17. More Questions From Customers About SQL Server Transparent Data Encryption – TDE + Azure Key Vault
  18. Large Australian Energy Company Modernizes SAP Applications & Moves to Azure Public Cloud
  19. SAP Business Objects support of SQL Server 2016 and Azure products
  20. Windows 2016 is now Generally Available for SAP
  21. BW Queries by factors faster using FEMS-pushdown
  22. Recent SAP BW improvements for SQL Server

2016 21

  1. SAP Now Supports Azure Resource Manager (ARM) for Windows and Linux
  2. How to install or upgrade SAP Systems to SQL Server 2016 *updated*
  3. Top 14 Updates and New Technologies for Deploying SAP on Azure
  4. Improved SAP compression tool MSSCOMPRESS
  5. SAP OS/DB Migration to SQL Server–FAQ v6.1 November 2016
  6. Moving from SAP 2-Tier to 3-Tier configuration and performance seems worse
  7. Simplified and faster SAP BW Process Chains
  8. SQL Server 2016 improvements for SAP (BW)
  9. Where can I find documentation or information for ....?
  10. In a changing market we now offer a broader spectrum of topics
  11. How to slowdown a SQL Server Database Backup
  12. More offers in SAP Cloud Appliance Library for Azure
  13. SQL Server 2016 Distributed Availability Groups for SAP
  14. New Azure PowerShell cmdlets for Azure Enhanced Monitoring
  15. Azure Quickstart Templates for SAP
  16. Protecting SAP Systems Running on VMware with Azure Site Recovery
  17. SQL Server 2016 AlwaysOn for SAP
  18. Whitepaper SAP on SQL Server 2012 and SQL Server 2014
  19. Always On - Synchronize SAP login, jobs and objects
  20. The Azure Monitoring Extension for SAP on Windows – Possible Error Codes and Their Solutions
  21. Improvements of SAP (BW) System Copy

2015 23

  1. SAP MaxDB, SAP liveCache and SAP Content Server are certified to run in Microsoft Azure Cloud
  2. SQL Server AlwaysOn - Summary
  3. VMWare Vulnerability can cause Database Inconsistencies
  4. Data distribution and SQL Plans
  5. World Record SAP Sales and Distribution Standard Application Benchmark for SAP cloud deployments released using Azure IaaS VMs
  6. Foodstuffs North Island Retire Legacy Technology and Lower Costs by Moving Decommissioned SAP Systems to Azure on Demand
  7. Global Advisory Firm Improves SAP BW Performance and Lowers Costs by Moving SAP Landscape to Windows & SQL Server on Azure and Hyper-V
  8. Required SQL Server patch for Columnstore
  9. How to Size SAP Systems Running on Azure VMs
  10. Clustering SAP ASCS Instance using Windows Server Failover Cluster on Microsoft Azure with SIOS DataKeeper and Azure Internal Load Balancer
  11. Max degree of parallelism (MaxDOP)
  12. Azure Premium Storage is available for SAP workloads
  13. WORST Practices for Maintaining SQL Server SAP systems (i.e. Things to AVOID)
  14. Important Information for those Customers still using Windows 2003 – April 2015
  15. Columnstore Optimized Flat Cube in SAP BW
  16. Concepts of SQL Server 2014 Columnstore
  17. SQL Server 2014 Columnstore: Released for SAP BW
  18. Software Logistics on SQL Server 2014
  19. SQL Server 2014 now released by SAP for SAP NetWeaver 7.xx
  20. SAP Support for Microsoft KBA 2964518
  21. Deadlock Analysis (Advanced)
  22. Deadlock Analysis (Examples)
  23. SQL Server Column-Store for SAP BW: Status and Release Planning

2014 22

  1. SQL Agent Jobs in an AlwaysOn / Mirroring Environment
  2. Protecting SAP Solutions with Azure Site Recovery
  3. Setup of WSFC with Azure Virtual Machines and SIOS Datakeeper using Azure Powershell
  4. More Azure VMs supported by SAP now
  5. Message misaligned log IOs which required falling back to synchronous IO in SQL Server Error Log
  6. Client Aware Parameter for Multiple Clients has been Defaulted to Enabled
  7. Azure Extended monitoring for SAP
  8. SAP GUI connection closed when connecting to SAP system in Azure
  9. SAP Notes around Azure released
  10. Azure as platform supported by SAP soon
  11. SQL Server 2012 Column Store Deployment Accelerates BW Queries and Improves Storage Efficiency
  12. SAP on SQL General Update for Customers & Partners April 2014
  13. SAP OS/DB Migration to SQL Server–FAQ v5.2 April 2014
  14. Windows Server 2012 R2 is Generally Available for NetWeaver Applications April 2014
  15. SQL Server Column-Store with SAP BW Aggregates
  16. Increasing BW cube compression performance
  17. New functionality in SQL Server 2014 – Part 5 – Backup/Restore Enhancements
  18. New functionality in SQL Server 2014 – Part4 - In-Memory OLTP
  19. Database Volume is compressed nicely – but now we want to shrink the data files
  20. New functionality in SQL Server 2014 – Part 3 – Low Priority Wait
  21. New functionality in SQL Server 2014 – Part 2 – New Cardinality Estimation
  22. New functionality in SQL Server 2014 – Part 1- Modifiable Column Store Index

2013 27

  1. SAPInst May Run Slowly on Windows 2012 or Windows 2012 R2
  2. FAQs CHECKDB in SAP SQL Server Databases…Again
  3. Corruption Handling in SAP Databases
  4. Auditing – audit all except the SAPService
  5. New Microsoft BI-SAP Integration whitepaper released
  6. SAP Private and Public Cloud Infrastructure -> Survey and Customer samples
  7. 9. Microsoft Private Cloud Solution for SAP: Landscape Design
  8. 6. Microsoft Private Cloud Solution for SAP: Configuration of Cluster Shared Volumes, VHDX, Disks & LUNs
  9. 1. Microsoft Private Cloud Solution for SAP: Hardware, Network & SAN
  10. How to Deploy SAP on Microsoft Private Cloud with Hyper-V 3.0
  11. SAP Hyper-V benchmark Released
  12. Infrastructure Recommendations for SAP on SQL Server: “in-memory” Performance
  13. SAP OS/DB Migration to SQL Server–FAQ v5.0 May 2013
  14. SAP High Availability in virtualized Environments running on Windows Server 2012 Hyper-V Part 1: Overview
  15. Analyzing JDBC connection issues
  16. FAQs Around Kerberos and SQL Server
  17. SAP Support for SQL Server 2012 - Update
  18. SQL Server 2012 AlwaysOn – Part 12 – Performance Aspects and Performance Monitoring II
  19. Pilot program for System Center Virtual Machine Manager 2012 SP1 connector for SAP LVM
  20. SQL Server 2012 AlwaysOn – Part 11 – Performance Aspects and Performance Monitoring I
  21. Windows Server 2012 Generally Available for SAP NetWeaver – April 2013
  22. Optimizing BW Query Performance
  23. Deadlock Analysis (Basic)
  24. AlwaysOn Part 10: Switching Scheduled tasks automatically
  25. AlwaysOn Part 9: AlwaysOn and Logshipping
  26. SQL Server 2012: Installing SAP Solution Manager 7.1 SR1
  27. SAP Software Provisioning Manager (70SWPM) for 7.0x

2012 38

  1. SAP on SQL General Update for Customers & Partners January 2013
  2. SQL Server Column-Store: Updated SAP BW code
  3. Effect of Windows Power Mode on SAP Netweaver Applications
  4. Confusion around Initial Values marker in SAP Table Definition
  5. SQL Server Column-Store available for all major SAP BW releases
  6. SAP NetWeaver and Hyper-Threading on Windows Servers : to be or not to be
  7. SAP starts Windows Server 2012 First Customer Shipment program
  8. Microsoft and SAP NetWeaver – step by step up to the cloud – Part V : simple online SAP System copy
  9. SAP Software Provisioning Manager (SWPM)
  10. SAP Tools for MS SQL Server now part of SWPM
  11. How Update Statistics really works in SAP BW
  12. SAP BW improvements in new Support Package
  13. SQL Server 2012: Installing SAP systems based on SAP NetWeaver 7.31
  14. SQL Server 2012: Installing SAP systems based on SAP NetWeaver 7.30
  15. Microsoft and SAP NetWeaver – step by step up to the cloud – Part IV : simple offline copy of a central system
  16. How to enable SAP "enhanced monitoring" via Powershell
  17. SQL Server 2012 AlwaysOn – Part 8 – Failover Mechanism with SAP Netweaver
  18. SAP Support for SQL Server 2012
  19. SQL Server 2012: Installing SAP systems based on SAP NetWeaver 7.0 including EHP3
  20. SQL Server 2012: Installing SAP systems based on SAP NetWeaver 7.0 including EHP1
  21. SQL Server 2012: Installing SAP systems based on SAP NetWeaver 7.0 including EHP2
  22. SQL Server 2012: Installing SAP systems based on SAP NetWeaver 7.0
  23. SQL Server 2012 Enterprise Editions
  24. SAP on SQL Server Security Whitepaper Released
  25. Microsoft and SAP NetWeaver - step by step up to the cloud - Part III : some thoughts about automated Windows patching
  26. How to Setup a Dedicated SAP Application Server to DB Server Network
  27. SQL Server 2012 AlwaysOn – Part 6 – Building an AlwaysOn Availability Group
  28. SQL Server 2012 AlwaysOn – Part 5 – Preparing to build an AlwaysOn Availability Group
  29. Microsoft and SAP NetWeaver - step by step up to the cloud - Part II : automated installation of a SAP dialog instance
  30. SQL Server 2012 AlwaysOn – Part 4 – SAP configuration in Geo-Cluster configuration
  31. Too Many Virtual Log Files (VLFs) Can Cause Slow Database Recovery
  32. SQL Server 2012 AlwaysOn – Part 3 – SAP configuration with two Secondary Replicas
  33. SQL Server 2012 AlwaysOn – Part 2 - Quorum Detection
  34. SQL Server 2012 AlwaysOn – What is it?
  35. Microsoft and SAP NetWeaver - step by step up to the cloud - Part I : SCOM Integration with SAP
  36. SAP enhanced monitoring on Hyper-V
  37. Auto Update Statistics Async in SAP NetWeaver
  38. Network Settings, Network Teaming, Receive Side Scaling (RSS) & Unbalanced CPU Load

2011 27

  1. ABAP Select For All Entries - what is happening in SQL Server?
  2. Oracle to SQL SAP OS/DB Migration FAQ: Update January 2012 : v4.0
  3. Faster DBCC CHECKDB Released in SQL 2008 R2 SP1 CU4 : Traceflag 2562 & 2549
  4. Performance of index creation
  5. Microsoft JDBC driver 1.2: sqljdbc driver fails to establish secure connection
  6. Microsoft’s SAP Deployment and SQL Server 2012
  7. SAP 7.20 Downwards Compatible Kernel is Finally Released
  8. Upgrade Path to SQL 2008 (R2) and Windows Server 2008 R2
  9. How to virtualize SAP GUI using Microsoft App-V
  10. Uneven Windows Processor Groups
  11. SAP on SQL : General Update for Customers & Partners October 2011
  12. Changes to automatic update statistics in SQL Server – traceflag 2371
  13. Decreased disk space requirement for SAP Unicode systems
  14. How to integrate SQL Server specific hints in ABAP
  15. SQL Server Page Compression became default for SAP
  16. Problems with mounted volumes in a Cluster
  17. SAP on SQL Installation on Mount Points
  18. Accelerating Oracle -> SQL Server Migrations with Fusion-io ioMemory
  19. Customer Proof of Concept on New HP DL980
  20. NIPING – a useful tool from SAP
  21. Changes in affinity settings of SQL Server 2008 R2 to support > 64 Logical Processors
  22. How many logical processors does SQL Server 2008 R2 Enterprise Edition support
  23. Increased partition support of SQL Server in SAP BW
  24. SQL Server network encryption with SAP
  25. Online Disk Extension & Windows 2008 R2 Dynamic Memory are Fully Supported for SQL Server
  26. Installation & Configuration of Windows NFS Client to enable Windows to Mount a UNIX File System
  27. Extracting hierarchies from SAP BW 7.3

2010 32

  1. SAP BW 7 and SQL Server 2008 Star Join Optimization
  2. SAP Support of Windows Server 2008 R2
  3. Column Statistics – No need to create them manually
  4. PowerPivot – a new way of MS BI integration with SAP BW and non-SAP data sources
  5. SSRS 2008 R2 – a new way of MS BI integration with SAP BW and non-SAP data sources
  6. Compressing an SAP database using report MSSCOMPRESS
  7. SAP Now Support In Place Upgrade of Windows for SAP Systems
  8. Some interesting Blog Entries in the Blog site of our Microsoft LOB Practice team
  9. Partitioning Large NUMA Based Servers into Smaller SAP VMs - Question from Jason
  10. Windows 2008 R2 - Groups, Processors, Sockets, Cores Threads, NUMA nodes what is all this?
  11. Windows 2008 R2 Performance Monitor – Processor Information Counters have replaced Processor Counters
  12. Choosing SQL Server compression type for SAP
  13. SQL 2008 R2 is now fully supported by SAP
  14. Secondary Index Compression and Page compression supported by SAP
  15. SAP Landscape Management with SQL Server Policies
  16. Update to the SAP on Oracle -> Windows/SQL Server OS/DB Migration FAQ
  17. Two Database Mirroring cases in one week - one solution
  18. SAP OS/DB Migration to SQL Server - FAQ
  19. New Cluster Quorum Models in Windows 2008
  20. Frequently Asked Questions we heard on the SAP on SQL 2008 Training course this year
  21. 10 Reasons to Upgrade SAP systems to Windows 2008 / Windows 2008 R2
  22. Another great use of SQL Server Database Mirroring
  23. Analyzing Statements with Extended Events (Extended Events Part II)
  24. Extended Events with SAP (Part I)
  25. Sensitive question – CHECKDB when and how to execute it in large SAP systems
  26. SQL Server Change Data Capture with SAP
  27. Updated version of sp_use_db_compression – Version 2.42
  28. And another question around SQL Server Database Compression answered
  29. One question around SQL Server Database Compression
  30. Deletion of request in SAP BW orders of magnitude faster after installing SQL Server 2008 SP1 CU6
  31. Performance – what do we mean in regards to SAP workload?
  32. New hashkey algorithm for lockhash values introduced in SQL Server 2008 R2

2009 15

  1. Upgrade to SQL Server 2008 or SQL Server 2008 R2 with minimal downtime
  2. Microsoft’s SAP ERP system productive on SQL Server 2008 R2
  3. Version 2.3 of sap_use_db_compression released
  4. Two Questions in regards to UCS2 compression answered
  5. SQL Server 2008 R2 - UCS2 compression what is it - Impact on SAP systems
  6. New version of sp_use_db_compression available
  7. New SAP on SQL Server 2008 Whitepaper released
  8. SQL execution plans, part 3: how to get the plan
  9. Good Case study released on Customer who used SQL Server 2008 Database Compression
  10. Measuring Memory Consumption of SAP Application Server Instances
  11. Applying SQL Server 2008 Database Compression to SAP systems which already ran on SQL Server 2000 RTM and SP1
  12. SQL execution plans, part 2: SQL compilation
  13. Frequently asked Question - Why do we need SQL Server Enterprise Edition for SAP Netweaver based applications?
  14. SQL execution plans, part 1: SQL statement execution on an SAP system
  15. SAP declares support for SQL Server 2008 and Windows Server 2008

2008 14

  1. Procedure used for applying Database Compression to Microsoft SAP ERP system
  2. Update on Rollout of SQL Server 2008 Row Level Compression in Microsoft’s SAP ERP system
  3. SQL Server SPs, CUs and hotfixes for SAP
  4. SQL Server 2008 Row Level Compression Roll-Out in Microsoft’s SAP ERP system
  5. New Contributor to the blog “SAP on SQL Server”
  6. New and revised SAP OSS notes released
  7. Server running out of memory when copying backup files to other server
  8. Dealing with Scheduled Tasks in a SQL Server Environment using Database Mirroring
  9. SAP OSS notes describing Improvements for SAP Unicode and SAP Platform Migration released
  10. Windows and SQL Server Licensing under Virtualization
  11. SAP Beta Program for SQL Server 2008 started
  12. How does Microsoft perform Backups in their SAP system landscape
  13. Sporadic but periodic slow Inserts into a table - Why you should apply SQL Server 2005 SP2
  14. Using SAP Code Inspector to improve Quality and Performance

2007 9

  1. Proportional fill and how to check whether it works
  2. SAP Support for Windows Server 2008 and SQL Server 2008
  3. WebCast on SAP ERP Unicode Migration in Microsoft is available on Microsoft.com
  4. What did we learn using Database Mirroring over the last two years in our SAP ERP system. Second revision
  5. SAP DBACockpit and some related SQL Scripts (Part 3)
  6. Hotnews 1067103 released by SAP this week
  7. SAP DBACockpit and some related SQL Scripts (Part 2)
  8. SAP Multi Instance Clustering
  9. SAP Application leveraging SQL Server Automatic Update Statistics