Running SAP Applications on the Microsoft Platform
Copied!
Home
Options
2,172
Cameron_MSFT_SAP_PM on 01-09-2020 06:00 PM
4,910
Ben Trinh on 12-11-2019 09:39 AM
1,880
Sachin-Ghorpade on 12-02-2019 03:25 PM
2,572
Cameron_MSFT_SAP_PM on 11-17-2019 06:20 PM
2,652
Sachin-Ghorpade on 10-22-2019 11:52 AM
6,237
hobru on 09-21-2019 12:47 PM
3,440
Sachin-Ghorpade on 09-13-2019 11:47 AM
4,255
Cameron_MSFT_SAP_PM on 08-15-2019 04:59 AM
4,389
Cameron_MSFT_SAP_PM on 08-02-2019 04:34 PM
4,340
Cameron_MSFT_SAP_PM on 07-31-2019 12:50 PM
4,576
Sachin-Ghorpade on 07-17-2019 03:29 PM
4,568
Sachin-Ghorpade on 06-20-2019 09:38 AM
7,747
hobru on 06-11-2019 01:00 PM
5,083
Sachin-Ghorpade on 05-29-2019 10:50 AM
6,268
Goran Condric on 04-17-2019 03:35 AM
9,401
Cameron_MSFT_SAP_PM on 03-31-2019 01:51 PM
4,966
Sachin-Ghorpade on 03-25-2019 04:17 PM
5,055
Goran Condric on 03-20-2019 03:25 AM
6,640
Cameron_MSFT_SAP_PM on 03-20-2019 12:50 AM
4,535
Juergen Thomas on 03-13-2019 11:12 AM
4,234
Juergen Thomas on 03-13-2019 11:12 AM
4,063
Cameron_MSFT_SAP_PM on 03-13-2019 11:12 AM
4,437
mssedusch on 03-13-2019 11:12 AM
3,911
Cameron_MSFT_SAP_PM on 03-13-2019 11:12 AM
4,212
Cameron_MSFT_SAP_PM on 03-13-2019 11:11 AM
4,662
Cameron_MSFT_SAP_PM on 03-13-2019 11:11 AM
4,050
Cameron_MSFT_SAP_PM on 03-13-2019 11:05 AM
4,192
AzureCAT on 03-13-2019 11:04 AM
4,223
AzureCAT on 03-13-2019 11:04 AM
5,839
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