11-21-2014 7:18 AM
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!
11-21-2014 7:30 AM
Hi shammi,
I think this question is more related to SAP HANA ABAP. I think it would be helpful to you if posted in ABAP HANA forum.
thanks
Sri
11-21-2014 7:39 AM
OK thanks I will move it to HANA forums. Only reason I posted here is because we are not using HANA Db.
11-21-2014 8:56 AM
I would definitely contact SAP about this since you are not on HANA this should NOT be there..
11-21-2014 7:57 AM
It seems Column Store is the default so I think your settings are correct, so I would leave the setting as is. If you google this you can find quite a lot of info on this topic.
In my opinion this wouldn’t have an effect on your batch jobs, simply a setting which affects how HANA accesses this data.
11-21-2014 8:56 AM
11-24-2014 3:47 PM
MSSQL having those options
It must be a HANA DB as many pointed it out
11-24-2014 10:56 PM
This seems really odd. You should definitely contact SAP if this is not a HANA system.
11-24-2014 11:38 PM
11-25-2014 12:12 AM
Yep, we got it.
It actually makes sense that these options are there as HANA is not the only columnar DB in the market (I think). What worries me (and most people here, I reckon) is the fact that the tables are set as columnar in a non-columnar DB. You should definitely get to talk to SAP.
11-25-2014 12:28 AM
Hi Again,
just did some search and apparently MS-SQL is one of the DB with columnar storage. So, yes, these settings make absolute sense and yes, they also may be the cause of your problems. Unfortunately I don't know how to fix it, and my best suggestion is still the same: contact SAP.
Cheers,
Custodio
11-25-2014 7:46 AM
Hi Shammi,
You do not need to change the technical settings of a table. The column store is used by SAP (new technology introduced with SAP HANA) in order to provide better compression and performance, while using the table into our ABAP code.
Please leave it as it is because SAP ensures the best performance for the reports in this way.
While creating a new custom table, you can choose the option between column store and row store based on the type of data the table contains.
In case, the table contains Master & Organizational data then use Columnar store and for transnational data (since they change frequently) use row store.
Hope this answers your question.
Regards,
Arnab
12-18-2014 8:42 PM
Thank you everyone 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!