|
My coworker has a brand new 16GB laptop.
16GB should be enough for most workloads, or so you'd think.
Unfortunately, that is not the case.
We're running "the usual", such as Outlook, Spotify, SourceTree, Teams, Chrome, OneDrive, etc.
Now, with only two Visual Studio instances and a SQL Server Management Studio instance open, SQL Server (the service) just chokes.
We're getting timeouts like you wouldn't believe, nothing works.
After some digging, we found the reason to be memory exhaustion, 16GB just went up in smoke and it's at its peak at a constant 90+%.
I've had 16GB and even less in the past, and running a local SQL Server instance together with VS and SSMS has never been a problem.
At this point it's become unworkable.
You'd think that maybe the memory would be more evenly distributed and that some processes would write to disk instead and become a bit slower.
But instead, SQL Server just pretty much stops working altogether.
Closing a VS instance fixes the problem, but sometimes we just need to have two instances open.
My coworker changed his virtual memory page file to use 20GB and that fixes the problem, but doesn't feel right.
Anyone have any ideas what the problem could be?*
* Is this a programming question? Is it a SQL Server question? Is it a general computing question? I'm not sure, so I'm posting it here.
|
|
|
|
|
Not too long ago I posted for my new PC I wanted 128GB of RAM. I got the usual I'm crazy type replies (it's the Internet). But, I gotta say... more RAM means spending less time (which is more valuable) than dealing with this type of nonsense. And I'm sure in a few years MS will make sure 128GB is not much. But, at least it'll carry me over until then.
At the very least, a dev workstation should not have less than 32GB these days. Some laptops are upgradable, so it's worth seeing if you can toss a new stick in it. If there are two physical drives in the laptop, you can always put the page file on the second drive to at least help that way. If it's on a non-system volume, then there will be less disk access going on to slow it down.
Outside of that, you're screwed buddy. 
Jeremy Falcon
modified 1hr 15mins ago.
|
|
|
|
|
I have 32Gb right now (not dev'ing so much lately) but still 2 slots free.
The first time I feel like something should be working better, I buy 2x32 right away.
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
I have 64GB on my work computer and WSL(Windows Subsystem for Linux) fairly regularly gobbles up all the available CPU and memory, so occasionally I have to issue a taskkill on the wslservice service.
Seems to be Docker related in my case.
My take is that memory is assumed to be cheap nowadays so a lot of services will eat through memory.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
modified 5hrs ago.
|
|
|
|
|
GuyThiebaut wrote: Seems to be Docker related in my case.
Docker is one of those things that should be used very, very sparingly and only if you have a good reason. Unfortunately so many devs just want to jump on the hype train without a thought in the world about how things actually work.
Jeremy Falcon
|
|
|
|
|
Jeremy Falcon wrote: Unfortunately so many devs just want to jump on the hype train without a thought in the world
I didn't have a say in the matter 
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
I will say this, if I find myself in serious need of a docker container over WSL, believe it or not a raspberry pi is fast enough to do most things for a single user. So, running a container inside a pi is totally doable.
Jeremy Falcon
|
|
|
|
|
Memory issues are...
I forgot what I was going to say?
I don't think before I open my mouth, I like to be as surprised a everyone else.
PartsBin an Electronics Part Organizer - Release Version 1.1.0 JaxCoder.com
Latest Article: SimpleWizardUpdate
|
|
|
|
|
My work PC is a bit less than 2 years old and with 16gb of memory I was running in the same problems with SQL Server and VS2022 running together. What worked for me was disabling the fancy "AI" code suggestions, the background process for it was gobbling 1.5GB+ per VS instance, that's definitely not worth the couple extra lines of code I had to write.
|
|
|
|
|
Your browsers will often take the most memory; are constantly doing "call backs". Each tab is another instance; for the most part.
I uninstalled Chrome because it was ALWAYS busy; even when I wasn't explicitly "loading" it.
I use Edge and FireFox and watch everything in Task Manager. I stream movies while programming, etc. with 16GB. Just know what's going on.
"Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I
|
|
|
|
|
|
Sander Rossel wrote: We're getting timeouts like you wouldn't believe,
Just realized I had not looked at memory utilization in years. Right now with 16 gb I have nothing but three browser windows open and the memory util is at 5 gig.
Performance problems for me always come down to CPU. Usually when VS is starting up or when the virus checker is going crazy.
But you didn't mention the CPU at all?
When this happens the CPU is low?
Also which version of windows?
Sander Rossel wrote: 20GB and that fixes the problem
And what was it set to before?
Mine uses auto manage.
The windows suggestion appears to have that value as low. Suggestion seems to be "1.5 to 3 times" of physical memory. So 24 to 48 would be an appropriate range.
|
|
|
|
|
Here's a snapshot of memory usage[^] on my 16GB desktop running Ubuntu 22.04.2 LTS.
I'm currently running:
* GIMP,
* FireFox (with 30 tabs open) - one streaming music,
* two remote desktop connections via Remmina,
* 3 terminal sessions,
* MS Teams,
* VSCode,
* various other programs
Because I saw someone mention Docker, I went ahead and started my Docker container running MS SQL Server.
Here's the memory snapshot[^] with Docker running too.
I could never run all this on my 16GB Windows 10 laptop.
What do those Linux devs know? 😂😆🤓
There really are advantages to running Linux as dev.
I understand that I can't run full Visual Studio but learning command line and migrating to .NET Core makes it so I can do everything I need (yes, not WinForms) on Linux with VS Code. and I feel much less pain.
|
|
|
|
|
Scraps sinister deliveries (9)
In a closed society where everybody's guilty, the only crime is getting caught. In a world of thieves, the only final sin is stupidity. - Hunter S Thompson - RIP
|
|
|
|
|
I thought "really simple week" had ended? 
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
|
Not on a Monday
In a closed society where everybody's guilty, the only crime is getting caught. In a world of thieves, the only final sin is stupidity. - Hunter S Thompson - RIP
|
|
|
|
|
LEFT sinister
OVERS deliveries
def: scraps
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
YAUT 
In a closed society where everybody's guilty, the only crime is getting caught. In a world of thieves, the only final sin is stupidity. - Hunter S Thompson - RIP
|
|
|
|
|
Still trying to figure out the issue with my gaming machine...
I see the video card used 300 Watts of power at most... (which leaves 700 W from my PSU), but then, other part of my system are also using power, so maybe it was starved with power after all, but I dont really know.. How would I know?
I did notice that MWAVE top computer is using 1200Watt PSU (as opposed to my 1000 Watts one), so maybe it is an issue after all..
|
|
|
|
|
Unless you're running some super-custom, blown-up liquid cooling loop with a 7000 series and an overclocked 4090, I think a 1000W PSU should be more than enough to handle most systems. Have you tried plumbing your components into https://uk.pcpartpicker.com/ to see whether it flags anything? If there was a power draw issue I'd expect it'd flag it.
Also a lot of modern motherboards usually have an LED indicator somewhere which displays a code indicating the hardware issue? Otherwise, back to ol' reliable of removing stuff until it works!
|
|
|
|
|
thanks! 
|
|
|
|
|
Chris Copeland wrote: Otherwise, back to ol' reliable of removing stuff until it works!
If I got 1 € for every time I have done trial and error with hardware things... 
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Have you checked whether there is a power connector or two to the graphics card and if so that they are connected.
You could also try underclocking the graphics card slightly and seeing if that fixes the issue.
|
|
|
|
|
I still think your power supply is faulty.
Check out my IoT graphics library here:
https://honeythecodewitch.com/gfx
And my IoT UI/User Experience library here:
https://honeythecodewitch.com/uix
|
|
|
|
|
I had issues with mine doing weird sounds, the problem was "coil whine?", I just reduced my FPS to 300 in the card settings. Since then soooo quiet. And I don't think I have noticed any difference from dynamic to 300 max.
I know, probably nothing to do with your issue, but reducing FPS might be another way to reduce consumption and see if it brings a delay in the problem or something like that.
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
