Memory : Pool Paged Bytes Increasing until Database Server Hang Up

Hi,
I have a SQL2000 server that is running a DTS continuously and I
discover that
my server pool paged bytes keep increasing until the whole db server
would hang up and I need to reboot the db server.
Details of my db server :
OS Patch : SP3
SQL Patch : SP3
Memory : 3GB
I have tried monitoring all the process but none of them seems to be
increasing. These are the process that I am monitoring.
-Memory : Available Bytes
-Memory : Pool Paged Bytes
-Process : Handle Count
-Process : Non Paged Bytes
-Process : Paged Bytes
-Process : Private Bytes
Is there anything that I can monitor to check why my memory:pool paged
bytes is increasing?
Appreciate your help.
ThanksMike,
Did you ever find an answer to your question? I am having a similar
issue with my servers.
jtw
On 28 Aug 2003 19:45:38 -0700, MikeLee@.techsemicon.com.sg (Mike Lee)
wrote:
>Hi,
>
>I have a SQL2000 server that is running a DTS continuously and I
>discover that
>my server pool paged bytes keep increasing until the whole db server
>would hang up and I need to reboot the db server.
>Details of my db server :
>OS Patch : SP3
>SQL Patch : SP3
>Memory : 3GB
>I have tried monitoring all the process but none of them seems to be
>increasing. These are the process that I am monitoring.
>-Memory : Available Bytes
>-Memory : Pool Paged Bytes
>-Process : Handle Count
>-Process : Non Paged Bytes
>-Process : Paged Bytes
>-Process : Private Bytes
>Is there anything that I can monitor to check why my memory:pool paged
>bytes is increasing?
>Appreciate your help.
>Thanks
--
http://www.UsenetRocket.comsql

Memo field problem using Access97 with SQL2000 Backend

I have an application written in Access 97 that connects to a SQL2000
backend. One field is a description field that is a data type NTEXT in the
SQL database. In my access form, I can not enter more than 255 characters.

Before I converted the backend to SQL, the description field was a memo
field in Access.

What do I need to do to make it so I can enter more text into this field?NChar, NVarChar, and NText are double-byte unicode types. For
example, nchar(10) will hold 10 bytes of data but takes 20 bytes of
space. Convert the field's datatype to Text and you should be fine.

Look up "data types-SQL Server, described" in Books Online for more
info.

"Bob" <bobh@.wolv.tds.net> wrote in message news:<vta8f56bkredfd@.corp.supernews.com>...
> I have an application written in Access 97 that connects to a SQL2000
> backend. One field is a description field that is a data type NTEXT in the
> SQL database. In my access form, I can not enter more than 255 characters.
> Before I converted the backend to SQL, the description field was a memo
> field in Access.
> What do I need to do to make it so I can enter more text into this field?