Expert Content
SAP Note: FAQ Microsoft SQL Server in NetWeaver based systems
Have a look at the central resource with pointers to official SAP and Microsoft documentation regarding SAP NetWeaver on Microsoft SQL Server systems.
SAP Note 555223
SQL Server Columnstore on SAP ERP
In SAP NetWeaver on SQL Server 2016 and newer, you can define additional Columnstore Indexes for reporting. Customers have seen performance improvements by factors.
MSDN Blog: Customer Experience with Columnstore on ERP
New Version of the White Paper: Best Practices for SAP on SQL Server
Read the new version of the white paper covering best practices for high availability, maximum performance, and scalability for SAP on SQL Server 2014, 2012, or SQL Server 2008 R2
Read the MSDN Blog here
SQL Server I/O Requests Take Longer Than 15 Seconds
This blog explains the deatils for a common SQL Server error message. It will help you better understand and classify the unterlying problem with the storage layer
MSDN Blog: SQL Server has encountered I/O requests taking longer than 15 seconds
AlwaysOn - Synchronize SAP Logon, Jobs, and Objects
Read about how to synchronize the SQL Server Agent job across all AlwaysOn nodes in an SQL Server AlwaysOn environment.
MSDN Blog: Always On – Synchronize SAP login, jobs and objects
VMWare vSphere 6: Fix for Performance Degration Due to Hypervisor Issue
VMWare published the patch for ESXi 6.9 update 2.vFor more information, see the updated VMWare KB article
View the Article
Architecting Microsoft SQL Server on VMWare vSphere - Best Practices Guide
For information about configurations of vSphere and SQL Server, read the Best Practices Guide.
Updated: Microsoft SQL Server on vSphere Best Practices Guide