Skip to Content
0

In Memory functionality SQL server

Nov 03, 2017 at 01:05 AM

40

avatar image

Could SAP Business One use some of the in memory features of SQL server?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Johan Hakkesteegt Nov 03, 2017 at 08:17 AM
0

Hi Jonathan,

SAP Business One is a database driven application, and the database by default automatically uses its own in-memory capabilities.

Just install 12 GB more RAM in your server than the size of your company database, and MS SQL will load the whole thing into memory. You may also take a look at this article.

The difference with HANA is simply that the B1 HANA version gets some extra (mostly reporting) functionality out of the box. Otherwise there is little difference where in-memory functionality is concerned.

Regards,

Johan

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Does having an ssd affect performance? Any difference with sql 2012 and 2014 in sap b1?

0

Hi Jonathan,

My article should answer most questions, but to the point, simply put, yes ssd disks will have a positive effect, although more RAM will have a significantly larger positive impact for significantly less money.

The question is whether the B1 version in question supports either MS SQL version. But 2014 is obviously going to have improved in-memory capabilities compared to 2012. I can't say how much though.

Regards,

Johan

1