Table partitioning in SQL SERVER

[Former Member]

Hi!

We have some huge tables in a SAP ERP that we would like to partition within SQL SERVER 2012SP1.

I have 2 questions:

- Have anyone partitioned tables in a SAP ERP running in a SQL SERVER?

- Have any of you done it during a migration or unicode conversion?

cheers

Fernando

[Sriram2009]

Hi Fernando

I thing the Table partitioning feature is available in SAP BI /BW systems not for ERP system, Kindly refer the SAP Note which takes about the BI system table

869407 - Partitioning on Microsoft SQL Server

For ERP DB you can perform the database level compression feature.

Still you are having debate better you can raise the ticket to SAP to get the clear information

Regards

Sriram