HPE Community
BackOffice Products
1863039 Members
1127 Online
110446 Solutions
New Discussion

SQL 7 Memory Usage

 
Andy Dane
Occasional Advisor

‎11-30-2001 02:28 AM

‎11-30-2001 02:28 AM

SQL 7 Memory Usage

We're using a SQL 7 sp3 database on NT4 sp6a and we're seeing the memory used by the SQLSERVR process slowly increasing - anyone know if there are any memory leaks or similar that causes this?
DB is permanently on (repository of monitoring software) so can't easily be stopped and started...

Andy
If it ain't broke don't fix it.
0 Kudos
1 REPLY 1
Jamie Hughes
Honored Contributor

‎11-30-2001 08:06 AM

‎11-30-2001 08:06 AM

Re: SQL 7 Memory Usage

Hello Andy,

Yes, there are a lot of memory leak situations you could be running into. SQL can be leaky, as well as ODBC drivers, MDAC, etc. Since I'm not familiar with your environment, it would probably be better if you scan thru the documents on the MS website and see if any of them match your specific situation.

http://support.microsoft.com

Search on sql memory leak, and you will get back many articles.

Best regards,
Jamie Hughes
0 Kudos
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.