Windows PC Performance

Question

Hi there, I hpe you're having a good day. I;ve just signed up to Azure to run some python scripts, power BI and another AP on a veritual windows machine. However, the performance is a bit slower than I expected. I am using the Size

Standard E2s v3

vCPUs

2

RAM

16 GiB

Do you ahve an suggestions for how I can improve performance?

Thanks

Matt

Answer 1

hi Matt,

thanks for posting this ))

aha, so u're feeling like ur azure virtual machine is dragging its feet a bit, huh? let's see what we can do to speed things up )

for ur python scripts and power bi, the standard e2s v3 might be a tad underpowered if u're crunching big datasets. u could try bumping it up to an e4s v3. double the vcpus, same ram, but oh boy, it makes a difference )) check the azure vm sizes https://learn.microsoft.com/en-us/azure/virtual-machines/sizes-general

also, make sure u're using ssd storage, not hdd. slow disks can kill performance faster than u can say 'oops' ) https://learn.microsoft.com/en-us/azure/virtual-machines/disks-types

now, for power bi... u might wanna tweak its settings. disable background data refresh, limit visuals, and maybe even split ur reports if they're huge. power bi can be a bit of a diva sometimes :))

as well check this... if u're running multiple apps at once, 16gb ram might not be enough. keep an eye on task manager. if u see it hitting 90%, time to upgrade ))

worth looking into... azure performance diagnostics. it's like a doctor for ur vm, but without the scary bills ))

and hey, this might help in other tools too... always close what u're not using. browsers are sneaky ram eaters, especially with 20 tabs open (guilty as charged %)

some tip from a fellow python lover... if u're using pandas, try 'dask' for bigger datasets. it's like pandas on caffeine )) hope this helps, matt! let us know how it goes. )

btw if u're feeling fancy, u could even try spot instances for non critical stuff. cheaper, but they might vanish like croissants at a french bakery )) https://learn.microsoft.com/en-us/azure/virtual-machines/spot-vms

Best regards,

Alex

and "yes" if you would follow me at Q&A - personaly thx.
P.S. If my answer help to you, please Accept my answer

https://ctrlaltdel.blog/

Answer 2

Hello @Matt Ryan ,

To enhance the performance of your Azure virtual machine, consider scaling up to a larger VM size with additional vCPUs and memory. Additionally, monitor and manage any background processes that may be consuming system resources.

Optimize your Python scripts for computational efficiency and review your Power BI reports to ensure they are not excessively complex or resource intensive.

consider moving to a larger VM size, such as Standard E4s v3 which offer more vCPUs and RAM.

https://learn.microsoft.com/en-us/azure/virtual-machines/sizes/resize-vm?tabs=portal

If you have any further queries, do let us know. If you found this informative, please consider accepting an answer as a token of appreciation. And don't forget to give it a thumbs up 👍 if it was helpful.