|
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 17 mins ago.
|
|
|
|
|
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
|
|
|
|
|
π¨π¨β¬β¬β¬
β¬β¬π¨β¬β¬
π©π©π©π©π©
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
|
|
|
|
|
Wordle 828 4/6*
β¬β¬β¬β¬β¬
π¨β¬π¨β¬β¬
β¬π©π¨β¬π¨
π©π©π©π©π©
Happiness will never come to those who fail to appreciate what they already have. -Anon
|
|
|
|
|
Wordle 828 4/6
π©β¬β¬β¬β¬
π¨β¬β¬β¬π¨
β¬β¬β¬β¬β¬
π©π©π©π©π©
|
|
|
|
|
Wordle 828 4/6*
β¬π¨π¨β¬β¬
π¨π©β¬π¨β¬
β¬π©π¨π¨β¬
π©π©π©π©π©
"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!
|
|
|
|
|
Wordle 828 3/6
β¬β¬π¨β¬β¬
β¬β¬π¨π¨β¬
π©π©π©π©π©
I spent a loooong time on line 3! 
Ok, I have had my coffee, so you can all come out now!
|
|
|
|
|
Wordle 828 4/6
β¬β¬π¨β¬β¬
β¬π©β¬β¬β¬
β¬π©β¬β¬π©
π©π©π©π©π©
|
|
|
|
|
Wordle 828 4/6
β¬β¬β¬π¨β¬
β¬β¬π¨β¬π©
π¨π¨β¬β¬π©
π©π©π©π©π©
Jeremy Falcon
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
