memory usage

Last Post 13 Oct 2008 10:02 AM by dbandee. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
dbandee
New Member
New Member

--
13 Oct 2008 10:02 AM
we have sql 2000 ENT running on win 2003 Ent

server has 8 GB of ram
when i look into sql server properties i can see Min 0 and Max 8192 MB values and "Dynamically Configure Option" is checked.
However in task manager sqlservr.exe is always at 1,763,732
server is also slow (everyone complains)

i would like sql server tu utilize more RAM

I checked boot.ini and PAE switch is not there, i understand i need to have it enabled before using AWE? am i correct?

So what do i need to do to enable SQL Server use more RAM, please. Thanks

i ran sp_configure and it reports the following:
name minimum maximum config_value run_value
----------------------------------- ----------- ----------- ------------ -----------
affinity mask -2147483648 2147483647 0 0
allow updates 0 1 1 1
awe enabled 0 1 0 0
c2 audit mode 0 1 0 0
cost threshold for parallelism 0 32767 5 5
Cross DB Ownership Chaining 0 1 0 0
cursor threshold -1 2147483647 -1 -1
default full-text language 0 2147483647 1033 1033
default language 0 9999 0 0
fill factor (%) 0 100 0 0
index create memory (KB) 704 2147483647 0 0
lightweight pooling 0 1 0 0
locks 5000 2147483647 0 0
max degree of parallelism 0 32 0 0
max server memory (MB) 4 2147483647 2147483647 2147483647
max text repl size (B) 0 2147483647 65536 65536
max worker threads 32 32767 255 255
media retention 0 365 0 0
min memory per query (KB) 512 2147483647 0 1024
min server memory (MB) 0 2147483647 0 0
nested triggers 0 1 0 0
network packet size (B) 512 65536 4096 4096
open objects 0 2147483647 0 0
priority boost 0 1 0 0
query governor cost limit 0 2147483647 0 0
query wait (s) -1 2147483647 -1 -1
recovery interval (min) 0 32767 0 0
remote access 0 1 0 0
remote login timeout (s) 0 2147483647 20 20
remote proc trans 0 1 0 0
remote query timeout (s) 0 2147483647 0 0
scan for startup procs 0 1 0 0
set working set size 0 1 0 0
show advanced options 0 1 1 1
two digit year cutoff 1753 9999 2049 2049
user connections
You are not authorized to post a reply.

Acceptable Use Policy