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?
-
@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?
-
If SQL Server is there for no function whatsoever, then it might not qualify as a server. But if that is the case, turn it off as that is certainly using a lot of resources that can't be afforded on such an ancient machine.
-
@scottalanmiller said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@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?
We are using MS Sql Express - yes. It's needed for the database in New versions of Aloha manager.
If we turn it off, the point of sale doesnt get the changes made. -
@WrCombs 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?:
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?
We are using MS Sql Express - yes. It's needed for the database in New versions of Aloha manager.
If we turn it off, the point of sale doesnt get the changes made.So you are running a database server that absolutely requires server licensing. Ergo, it's not licensed.
-
@scottalanmiller said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
If SQL Server is there for no function whatsoever, then it might not qualify as a server. But if that is the case, turn it off as that is certainly using a lot of resources that can't be afforded on such an ancient machine.
The way new aloha manager works, from what I'm told- It breaks the changes down into the sql. Then it imports into the file folders and sends the change to the front of house.
SQL is needed for information to pass along to the front of house. -
@scottalanmiller said in Windows 7 Pro 32 bit - Low on Memory... Ideas?:
@WrCombs 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?:
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?
We are using MS Sql Express - yes. It's needed for the database in New versions of Aloha manager.
If we turn it off, the point of sale doesnt get the changes made.So you are running a database server that absolutely requires server licensing. Ergo, it's not licensed.
Okay.
You point these things out - however Point of Sales have been running like this for decades. Why was it not brought up prior.
