2,079
4,851
1,820
2,498
2,599
6,184
3,381
4,207
4,342
4,289
4,528
4,508
7,697
5,038
6,216
9,333
4,909
5,004
6,590
4,477
4,192
4,019
4,387
3,869
4,169
4,611
4,004
4,149
4,180
5,764
KirankumarVejendla
in
SAP on Azure General Update – January 2020
on
01-22-2020
Lot of useful information at single location. Thanks Cameron !!!
0 Likes
werner_daehn
in
SAP HANA Fast-Restart
on
01-05-2020
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
Ben Trinh
in
SAP HANA Fast-Restart
on
01-05-2020
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
werner_daehn
in
SAP HANA Fast-Restart
on
12-22-2019
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
Ben Trinh
in
SAP HANA Fast-Restart
on
12-21-2019
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