SSAS 2019 Query interleaving

Vivek Devalkar 122 Reputation points
2021-03-15T20:28:32.99+00:00

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://learn.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
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Alexei Stoyanovsky 3,416 Reputation points
    2021-03-16T09:41:32.127+00:00

    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.

    0 comments No comments

  2. Lukas Yu -MSFT 5,821 Reputation points
    2021-03-17T01:28:43.733+00:00

    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.