sql server 2000 1

[spaliwal]

I am facing a problem with sql server 2000. I am doing transactions upto 50000 - 100000 records. Problem with sql server is its not realeasing memory after completing the transactions. Ultimetly it grabs all the memory resource .Finally i have to restart server to release the memory.I am using default setting , i have not set any memory related parameters.

 

[ColinM]

Might be worth installing service pack 2

 

[spaliwal]

Hi ColinM,

Thanks!
I have installed sql server 2000 service pack 2 (SP2) , but still i am facing the same problem. actually my am handling lacs of recs for data migration/ transalation from dbf to sql server 2000. All the memory is exhausted even after regular interval i am comming the transactions.I will be greatful if anybody can help me .

Rgds,

Shailesh

 

[tlbroadbent]

Is memory (RAM) being consumed or disk space? Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[spaliwal]

Hi tlbroadbent

It consumes all thev RAM , in my system there is 512MB RAM.

Shailesh

 

[spaliwal]

Hi tlbroadbent

It consumes all RAM (main memory) Not the Hard disk space.


Shailesh