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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Memory Usage

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-11-01 : 09:10:15
Chandima writes "Hi,

We had a system which was runing in Informix. Finally we thought of migrating it to SQL Ver 7.

We did some ammendments to our coding and there was no big ammendment as we have use ADO.

But the problem I'm facing now is some of the processes in the system, uses memory very badly. and it won't release the memory after the procees ends. The tables were quite big and have about 1.7 million records. So I have use a Stored Procedure to query the data. But the problem stiil the same.

Pls. let me know what to do.

Thanks & Regards

Chandima S. Galketiya
Chandimaa@mastsl.com
Tel 94-74-285500 ext 1309"
   

- Advertisement -