Required SQL Server patch for Columnstore

Published Mar 13 2019 10:31 AM 140 Views
Microsoft

This week we increased the minimum required SQL Server 2014 patch for using the Columnstore with SAP BW. You should upgrade to:



As a matter of course you might apply any newer SQL Server Patch instead. You can always download the latest SQL Server patches from: http://technet.microsoft.com/en-us/sqlserver/ff803383.aspx .

SQL Server 2014 SP1 CU1 solves particularly the following issues:

    1. Sporadic issues with SQL error 35377 do not occur any more.
      See SAP Note 2153188 - SQL Error 35377 for details

 

    1. BW cube compression of the Flat Cube is much faster:
      See SAP Note 2153188 - SQL Error 35377 for details

 

    1. A potential issue regarding a physical inconsistency is fixed.
      See https://support.microsoft.com/en-us/kb/3067257 for details. Although we have never seen this issue on an SAP system yet, we strongly recommend applying the SQL Server patch above.



We have updated SAP Note 2116639 - SQL Server 2014 Columnstore documentation , which always contains the latest news regarding SQL Server Columnstore on SAP BW.







%3CLINGO-SUB%20id%3D%22lingo-sub-367905%22%20slang%3D%22en-US%22%3ERequired%20SQL%20Server%20patch%20for%20Columnstore%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-367905%22%20slang%3D%22en-US%22%3E%3CUL%3E%0A%3CLI%3E%3CSTRONG%3E%3CEM%3EFirst%20published%20on%20MSDN%20on%20Jun%2029%2C%202015%20by%20Martin%20Merdes.%20%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3E%3CEM%3EThis%20blog%20post%20might%20be%20outdated%20by%20now.%26nbsp%3BThe%20latest%20documentation%20regarding%20SQL%20Server%20Columnstore%20on%20SAP%20is%20available%20in%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.sap.com%2Fdocuments%2F2019%2F04%2F023e5928-487d-0010-87a3-c30de2ffd8ff.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.sap.com%2Fdocuments%2F2019%2F04%2F023e5928-487d-0010-87a3-c30de2ffd8ff.html%3C%2FA%3E%20and%20in%26nbsp%3BSAP%20Note%202116639%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3E%3CEM%3EThe%20performance%20impact%20of%20SQL%20Server%20Columnstore%20is%20described%20in%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FRunning-SAP-Applications-on-the%2FPerformance-evolution-of-SAP-BW-on-SQL-Server%2Fba-p%2F368073%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FRunning-SAP-Applications-on-the%2FPerformance-evolution-of-SAP-BW-on-SQL-Server%2Fba-p%2F368073%3C%2FA%3E%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EThis%20week%20we%20increased%20the%20minimum%20required%20SQL%20Server%202014%20patch%20for%20using%20the%20Columnstore%20with%20SAP%20BW.%20You%20should%20upgrade%20to%3A%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%3CUL%3E%0A%3CUL%3E%0A%3CLI%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fkb%2F3067839%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ESQL%20Server%202014%20SP1%20Cumulative%20Update%201%20%3C%2FA%3E%20.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3C%2FUL%3E%0A%3CP%3E%3CBR%20%2F%3E%3CBR%20%2F%3EAs%20a%20matter%20of%20course%20you%20might%20apply%20any%20newer%20SQL%20Server%20Patch%20instead.%20You%20can%20always%20download%20the%20latest%20SQL%20Server%20patches%20from%3A%20%3CA%20href%3D%22http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Fsqlserver%2Fff803383.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Ftechnet.microsoft.com%2Fen-us%2Fsqlserver%2Fff803383.aspx%20%3C%2FA%3E%20.%20%3CBR%20%2F%3E%3CBR%20%2F%3ESQL%20Server%202014%20SP1%20CU1%20solves%20particularly%20the%20following%20issues%3A%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%0A%3COL%3E%0A%3COL%3E%0A%3CLI%3ESporadic%20issues%20with%20SQL%20error%2035377%20do%20not%20occur%20any%20more.%20%3CBR%20%2F%3ESee%20%3CA%20href%3D%22https%3A%2F%2Fservice.sap.com%2Fsap%2Fsupport%2Fnotes%2F2153188%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%20SAP%20Note%202153188%20-%20SQL%20Error%2035377%20%3C%2FA%3E%20for%20details%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3C%2FOL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%3E%0A%3COL%3E%0A%3CLI%3EBW%20cube%20compression%20of%20the%20Flat%20Cube%20is%20much%20faster%3A%20%3CBR%20%2F%3ESee%20%3CA%20href%3D%22https%3A%2F%2Fservice.sap.com%2Fsap%2Fsupport%2Fnotes%2F2153188%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%20SAP%20Note%202153188%20-%20SQL%20Error%2035377%20%3C%2FA%3E%20for%20details%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3C%2FOL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3COL%3E%0A%3COL%3E%0A%3CLI%3EA%20potential%20issue%20regarding%20a%20physical%20inconsistency%20is%20fixed.%20%3CBR%20%2F%3ESee%20%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fkb%2F3067257%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Fkb%2F3067257%20%3C%2FA%3E%20for%20details.%20Although%20we%20have%20never%20seen%20this%20issue%20on%20an%20SAP%20system%20yet%2C%20we%20strongly%20recommend%20applying%20the%20SQL%20Server%20patch%20above.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3C%2FOL%3E%0A%3CP%3E%3CBR%20%2F%3E%3CBR%20%2F%3EWe%20have%20updated%20%3CA%20href%3D%22https%3A%2F%2Fservice.sap.com%2Fsap%2Fsupport%2Fnotes%2F2116639%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3E%20SAP%20Note%202116639%20-%20SQL%20Server%202014%20Columnstore%20documentation%20%3C%2FA%3E%20%2C%20which%20always%20contains%20the%20latest%20news%20regarding%20SQL%20Server%20Columnstore%20on%20SAP%20BW.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-367905%22%20slang%3D%22en-US%22%3E%3CUL%3E%0A%3CLI%3E%3CSTRONG%3E%3CEM%3EFirst%20published%20on%20MSDN%20on%20Jun%2029%2C%202015%20by%20Martin%20Merdes.%20%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3E%3CEM%3EThis%20blog%20post%20might%20be%20outdated%20by%20now.%26nbsp%3BThe%20latest%20documentation%20regarding%20SQL%20Server%20Columnstore%20on%20SAP%20is%20available%20in%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.sap.com%2Fdocuments%2F2019%2F04%2F023e5928-487d-0010-87a3-c30de2ffd8ff.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.sap.com%2Fdocuments%2F2019%2F04%2F023e5928-487d-0010-87a3-c30de2ffd8ff.html%3C%2FA%3E%20and%20in%26nbsp%3BSAP%20Note%202116639%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3E%3CEM%3EThe%20performance%20impact%20of%20SQL%20Server%20Columnstore%20is%20described%20in%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FRunning-SAP-Applications-on-the%2FPerformance-evolution-of-SAP-BW-on-SQL-Server%2Fba-p%2F368073%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FRunning-SAP-Applications-on-the%2FPerformance-evolution-of-SAP-BW-on-SQL-Server%2Fba-p%2F368073%3C%2FA%3E%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-367905%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ebw%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ecolumnstore%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENews%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPerformance%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎May 10 2019 01:36 AM
Updated by: