|
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 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
|
|
|
|
|
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 1hr 15mins 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
|
|
|
|
|
|
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! 
|
|
|
|
|
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
|
|
|
|
|
Wordle 828 3/6
🟨🟨⬛⬛⬛
⬛🟨🟨⬛⬛
🟩🟩🟩🟩🟩
|
|
|
|
|
Wordle 828 4/6
⬜⬜⬜⬜⬜
⬜🟩🟨⬜⬜
🟩🟩⬜⬜🟩
🟩🟩🟩🟩🟩
|
|
|
|
|
Wordle 828 3/6
🟨⬜⬜⬜⬜
⬜🟨⬜🟨🟨
🟩🟩🟩🟩🟩
|
|
|
|
|
Wordle 828 2/6
🟨⬜🟨🟨⬜
🟩🟩🟩🟩🟩
|
|
|
|
|
Wordle 828 5/6
⬜⬜⬜⬜🟨
🟨⬜⬜⬜🟨
🟩🟩⬜⬜⬜
🟩🟩🟩🟩⬜
🟩🟩🟩🟩🟩
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
