|
The following allows
you to specify how
much memory your SQL
server is using in
Windows Server 2003
or Windows Small
Business Server
environments.
Check
to see what tasks
are running from cmd
prompt. Tasklist
/svc
Do
the following at the
cmd prompt to change
the maximum amount
of memory SQL Server
can use. Type:
osql -E -S
YOURSERVERNAME\sbsmonitoring
(Press Enter)
Note: You
will now enter a
command screen
Type: sp_configure
show advanced
options,1
(Press Enter)
Type: reconfigure
with override
(Press Enter)
Type: go (Press
Enter)
Type:
sp_configure max
server memory,
(Enter the value of
max memory eg:70) (Press
Enter)
Type: reconfigure
with override
(Press Enter)
Type: go
(Press Enter)
|
