RE: [Emerald] Emerald/SQL Help Please!

New Message Reply Date view Thread view Subject view Author view
Jeffrey M Donley (
Thu, 17 Apr 2003 06:32:14 -0400

From: "Jeffrey M Donley" <>
Subject: RE: [Emerald] Emerald/SQL Help Please!
Date: Thu, 17 Apr 2003 06:32:14 -0400
Message-ID: <>

John, This article explains the memory usage in SQL.;en-us;321363

What you are describing seems normal for sql 7.0 and 2000. Does this happen just on your roam ports? I am assuming that your wholesale ports have different radius servers forwarding requests to yours. If this is the case I would double check and make sure you are getting stop requests from them. Regardless, it seems that the problem is stop requests not being received.


-----Original Message----- From:
[]On Behalf Of John Kern Sent: Wednesday, April 16, 2003 5:24 PM To: Subject: [Emerald] Emerald/SQL Help Please!

Using NT4/SP6, SQL7/SP3 Emerald/RadiusNT 2.5

We have our own ports and we have wholesale ports. In the online screen the wholesale ports show up as roam when the user is online.

The server has 384MB RAM. If the server is re-booted, the roam users log on and off just fine. After approx 2 days the roam users don't get logged off(they are not connected, but Emerald online screen still shows them online), at which time the task manager shows sqlsvr.exe using approx 360MB of RAM.

Is there something in Emerald that can be changed to solve this problem? I really do not want to have to reboot every 2 days.

We have been running Emerald for a long time and this has never been an issue until the last 6 months. I have finally taken the time to start tracking down this problem and now it seems as though it is something related to memory.




John Kern PowerNet Communications 419-822-3988 Dial-Up, Wireless & Satellite Internet Domain Registration & Web Hosting Nextel Cellular & Accessories


This is a user supported list. If you require assistance from IEA Software's Support Engineers, please check out our Support resources at

For more information about this list (including removal) go to:

New Message Reply Date view Thread view Subject view Author view
This archive was generated on Thu Apr 17 2003 - 03:26:22 Pacific Daylight Time