Bonjour!
I got the following messages about 3-4 times a day on my SQL Server 2000 8.00.760 Service Pack 3A.
1- WARNING: Failed to reserve contiguous memory of Size= 131072.
2- Global Memory Objects: Resource=1770 Locks=191
SQLCache=181 Replication=2
LockBytes=2 ServerGlobal=43
Xact=22
3- Query Memory Manager: Grants=0 Waiting=0 Maximum=251252 Available=251252
4- Buffer Distribution: Stolen=1440 Free=1219 Procedures=4405
Inram=0 Dirty=75766 Kept=0
I/O=0, Latched=30, Other=255732
5- Buffer Counts: Commited=338592 Target=338592 Hashed=331528
InternalReservation=148 ExternalReservation=0 Min Free=128
6- Procedure Cache: TotalProcs=1216 TotalPages=4405 InUsePages=2331
7- Dynamic Memory Manager: Stolen=5845 OS Reserved=2032
OS Committed=2014
OS In Use=1881
Query Plan=5159 Optimizer=154
General=2088
Utilities=7 Connection=84
When this happened, users can't access the SQL Server anymore until I restart SQL services.
Sometimes, the error number= 17803, Severity = 20 "Insufficient memory available" appears, but not most of the time.
The OS is Windows 2000 Service Pack 4, with 3968MB of memory. Also, there is about 115 GB of free space on the data disk. There is 4.4 GB of free space on the drive on which SQL Server is installed.
The /3GB option is activated on the server. Also, the AWE option has been tried (with an addition on 2 GB of memory) without success.
I was wondering if the TEXT parameters in my stored procedures were the cause of this missing of memory space? Those TEXT parameters represent XML documents which are opened in the Stored procedures, and closed at the end of it. (The XMLs documents have about 3k to 10K maximum each and those Stored Proc have 7 parameters of this type).
There may be about up to 50 concurrent users on the SQL Server.
Also, I have 3 linked Server on Oracle 9i databases. It appears to deconnected some times by day also.
Thank you for helping me!
Anne-Marie
I got the following messages about 3-4 times a day on my SQL Server 2000 8.00.760 Service Pack 3A.
1- WARNING: Failed to reserve contiguous memory of Size= 131072.
2- Global Memory Objects: Resource=1770 Locks=191
SQLCache=181 Replication=2
LockBytes=2 ServerGlobal=43
Xact=22
3- Query Memory Manager: Grants=0 Waiting=0 Maximum=251252 Available=251252
4- Buffer Distribution: Stolen=1440 Free=1219 Procedures=4405
Inram=0 Dirty=75766 Kept=0
I/O=0, Latched=30, Other=255732
5- Buffer Counts: Commited=338592 Target=338592 Hashed=331528
InternalReservation=148 ExternalReservation=0 Min Free=128
6- Procedure Cache: TotalProcs=1216 TotalPages=4405 InUsePages=2331
7- Dynamic Memory Manager: Stolen=5845 OS Reserved=2032
OS Committed=2014
OS In Use=1881
Query Plan=5159 Optimizer=154
General=2088
Utilities=7 Connection=84
When this happened, users can't access the SQL Server anymore until I restart SQL services.
Sometimes, the error number= 17803, Severity = 20 "Insufficient memory available" appears, but not most of the time.
The OS is Windows 2000 Service Pack 4, with 3968MB of memory. Also, there is about 115 GB of free space on the data disk. There is 4.4 GB of free space on the drive on which SQL Server is installed.
The /3GB option is activated on the server. Also, the AWE option has been tried (with an addition on 2 GB of memory) without success.
I was wondering if the TEXT parameters in my stored procedures were the cause of this missing of memory space? Those TEXT parameters represent XML documents which are opened in the Stored procedures, and closed at the end of it. (The XMLs documents have about 3k to 10K maximum each and those Stored Proc have 7 parameters of this type).
There may be about up to 50 concurrent users on the SQL Server.
Also, I have 3 linked Server on Oracle 9i databases. It appears to deconnected some times by day also.
Thank you for helping me!
Anne-Marie
