SE11 Technical settings

[#1]

Hello Experts,

We upgraded our ECC system to EHP7 For 6.0 and  MSSQL DB to 2012. After upgrade I see a new tab 'DB-Specific Properties'

in the technical settings in SE11.

Its set to Column Store for most of tables. It this option correct? or do we need to change it to Row Store? The reason I

am bringing this discussion is because we have noticed our batch jobs are now taking more time. Not sure if this is the

culprit? Please share your thoughts if you have any information about this tab and what is right option to choose for

better MSSQL 2012 performance . Thank you!

[Former Member]

This message was moderated.

[sundaresan_k]

Dear Shammi,

This setting is only relevant when the underlying database is HANA as mentioned in the documentation

"The storage type only applies if the current database is an SAP HANA database. The specified storage type is ignored by other database systems. In this case, the platform-specific storage type is used."

Hope this helps

Best regards

Sundar

[Former Member]

Thank you Sundaresan for your valuable inputs. We raised a ticket for SAP.SAP said there is no need to change any settings and going forward they are going to hide this tab for MS-SQL server.They also confirmed this setting has no impact on performance in MS-SQL systems.

Thanks again!