Archives of the TeradataForum
Message Posted: Thu, 18 Oct 2001 @ 19:04:14 GMT
| Subj: | | JDBC out of memory problems |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Thursday, October 18, 2001 13:58 -->
Hello all. We're running JDBC 2.1.1.6 on an NT server with 524288 KB of memory to access Teradata. As we add applications, we're
encountering more and more problems with "out of memory" conditions on the NT server. To get the server working again occasionally we can
just start the NT service for JDBC and it starts working again, but other times we have to reboot the server. We discovered that one
possible cause of memory problems is not closing statements in the application code, and we believe we've found and fixed that type of
code.
Have other sites had similar problems with memory? Do you have a feel for how many Teradata sessions or requests can run through a
server? I've been unable to get any information on memory requirements per session or request. We typically run between 100-200 sessions
at a time. Can anyone share their experience?
TIA.
| 
