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 - 2003-09-22 : 07:34:16
|
| Andriy writes "Configuration:Windows 2000 ServerSQL Server 2000 SP32 CPU Pentium Xeon 2GHz2GB RAM2 databases about 35 MB in size (each).SQL Server sometimes utilizes all system resources (memory and CPU). After my investigation, I think this is memory leak in SQL Server. But I cannot find any description of this output, especially "Global Memory Objects".Question: Why this error ocuurs?Server produces in errorlog file the following output:----------------- cut2003-09-09 13:27:32.30 server Error: 17803, Severity: 20, State: 172003-09-09 13:27:32.30 server Insufficient memory available..2003-09-09 13:27:43.60 spid1 LazyWriter: warning, no free buffers found.2003-09-09 13:27:43.60 spid1 Buffer Distribution: Stolen=106379 Free=0 Procedures=13016 Inram=0 Dirty=9008 Kept=0 I/O=0, Latched=749, Other=02003-09-09 13:27:43.60 spid1 Buffer Counts: Commited=129152 Target=129152 Hashed=9757 InternalReservation=889 ExternalReservation=0 Min Free=2562003-09-09 13:27:43.60 spid1 Procedure Cache: TotalProcs=3250 TotalPages=13016 InUsePages=130162003-09-09 13:27:43.60 spid1 Dynamic Memory Manager: Stolen=119395 OS Reserved=1240 OS Committed=1200 OS In Use=1194 Query Plan=113656 Optimizer=4 General=5483 Utilities=6 Connection=13932003-09-09 13:27:43.60 spid1 Global Memory Objects: Resource=4085 Locks=42 SQLCache=822 Replication=2 LockBytes=2 ServerGlobal=42 Xact=5132003-09-09 13:27:43.60 spid1 Query Memory Manager: Grants=0 Waiting=0 Maximum=7374 Available=7374" |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
|
|
ap
Starting Member
1 Post |
Posted - 2003-09-24 : 05:39:38
|
| Dear Sam SekarAny of this article from KB do not meet my problem.with best regards, Andriy |
 |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-09-24 : 07:21:59
|
| Are you running any Cursors ?. unclosed cursors may cause performance degradation.Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-09-24 : 07:44:27
|
Hell, OPEN cursors cause performance degradation.  |
|
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-09-24 : 07:57:01
|
Rob, I read this in the MS KB, put your comments on this...quote:
Microsoft Knowledge Base Article - 820773 The Microsoft SQL Server 2000 Driver for JDBC does not close server cursors that it opens under some conditions. This can cause cursor build up and memory pressure on Microsoft SQL Server. This can also cause server and application performance degradation, so that eventually clients can no longer connect to the SQL Server.
Sekar~~~~Success is not a destination that you ever reach. Success is the quality of your journey. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-09-24 : 08:02:37
|
| Hmmmmm. I don't know anything about JDBC but I'm pretty sure most API-type data connectors function with some kind of cursor, either internally or externally. ODBC does, and ADO uses them sometimes as well.Does the article further describe which types of cursor it does not close? |
|
|
|
|
|
|
|
|
Global Memory Objects