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

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

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

Tal vez usted ha habilitado AWE? Cuando AWE está habilitado no se puede
aplicar tamaño al "working set".

Gustavo Larriera, Microsoft MVPhttp://www.linkedin.com/in/gustavolarriera
Este mensaje se proporciona tal como es, sin garantías de ninguna clase.



"JoseNadim" wrote:
> 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

>JoseNAdim- Ocultar texto de la cita -

- Mostrar texto de la cita -