Windows 7 Pro 32 bit - Low on Memory... Ideas?
-
@WrCombs I could be wrong but seems strange that sqlserver would even be installed on a win7 32 bit workstation but thats just a guess. Is it supposed to be there?
-
So looking at it more -
sqlservr.exeis runningMSSQL$SQLEXPRESS
Which is running our New Aloha Manager software for creating changes.@jmoore said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@WrCombs I could be wrong but seems strange that sqlserver would even be installed on a win7 32 bit workstation but thats just a guess. Is it supposed to be there?
Yep ! it's running the software for the Point of sale system .
according to the above link - It should reallocate ram as needed. -
The only issue I see now is
javaw.exeis running with almost 50 instances. -
@WrCombs Ok got it. Just wanted to make sure lol. When you start seeing things that arent supposed to be there its bad.
-
@WrCombs When was last time the machine was updated and restarted?
-
@jmoore said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@WrCombs When was last time the machine was updated and restarted?
Restarting right now again - I found a JavaUpdater in the start up through
msconfigand disabled it.
We dont use Java from my knowledge and My boss even said just to disable it. -
@jmoore said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@WrCombs When was last time the machine was updated and restarted?
as for updating I'm not exactly sure on that - I'm guessing it got the last security update that came out.
-
@WrCombs Ok cool. Yeah watch the startup stuff occasionally. Many times when you update or install any particular app it will add itself back to the startup items.
-
@jmoore said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@WrCombs Ok cool. Yeah watch the startup stuff occasionally. Many times when you update or install any particular app it will add itself back to the startup items.
I gotcha.
Thanks -
-
The first problem is that it's 32 bit Windows 7. That means your maximum memory is going to be for gigs switch looking at your screenshot showing about 3 Gigs available for use. 3 gigs of memory to use in 2019 is absolute garbage. If SQL Server is running, you need to put a limit on the amount of memory that can be used. Otherwise it will use up every single kilobytes it possibly can.
-
@WrCombs said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
So looking at it more -
sqlservr.exeis runningMSSQL$SQLEXPRESS
Which is running our New Aloha Manager software for creating changes.@jmoore said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@WrCombs I could be wrong but seems strange that sqlserver would even be installed on a win7 32 bit workstation but thats just a guess. Is it supposed to be there?
Yep ! it's running the software for the Point of sale system .
according to the above link - It should reallocate ram as needed.Which POS application? Are you sure it is not java based? Before you just all out kill java
-
@donaldlandru said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@WrCombs said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
So looking at it more -
sqlservr.exeis runningMSSQL$SQLEXPRESS
Which is running our New Aloha Manager software for creating changes.@jmoore said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@WrCombs I could be wrong but seems strange that sqlserver would even be installed on a win7 32 bit workstation but thats just a guess. Is it supposed to be there?
Yep ! it's running the software for the Point of sale system .
according to the above link - It should reallocate ram as needed.Which POS application? Are you sure it is not java based? Before you just all out kill java
haha - Very true.
I havent seen anything about "Java Based" -
@WrCombs ahh OK.. The company I work for specializes in the old Oracle Retail (ORPOS) and Oracle Xstore (previously Micros Xstore, previously Store21, previously Datavantage) and those are all on Java. They also all have MSSQL on every register, so.. thought I would throw my thoughts in.
-
@donaldlandru said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@WrCombs ahh OK.. The company I work for specializes in the old Oracle Retail (ORPOS) and Oracle Xstore (previously Micros Xstore, previously Store21, previously Datavantage) and those are all on Java. They also all have MSSQL on every register, so.. thought I would throw my thoughts in.
I appreciate it !
-
@jmoore said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@WrCombs I could be wrong but seems strange that sqlserver would even be installed on a win7 32 bit workstation but thats just a guess. Is it supposed to be there?
Not wrong, totally crazy, lol. Three crazy things...
- Windows 7 is ancient.
- 32bit is nuts, what decade is this?
- Not a server?
-
@WrCombs said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
So looking at it more - sqlservr.exe is running MSSQL$SQLEXPRESS
Which is running our New Aloha Manager software for creating changes.Legally that isn't licensed. To run that in that way, Windows 7 would qualify as pirated. Using any MS machine as a server requires server licensing. Windows 7 can be licensed as a dev machine for learning or developing, but not for actual use.
32bit would be completely crazy in any situation. Even a 14 year old workstation being used for SQL Server should be 64bit. You need RAM access.
-
@WrCombs said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@jmoore said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@WrCombs When was last time the machine was updated and restarted?
Restarting right now again - I found a JavaUpdater in the start up through
msconfigand disabled it.
We dont use Java from my knowledge and My boss even said just to disable it.Yeah, if that isn't needed, you definitely don't want it.
-
@donaldlandru said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@WrCombs ahh OK.. The company I work for specializes in the old Oracle Retail (ORPOS) and Oracle Xstore (previously Micros Xstore, previously Store21, previously Datavantage) and those are all on Java. They also all have MSSQL on every register, so.. thought I would throw my thoughts in.
LOL, Oracle requires MS SQL Server. JAJAJA
-
@scottalanmiller said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@donaldlandru said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@WrCombs ahh OK.. The company I work for specializes in the old Oracle Retail (ORPOS) and Oracle Xstore (previously Micros Xstore, previously Store21, previously Datavantage) and those are all on Java. They also all have MSSQL on every register, so.. thought I would throw my thoughts in.
LOL, Oracle requires MS SQL Server. JAJAJA
Yes that is a running joke around my parts. Oracle has been "fixing" that limitation since they bought the Xstore product.
-
@scottalanmiller said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@jmoore said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@WrCombs I could be wrong but seems strange that sqlserver would even be installed on a win7 32 bit workstation but thats just a guess. Is it supposed to be there?
Not wrong, totally crazy, lol. Three crazy things...
- Windows 7 is ancient.
- 32bit is nuts, what decade is this?
- Not a server?
This was bought years ago - they haven't updated because its rather expensive.
