Allocation Memory Error – SBS 2003
SQLservr.exe – fejl i hukommelse/allokering. SBS 2003
http://msmvps.com/blogs/bradley/archive/2005/02/04/34984.aspx
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
administrator.
Configuration option ‘max server memory (MB)’ changed from 2147483647 to 70.
Run the RECONFIGURE statement to install.
1>