Thursday, March 4, 2010

Hardware Handling for SAP/SQL Server 2008

Here is an updated document of the Best Practices (including hardware design) of SQL Server 2008 implementation for SAP.

Most of the design foundations are applicable by logic to any other Database platform, excluding of course, specific SQLServer configuration.

I highly recommend its reading:

http://download.microsoft.com/download/d/9/4/d948f981-926e-40fa-a026-5bfcf076d9b9/SAP_SQL2008_Best%20Practices_Part_I.docx

For us, IT guys (and girls), I suggest you pay big attention to:

- Hardware selection (page 27)
- Installation and configuration (page 32)
- SQL Server on NUMA (page 56)
- Transparent Database Encryption (page 75)
- Windows Server specific configurations (page 95)

If you are new to SAP, or are just a DBA in your organization, I also suggest reading the introductory part of the document (What is SAP / How does SAP interact with SQL Server)

1 comment: