question

VivekD-8637 avatar image
0 Votes"
VivekD-8637 asked LukasYu-msft commented

SSAS 2019 Query interleaving

We recently upgraded to SQL 2019 and I noticed that SQL 2019 now has query interleaving but there isn't any practical information on it from any experts as such.

https://docs.microsoft.com/en-us/analysis-services/tabular-models/query-interleaving?view=asallproducts-allversions

The primary thing I'm looking to find out is on exactly how would I go about testing to see if it's actually working? Any ideas/thoughts?


sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlexeiStoyanovsky avatar image
0 Votes"
AlexeiStoyanovsky answered

As evident from the documentation, this optimization is useful in a rather specific scenario: you have a tabular model in import mode that concurrently receives long-running SE-intensive queries and fast queries, while experiencing CPU pressure. If you have such a system, the testing would be straightforward: with the optimization on and working, the fast queries would return sooner than with it off or not working. If you don't, you'll have to construct one first.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft commented

It seems there is no on hand example provided by Microsoft, we need to test on the project of ourselves and check the Q2 & Q3 duration that specified by the document. Their response time should be improved significantly.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Have you made any test ? Have you met any business circumstances that this feature is required to be tested ? Normally I would believe the Microsoft Doc, it should be working as it is said, normally. :)

0 Votes 0 ·