Windows 7 Pro 32 bit - Low on Memory... Ideas?
-
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.
-
@scottalanmiller 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.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.
How is It not licensed ?
I wasn't here when it was sold. IDK why we're using 32-bit. I said the same thing "That's ridiculous. why are we using that?" -
@scottalanmiller said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@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.
I dont see any reason it would be needed.
It was odd that it was there. -
@WrCombs said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
This was bought years ago - they haven't updated because its rather expensive.
I get leaving things old, but is it actually older than 2005, or just messed up in 2005? 32bit is so old. Older than Windows 7. Windows 7 deployed as 32bit means a new OS on very old hardware. Windows 7 was 2010, 64bit was like 2003. 64bit came out in 2000, but we can excuse not deploying till about 2003. After that point, anything 32bit really has no excuse. So that would imply Windows 7 on hardware that is at a minimum seven years old, or just a total screw up.
And that's before addressing the lack of licensing which has nothing to do with age.
-
@WrCombs said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
How is It not licensed ?
Because there is no license. Windows 7 can never be used like this. It's unlicensable as a server. It's that simple. This is just pirated.
The simple rule of thumb is "when you have a server, it has to have server licensing." There are really rare, special circumstances where that can be bypassed, but they are crazy specific and it's obvious when they apply (like it applies to file transfers to move files back and forth between machines.) Anytime someone says "we don't need a server, we'll just use a desktop for that", that's pirating.
This is one of the big reasons why Windows is so bad for this stuff. No matter how tiny or silly the install, you must pay for Windows Server licensing. So it makes even the tiniest task cost a lot of money both in licensing and effort to plan and deal with. Being "locked in" to Windows comes at a huge cost that whoever decided to use Aloha accepted when choosing that product. It's not good or bad, it's just the biggest piece of that decision. So someone accepted that Aloha has an ~$800 extra licensing fee for every deployment on top of the Aloha costs.
-
@scottalanmiller said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@WrCombs said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
How is It not licensed ?
Because there is no license. Windows 7 can never be used like this. It's unlicensable as a server. It's that simple. This is just pirated.
What makes this a "server" in this case? Either I missed something or something else is being read into this.
It is pretty common in the point of service space for one register to play the role of "lead" and all other registers are slaves.
-
@donaldlandru said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@scottalanmiller said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@WrCombs said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
How is It not licensed ?
Because there is no license. Windows 7 can never be used like this. It's unlicensable as a server. It's that simple. This is just pirated.
What makes this a "server" in this case? Either I missed something or something else is being read into this.
It is pretty common in the point of service space for one register to play the role of "lead" and all other registers are slaves.
We use a file-server system environment - Maybe that's what he is meaning as "server"
I'm not sure, -
@donaldlandru said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
What makes this a "server" in this case? Either I missed something or something else is being read into this.
Really simple... it's running a database whose services are used by other machines. It's a by the book database server.
-
@donaldlandru said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
It is pretty common in the point of service space for one register to play the role of "lead" and all other registers are slaves.
Read: It is pretty common to commit piracy with POS deployments.
-
@WrCombs said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
We use a file-server system environment - Maybe that's what he is meaning as "server"
You are using MS SQL Server. What does that exist for, if not to be a database server? If you turn it off, does nothing break?
