Forside > SBS2003, Windows Server > Allocation Memory Error – SBS 2003

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 YOURSERVERNAME\sbsmonitoring  [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>

Kategorier:SBS2003, Windows Server
  1. Endnu ingen kommentarer.
  1. No trackbacks yet.

Skriv et svar

Please log in using one of these methods to post your comment:

WordPress.com Logo

Du kommenterer med din WordPress.com konto. Log Out / Skift )

Twitter picture

Du kommenterer med din Twitter konto. Log Out / Skift )

Facebook photo

Du kommenterer med din Facebook konto. Log Out / Skift )

Google+ photo

Du kommenterer med din Google+ konto. Log Out / Skift )

Connecting to %s

%d bloggers like this: