17122 : Warning: Could not set working set size to 2097152 KB.

13/02/2009 - 02:46 por Jose Nadim | Informe spam
Hola buenas noches no encuentro la razón por la cual la memoria
utilizada por sql server es solo 130 mb cuando le asigne 6.5 gb,
agradezco sugerencias

El servidor esta configurado asi :
Windows Server 2003 EE con 8 gb de memoria 4 procesadores ,sql 2000
EE spack 3; asignados 6.5 gb de memoria a sql server
El task manager muestra de memoria utilizada por sqlserver.exe 135 mb
El log de sql muestra lo siguiente :
17122 :
initdata: Warning: Could not set working set size to 2097152 KB.

Sp_configure esta asi :
name,minimum,maximum,config_value,run_value
affinity mask,-2147483648,2147483647,0,0
allow updates,0,1,0,0
awe enabled,0,1,1,1
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,5,5
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,6144,6144
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,1024,1024
min server memory (MB),0,2147483647,0,0
nested triggers,0,1,1,1
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
scan for startup procs,0,1,0,0
set working set size,0,1,1,1
show advanced options,0,1,1,1
two digit year cutoff,1753,9999,2049,2049
user connections,0,32767,0,0
user options,0,32767,0,0

gracias

Jose NAdim
 

Leer las respuestas

#1 Maxi
13/02/2009 - 03:58 | Informe spam
Hola, le recomiendo leer este link , usted tiene mas de 4gb de ram en un
sistema x32 como es seguro el windows y el SQL.

http://www.mssqltips.com/tip.asp?tip68




Maxi Accotto
Microsoft MVP en SQL Server
Consultor en SQL Total Consulting



"Jose Nadim" escribió en el mensaje de
noticias:
Hola buenas noches no encuentro la razón por la cual la memoria
utilizada por sql server es solo 130 mb cuando le asigne 6.5 gb,
agradezco sugerencias

El servidor esta configurado asi :
Windows Server 2003 EE con 8 gb de memoria 4 procesadores ,sql 2000
EE spack 3; asignados 6.5 gb de memoria a sql server
El task manager muestra de memoria utilizada por sqlserver.exe 135 mb
El log de sql muestra lo siguiente :
17122 :
initdata: Warning: Could not set working set size to 2097152 KB.

Sp_configure esta asi :
name,minimum,maximum,config_value,run_value
affinity mask,-2147483648,2147483647,0,0
allow updates,0,1,0,0
awe enabled,0,1,1,1
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,5,5
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,6144,6144
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,1024,1024
min server memory (MB),0,2147483647,0,0
nested triggers,0,1,1,1
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
scan for startup procs,0,1,0,0
set working set size,0,1,1,1
show advanced options,0,1,1,1
two digit year cutoff,1753,9999,2049,2049
user connections,0,32767,0,0
user options,0,32767,0,0

gracias

Jose NAdim

Preguntas similares