Allocation Memory Error – SBS 2003

SQLservr.exe – fejl i hukommelse/allokering. SBS 2003

tasklist /svc

Then go into Task Manager, click on the Processes tab [click on view/select columns options to make sure the PID [process identifier] option is selected and look for the different process IDs to see which process ID is using the memory.

PID is 672 in the one tracks to MSSQL$SBSMONITORING in the other.

osql -E -S YOURSERVERNAMEsbsmonitoring  [hit enter]

[you’ll now enter like a command screen]

sp_configure ‘show advanced options’,1 [hit enter]

reconfigure with override  [hit enter]]

go  [hit enter]

sp_configure ‘max server memory’, ### [enter the value of the max… I’m trying 70 … I just guessed at this from the poster in the newsgroup]  [hit enter]

reconfigure with override  [hit enter]

go  [hit enter]

Herefter skulle der gerne stå:
DBCC execution completed. If DBCC printed error messages, contact your system
Configuration option ‘max server memory (MB)’ changed from 2147483647 to 70.
Run the RECONFIGURE statement to install.