CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

Unable to set limited for MS sqlserver.exe high memory usage 2008 R2

edited Jun 5, 2015 9:33AM in CNC, DB and Operating System - JDE1 (MOSC) 5 commentsAnswered

HI,

we are unable to set the memory use limited for sql server exe.

we are running the JDE Enterprise server and database server (MS SQL SERVER 2008 R2 64 bit) on same box.

The sqlserver occupied almost all memory of system. Even i have set the limited for memory from sql server properties.

The SQ L Server still use the more memory as i set the limited.

GO

sp_configure 'show advanced options', 1;

output:  onfiguration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.

GO

RECONFIGURE;

ommand(s) completed successfully

GO

sp_configure 'max server memory', 40096;

GO

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center