question

SujaiKarnam-8974 avatar image
0 Votes"
SujaiKarnam-8974 asked PRADEEPCHEEKATLA-MSFT commented

How to Scale-Out (query replicas) Azure Analysis Services without any temporary outage?

Our Azure Analysis Services is in the East US 2 region and on S2 tier. We are trying to perform an auto scale-out/scale-in depending on the average QPU usage reaches a certain threshold (70-80%) for a sustained period of time. We trying to use the Azure Runbook and Powershell script to automate following the sample provided in github:
https://github.com/microsoft/Analysis-Services/tree/master/AASAutoScale

The issue we are facing is that, when the scale-out/in is occurring, regardless of whether we increase the query replicas from the Azure Portal manually or through the powershell cmdlets, the users interacting with the Power BI reports in Power BI Service suddenly get intermittent connection errors to the Azure Analysis Services. The error is as shown below:
95671-image.png

I have tried various things, such as below, but no luck. Is there any way to get around this?
Things I have tried:

  1. Separate the processing server from querying pool setting is to Yes as well as No

  2. ReplicaSyncMode setting to 2 (Optimized synchronization in parallel). Microsoft documentation says the databases are kept online on all replicas throughout the sync process and clients do not need to reconnect, but no luck

Also please let me know if I'm doing the steps correct:

  1. Process Database (The AAS database is processed only once (during midnight) in our case with "Process Full" option

  2. Synchronize operation as soon as Process Database step is complete

  3. Increase Query Replicas as needed during peak time (when the QPU usage goes beyond 70-80% of the max)

  4. Decrease Query Replicas as needed when the QPU usage drops below 30%

Since the Sync operation is done as soon as the Process Database is complete, we don't need to perform another Sync operation as and when new Query Replicas are added or removed. Is this correct?

Please help!

Thanks!!



azure-analysis-services
image.png (28.8 KiB)
· 8
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.

Hello @SujaiKarnam-8974,

Welcome to the Microsoft Q&A platform.

Could you please click on see details and share those details here and also what happen when you click on Get Help link?

95870-image.png


0 Votes 0 ·
image.png (65.8 KiB)

Hi @PRADEEPCHEEKATLA-MSFT ,

Here is the details provided in the error message:

Capacity ID: E01DA948-C9C1-4F40-A9AA-89E89A49D717
Activity ID: e51f582c-8e74-4100-a656-09ce786c98b1
Correlation ID: ddc82970-bee8-809d-0f2d-0aa226887b2c
Request ID: 5ab5b368-3d2c-9908-b62b-11b99ebc3236
Time: Wed May 12 2021 20:08:28 GMT+0530 (India Standard Time)
Service version: 13.0.16039.61
Client version: 2105.1.06040-train
Cluster URI: https://wabi-us-east2-b-primary-redirect.analysis.windows.net/


And "Get help" takes you to https://powerbi.microsoft.com/en-us/support

Regards
Sujai Karnam

0 Votes 0 ·

Hello @SujaiKarnam-8974,

Thanks for the details.

For a deeper investigation and immediate assistance on this issue, if you have a support plan you may file a support ticket. In case if you don't have the support plan do let us know.

0 Votes 0 ·
Show more comments

0 Answers