[RadiusNT] Memory Problems with SQLServer 7.0

Charlie Cocuzza ( (no email) )
Mon, 4 Oct 1999 09:20:00 -0400

We have run RadiusNT 2.5.124 ( the latest we've updated to from earlier
versions) for over 1 1/2 years now with SQLServer 6.5 and have had no memory
issues. RadiusNT and SQLServer are on seperate machines and memory stays
pretty solid with little fluctuation.

We currently upgraded SQLServer to 7.0, and have merged the Radius database
into our Billing system. The billing system is Platypus, and they say the
work directly with Radius NT. SQLServer is on a Compaq Proliant running
Windows NT 4.0 with SP4, with 256meg of Ram and 12 gig of free hard drive
space. Radius NT (version 2.5.124) is on an IBM compatible computer running
Windows NT 4.0 SP5 with 196meg of ram and 2 gig of free hard drive space.

RadiusNT runs like a rock. No problems. The problem is the memory leak on
SQLServer. We are an ISP and authenticate approx 6000 people thru the
server. The SQLServer's computer memory requirement rises from 154meg (with
SQL turned off), to 350meg in less than 12 hours. If I turn off Radius, the
memory requirement does not rise, so I've narrowed it down to a
Radius/ODBC/SQLServer7 issue.

I don't know what to do. Does anyone know if there is there a trigger or
stored procedure that I might have missed importing into the billing
database that flushes memory cache, or is there something in SQLServer I
need to set to flush cache memory?

Charlie Cocuzza
Omega Solutions/Picus Communications
Phone: (860) 276-8504
Fax: (860) 276-0192

Email me at charlie@megahits.com

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart