Error SQL

Hmm, yo que vos haria revisar que la mamoria ram del servidor este en
optimas condiciones, y que los discos duros tambien

Suerte




Maxi

Buenos Aires - Argentina
Desarrollador .NET 3 Estrellas
Microsoft User Group (MUG)
Mail: Maxi_accotto[arroba]speedy.com.ar
Msn Messager:

"Carlo" escribió en el mensaje
news:

Estimados, en los registros de SQL, desde un tiempo a esta parte, en forma
aleatoria, me esta arrojando el siguiente error:

2004-08-20 10:41:53.90 spid68 WARNING: Failed to reserve contiguous
memory of Size= 65536.
2004-08-20 10:41:53.95 spid68 Buffer Distribution: StolenB94942377
Free3 Procedures"1442
Inram=0 Dirty!76
Kept=0
I/O=2, Latched&1,
Other0865
2004-08-20 10:41:53.95 spid68 Buffer Counts: Commited20000
Target20000 Hashed3304

InternalReservationw7 ExternalReservation=0 Min Free4
2004-08-20 10:41:53.95 spid68 Procedure Cache: TotalProcs933
TotalPages"1442 InUsePages7260
2004-08-20 10:41:53.95 spid68 Dynamic Memory Manager: Stolen6523 OS
Reserved8176
OS Committed8133
OS In Use8046
Query Plan"4443
Optimizer=0
General€09
Utilities
Connection36
2004-08-20 10:41:53.97 spid68 Global Memory Objects: ResourceI78
Locks™
SQLCache%19
Replication=2
LockBytes=2
ServerGlobalF
Xact12
2004-08-20 10:41:53.97 spid68 Query Memory Manager: Grants=0 Waiting=0
Maximum1357 Available1357

Que puede ser...??

Atte.,
Carlo

Una búsqueda en la KB encuentra estos articulos respecto a ese problema.
Búscalos ingresando el número de artículo respectivo (son los 6 dígitos
entre paréntesis) en el buscador de http://support.microsoft.com/



FIX: You receive a "Failed to reserve contiguous memory of Size= <size>"
error message when you run a query that has many predicates that are a
sql_variant data type in SQL Server 2000
(832674) - When you run a query that has many sql_variant predicates, you
may receive an error message. This article contains a fix for this problem.

FIX: SP_OA Procedures Leak Memory and Cause Various Errors
(282229) - Calling OLE Automation support stored procedures, namely
sp_OAMethod , sp_OAGetProperty , and sp_OASetProperty , leak a small amount
of memory in the OLE Automation Object operation DLL (Odsole70.dll) file.
This may cause the following errors to be...

FIX: Cursor Plans Are Not Removed From the Cache When Virtual Memory
Depleted
(818095) - SQL Server may run slowly, and the SQL Server error log contains
error messages that repeat continuously (as frequently as several times per
second). The error messages are similar to: 2003-01-31 16:04:20.25 spid73
WARNING: Failed to reserve...


Gustavo Larriera, MVP
Uruguay LatAm
http://sqljunkies.com/weblog/gux/
Este mensaje se proporciona "COMO ESTA" sin garantias y no otorga ningun
derecho / This posting is provided "AS IS" with no warranties, and confers
no rights.
"Carlo" wrote in message
news:

Estimados, en los registros de SQL, desde un tiempo a esta parte, en forma
aleatoria, me esta arrojando el siguiente error:

2004-08-20 10:41:53.90 spid68 WARNING: Failed to reserve contiguous
memory of Size= 65536.
2004-08-20 10:41:53.95 spid68 Buffer Distribution: StolenB94942377
Free3 Procedures"1442
Inram=0 Dirty!76
Kept=0
I/O=2, Latched&1,
Other0865
2004-08-20 10:41:53.95 spid68 Buffer Counts: Commited20000
Target20000 Hashed3304

InternalReservationw7 ExternalReservation=0 Min Free4
2004-08-20 10:41:53.95 spid68 Procedure Cache: TotalProcs933
TotalPages"1442 InUsePages7260
2004-08-20 10:41:53.95 spid68 Dynamic Memory Manager: Stolen6523 OS
Reserved8176
OS Committed8133
OS In Use8046
Query Plan"4443
Optimizer=0
General€09
Utilities
Connection36
2004-08-20 10:41:53.97 spid68 Global Memory Objects: ResourceI78
Locks™
SQLCache%19
Replication=2
LockBytes=2
ServerGlobalF
Xact12
2004-08-20 10:41:53.97 spid68 Query Memory Manager: Grants=0 Waiting=0
Maximum1357 Available1357

Que puede ser...??

Atte.,
Carlo