|
Make sure you limit the amount of memory that the SQL Server service uses. By default, it will grow to use all memory available!
|
|
|
|
|
As always, the answer is: it depends. 
You don’t say what version SQL server is running, or what the load is. But, you will probably want to set the service’s MIN and MAX memory allocation. Unfettered, the service will take as much memory as it can, and not release it unless caches are cleared.
Hopefully it’s only being used as a development server and has only your coworker’s load on it.
We always put our SQL servers (dev,staging, and production) on separate network machines.
Good luck.
Time is the differentiation of eternity devised by man to measure the passage of human events.
- Manly P. Hall
Mark
Just another cog in the wheel
|
|
|
|
|
Sort of a side issue, but pay attention to what you buy. I'm on my third Eluktronics laptop - sort of a custom small shop, and I love the fact that they _never_ install bloatware. That said, I picked up a laptop for my wife with the assumption that I could add ram if she needed it. The spec was very subtle, and I missed the fact that the 16GB ram was soldered to the motherboard. No extra memory slots as well. I never even thought to look.
This seems to happen if you get a very slim design. My new laptop (same maker) does not have this issue.
What I find interesting in this discussion is the fact that Windows just does not seem to manage memory as one might expect. It's like the memory manager is brain dead.
Charlie Gilley
“They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
Has never been more appropriate.
|
|
|
|
|
If you're not wiping and reinstalling from scratch the day you receive your Laptop - You're not doing it right :p
-= Reelix =-
|
|
|
|
|
charlieg wrote: It's like the memory manager is brain dead.
Is there any other class of manager?  
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.
|
|
|
|
|
Are you admitting Microbloat writes really bad software that gobbles up memory?
~d~
|
|
|
|
|
I'm not sure anyone ever needs to admit that.  It's a physical constant. Do you have any idea how memory expensive new icons are? Re-arranging menus just to re-arrange them? lol
Charlie Gilley
“They who can give up essential liberty to obtain a little temporary safety deserve neither liberty nor safety.” BF, 1759
Has never been more appropriate.
|
|
|
|
|
In SSMS (SQL Server Management Studio), right click on the server instance and select properties. There it will tell you how much memory it's using and have some settings for limiting it.
Bond
Keep all things as simple as possible, but no simpler. -said someone, somewhere
|
|
|
|
|
You must be doin somethin' wrong. A PC will never need more than 640 KB.
; )
"If we don't change direction, we'll end up where we're going"
|
|
|
|
|
> 16GB should be enough for most workloads, or so you'd think.
Workloads for a regular user and workloads for a developer are very, VERY different.
16GB is nowhere near enough for a developer.
You under-spec'd - The page file increase is a terrible thing to do, but the best choice for someone running multiple memory-intensive applications on a device spec'd for someone running Excel and a Browser who maybe also has Outlook open.
-= Reelix =-
|
|
|
|
|
Edit: I see you solved the problem; I couldn't get to the second page of responses for some reason. Anyway, simple list at the bottom.
Same problem, same amt of memory. Weirdly, things seem to work pretty well even if the memory usage is quite high. Until it doesn't.
I don't know why 16 GB isn't enough any more.
I always have tskmgr open. Only consulted Process Explorer once so far.
The usual first check and problem is a browser; Firefox is the main culprit (and/or add-ons), but I think I have way too many tabs open and too many bookmarks saved as well making it hefty. But the memory is fine when it first opens.
The second check is VS. It is also fine until it isn't. Again, too many files/tabs open inside VS seems to be a possible issue.
- try usage with no internet connection.
- check for junk added by laptop seller (though I'm not convinced it's an issue.)
- review startup apps regularly; stuff gets readded.
- check task scheduler for hidden background tasks. <--
- check every single app for background calls to home (auto-updates, etc.).
modified 28-Sep-23 1:07am.
|
|
|
|
|
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.
|
|
|
|
|
Super silent... In fact I had to visually check fan are indeed working!
Must be because I also have liquid cooling...
I ordered a new video card... we shall see 
|
|
|
|
|
Good luck 
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
