Getting info about available memory from scaleset

Question

When I am using scaleset from azure pipelines. I see following error.

Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space. 

scale set runs that pipeline

I know it is 16 GB RAM for the scale set, but not sure why this error is popping up.

I want to know why it is showing there is no enough memory?

is there any command to check, I tried below but not getting info , it is executing commands but no output.

Answer 1

Hello Varma,

Welcome to microsoft Q&A , thankyou for posting your query here.

Ensure that there is enough disk space on the VM. Excel might need more space than you expect, especially if the operations involve large files or complex calculations.

Even though the VM has 16 GB of RAM, it's possible that other processes are consuming a significant portion of the memory, leaving insufficient space for Excel.

Use monitoring tools to check the memory usage of other processes running on the VM.

https://learn.microsoft.com/en-us/azure/azure-monitor/essentials/collect-custom-metrics-guestos-resource-manager-vmss

Check Excel's options and settings. There are settings in Excel that allow you to adjust how it handles memory and performance, like disabling hardware graphics acceleration.

Ensure that the VM handles multiple instances based on your operational needs. If multiple pipelines or processes are running Excel simultaneously this could lead to resource contention.

If the commands are executing but not producing any output. The execution policy in PowerShell might be restricting script execution. You can check and change

Get-ExecutionPolicy

Set-ExecutionPolicy -ExecutionPolicy RemoteSigned -Scope CurrentUser

To view detailed memory usage by each process, you can use the Task Manager or the following command in PowerShell.

Get-Process | Sort-Object WS -Descending | Select-Object Name, @{Name='Mem (MB)';Expression={[math]::Round($_.WS / 1MB)}}, Id | Format-Table -AutoSize

hope this helps you.

If an answer has been helpful, please consider accepting the answer to help increase visibility of this question for other members of the Microsoft Q&A community. If not, please let us know what is still needed in the comments so the question can be answered. Thank you for helping to improve Microsoft Q&A!