on 06-26-2015 1:47 AM
Dear Experts,
We recently upgraded our server memory from 12 GB to 24GB and activated /PAE on our Windows Server 2003 Enterprise SP2, we also enabled AWE config on SQL with min memory of 2048 and max memory 13500.
After doing the config we experienced speed in extracting reports built-in and queries. but the memory in task manager went down to 15GB and free memory down to 200MB, because of this some of our users are logged out.
What may be the cause of this problem?
We use the server as Application, Database, Remote Server.
Regards,
Carlo Joseph O. Alejandro
Sir Luis and Sir Matt,
here are the details you asked for
1) What version of SQL Server are you running? SQL SERVER 2008 10.0.1600
2) What SAP Product are you running on this SQL Server? SAP BUSINESS ONE 8.81 PL04
3. Running on 32-Bit Windows Server Enterprise Edition SP2
Regards,
Carlo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ok, that's what I thought when you mentioned PAE and AWE.
So, caveat #1 is I am not an expert with Business One. However, I suspect what I'll have to say below will still apply, but if any B1 experts see this, they may certainly override what I have to say.
Caveat #2 is that 32-bit Windows or SQL Server is not supported for Business One 8.81, per the PAM. I would strongly, strongly urge you to upgrade to 64-bit.
Caveat #3 is that, although B1 8.81 is supported on Win2003 / SQL2008, this is only when both are 64-bit editions. Furthermore, SAP does not support SQL Server 2008 in 32-bit at all. SAP does (or did) support SQL Server 2005 and earlier in 32-bit editions. It is possible you might be able to make some of the older advice for SQL 2005 32-bit, or even SQL 2000 32-bit, work for you, but it would be "use at your own risk."
So, with that out of the way, as a temporary measure until you can upgrade to 64-bit, you might try the SQL 2000 advice from Note 327494 for 32-bit systems with > 16 GB of memory:
The thing to remember is that all of this with AWE and PAE was always nothing more than workarounds to try to do a little better with more than 4 GB of physical RAM on 32-bit architecture, but it is no substitute for 64-bit architecture, and setting these flags will not magically make your system behave as if it's 64-bit. It's a bandaid at best. The system is "tricking" SQL Server into thinking it can use all that memory, but as the OS still only manages 2 GB at a time for applications, it is "paging" the working memory in and out of that 2 GB limit.
With respect to the memory in use by SAP, each work process can use at maximum 2 GB in a 32-bit environment, so while the work processes in total might use the 15 GB you assign in PHYS_MEMSIZE, individual processes are still highly limited.
Instead of purchasing more memory for a 32-bit system, I would invest your resources in migrating to 64-bit. It will require a reinstallation of the operating system and of SQL Server, but as far as the SAP software goes, it involves not much more than switching out the kernel with a 64-bit version. It's ridiculously simple.
Cheers,
Matt
Hi Carlo,
In addition to Matt's recommendation for SQL Server, this space is focused for SAP NetWeaver on SQL Server. We can give some tips and assist also with other products but only when the question is strictly related to SQL Server itself, not for supported versions etc.
There is a specific space for Business One:
And regarding the SQL Server support for Business One, there is the following note:
928839 - SBO: Release planning for Microsoft SQL Server 2005 / 2008 (R2) / 2012 / 2014
As it is, SAP B1 8.81 requires SQL Server 2008 R2, you're currently running SQL Server 2008. And as I can see in the note, it does support 32-bit version. Or at least, doesn't clearly tell that 32-bit of SQL Server is not supported, neither only 64-bit is the only supported.
Following up questions on AWE memory, which Matt haven't added so far, you can see in the Books On-line: Enabling AWE Memory for SQL Server
Best Regards,
Luis Darui
Hi Carlo,
In addition to Luis' questions, I would ask are you running on 32-bit?
Cheers,
Matt
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Carlo,
1) What version of SQL Server are you running?
2) What SAP Product are you running on this SQL Server?
Regards,
Luis Darui
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Is this any error message during the log out time in application log?
BR
SS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.