Running SAP Applications on the Microsoft Platform
Copied!
Home
Options
2,079
Cameron_MSFT_SAP_PM on 01-09-2020 06:00 PM
4,851
Ben Trinh on 12-11-2019 09:39 AM
1,820
Sachin-Ghorpade on 12-02-2019 03:25 PM
2,498
Cameron_MSFT_SAP_PM on 11-17-2019 06:20 PM
2,599
Sachin-Ghorpade on 10-22-2019 11:52 AM
6,184
hobru on 09-21-2019 12:47 PM
3,381
Sachin-Ghorpade on 09-13-2019 11:47 AM
4,207
Cameron_MSFT_SAP_PM on 08-15-2019 04:59 AM
4,342
Cameron_MSFT_SAP_PM on 08-02-2019 04:34 PM
4,289
Cameron_MSFT_SAP_PM on 07-31-2019 12:50 PM
4,528
Sachin-Ghorpade on 07-17-2019 03:29 PM
4,508
Sachin-Ghorpade on 06-20-2019 09:38 AM
7,697
hobru on 06-11-2019 01:00 PM
5,038
Sachin-Ghorpade on 05-29-2019 10:50 AM
6,216
Goran Condric on 04-17-2019 03:35 AM
9,333
Cameron_MSFT_SAP_PM on 03-31-2019 01:51 PM
4,909
Sachin-Ghorpade on 03-25-2019 04:17 PM
5,004
Goran Condric on 03-20-2019 03:25 AM
6,590
Cameron_MSFT_SAP_PM on 03-20-2019 12:50 AM
4,477
Juergen Thomas on 03-13-2019 11:12 AM
4,192
Juergen Thomas on 03-13-2019 11:12 AM
4,019
Cameron_MSFT_SAP_PM on 03-13-2019 11:12 AM
4,387
mssedusch on 03-13-2019 11:12 AM
3,869
Cameron_MSFT_SAP_PM on 03-13-2019 11:12 AM
4,169
Cameron_MSFT_SAP_PM on 03-13-2019 11:11 AM
4,611
Cameron_MSFT_SAP_PM on 03-13-2019 11:11 AM
4,004
Cameron_MSFT_SAP_PM on 03-13-2019 11:05 AM
4,149
AzureCAT on 03-13-2019 11:04 AM
4,180
AzureCAT on 03-13-2019 11:04 AM
5,764
Cameron_MSFT_SAP_PM on 03-13-2019 11:04 AM
Latest Comments
Lot of useful information at single location. Thanks Cameron !!!
0 Likes
Interesting. So it loads those tables that had been in-memory right before the shutdown. We are getting closer to understand all the details, it seems....
0 Likes
Hi Werner, You raised some interesting points. I ran the SELECT query against the "sys"."tables" system view and found ALL of the tables in my BW schema have 'preload=false'. I looked further to learn why my HANA DB is preloading at every restart. I think I found the answer in SAP Note 2127458 - FAQ...
1 Likes
Thank you. Would it be possible to validate that? Two points come to mind:select table_name, is_preload, is_parital_preload from tables;Are all tables really set to preload=true?alter table <table_name> preload none;Create a script to change all BW tables to preload=false and then reboot the system ...
0 Likes
Hi Werner, My setup was the BW/4HANA benchmark. As such everyone who runs benchmark definitely don't want any loading during query execution. With that in mind, there hasn't been any selective unloads configured. By defaults all row and columns stores are in-memory in my case. Ben
1 Likes