Hi,
I´ve a SSAS Tabular environment with one dedicated server for "Processing" and another server handling the user query-load.
The SSAS database is processed (only some partitions) multiple times per day (around ones per hour) and the "delta" is "copied" to the query server using the built-in SSAS Synchronization.
One problem that we have is that the query server usualy gets inaccessible for some time (stopes accepting new queries) in the late phase of the synchronization (I think it is when it is switching to new version of the database). Feels like 1-2 minutes or something, but it propably varies. I also think (not sure) that the time of the synchronization (or final commit) vary depending on query load (synch takes longer time because it waits for queries to complete before commiting the synch).
Cause of this I have been starting to think about the new "online attach" feature in SSAS 2019. Will that one behave different on a highly concurrent environment?
Will it be more like 2 "separate" databases on different versions so that an already running query will be able to complete on the the old version and the new version starts accepting new queries or will I get the same problem with the "Online attach" approach?
Regards
Stefan