Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-10 : 08:39:10
|
| Anne-Marie writes "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=223- Query Memory Manager: Grants=0 Waiting=0 Maximum=251252 Available=2512524- Buffer Distribution: Stolen=1440 Free=1219 Procedures=4405 Inram=0 Dirty=75766 Kept=0 I/O=0, Latched=30, Other=2557325- Buffer Counts: Commited=338592 Target=338592 Hashed=331528 InternalReservation=148 ExternalReservation=0 Min Free=1286- Procedure Cache: TotalProcs=1216 TotalPages=4405 InUsePages=23317- 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=84When 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" |
|
|
chadmat
The Chadinator
1974 Posts |
|
|
|
|
|
Failed to reserve contiguous memory 