Table 1: Highlights of the Microsoft-SAP partnership across SQL Server releases SQL Server 2005 SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 Online index Data and index UCS2 compression, AlwaysOn: multiple maintenance compression reducing space secondaries and backup requirements for from secondary Database mirroring Backup compression SAP Unicode Auditing for non-SAP Supportability features Minimal logging implementations database access for SAP x64 release upgrade for high Improved hashkey Column store for SAP Table partitioning for availability and disaster algorithm for SAP BW SAP BW recovery scenarios migrations Extended online table Missing index Transparent data No data movement maintenance recommendations encryption during partition 15,000 partitions per operation Single page restore Automatic repair table 256 CPU support Support for OS Maximum number of CPU (Windows 2012 = 640 CPU)
Table 1: Highlights of the Microsoft-SAP partnership across SQL Server releases SQL Server 2005 SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 Online index maintenance Database mirroring Supportability features for SAP x64 release Table partitioning for SAP BW Missing index recommendations Single page restore Data and index compression Backup compression Minimal logging upgrade for high availability and disaster recovery scenarios Transparent data encryption Automatic repair UCS2 compression, reducing space requirements for SAP Unicode implementations Improved hashkey algorithm for SAP migrations No data movement during partition operation 256 CPU support AlwaysOn: multiple secondaries and backup from secondary Auditing for non-SAP database access Column store for SAP BW Extended online table maintenance 15,000 partitions per table Support for OS Maximum number of CPU (Windows 2012 = 640 CPU)
Security%20Guide%20for%20SAP%20on%20SQL%20v2.0.docx