News for hackers. Stuff that matters.

A comment on Initial preview of GUI app support for the Windows Subsystem for Linux. Parent comment

Re:Initial preview of GUI app support for the Windows Subsys... by piaste on Wednesday April 21, 2021 @05:22PM (#26895603)
SQL Server by design grabs as much RAM as it can, as aggressively and preemptively as it can, because it assumes it's the most important process running on the machine. Which is almost always the case in production environments, and a reasonable default behaviour as a result. If that's not the case, you can easily set resource limits at the application, container, and/or VM level.

(This comment coming from someone who used to have to support running small backup MSSQL instances on Windows 8 tablets.)

[ Parent | on HN ]
Re:Initial preview of GUI app support for the Windows Subsys... by skeletonjelly on Wednesday April 21, 2021 @08:37PM (#26897246)
Yep this. SQL Server using RAM is by design. If it's using too much because you're using it for dev work then you can simply limit the amount it can access. RAM is there to be used!
[ Parent | on HN ]
Re:Initial preview of GUI app support for the Windows Subsys... by MereInterest on Wednesday April 21, 2021 @11:27PM (#26898391)
It's a perfectly fine design so long as there's one, and only one, program that is maximizing its RAM usage. When you have many programs (e.g. the browser, Teams, slack, every single electron app), then you get loads of contention.
[ Parent | on HN ]
Re:Initial preview of GUI app support for the Windows Subsys... by easton on Wednesday April 21, 2021 @11:31PM (#26898414)
> (This comment coming from someone who used to have to support running small backup MSSQL instances on Windows 8 tablets.)

Can I ask what the use case was? Was it just in case the primary DB server died and they wanted a battery powered backup?

[ Parent | on HN ]
Re:Initial preview of GUI app support for the Windows Subsys... by ryanjshaw on Thursday April 22, 2021 @01:59AM (#26899241)
Can't speak for OP but here in Africa I've worked on a two unrelated projects where poor internet connectivity meant it made sense to have a local SQL Express running on a users device, which a service would then try to regularly synchronize with the central server. Makes sense when you are capturing documentation and can make all the decisions in disconnected operation.
[ Parent | on HN ]