RE: [Emerald] Emerald Database SLOW!

New Message Reply Date view Thread view Subject view Author view
Dale E. Reed Jr. (daler@iea-software.com)
Mon, 15 Mar 2004 14:49:53 -0800



From: "Dale E. Reed Jr." <daler@iea-software.com>
Subject: RE: [Emerald] Emerald Database SLOW!
Date: Mon, 15 Mar 2004 14:49:53 -0800
Message-ID: <HGEOIEGNKPHMIJCINCPBMEPLCAAA.daler@iea-software.com>

> Having problems with the Emerald installation I inherited from the
> previous owner. Suddenly, without warning, it slowed down to a crawl.
> Radius authentication is so slow it times out. I'm at my wits end.
>
> Looks like a probable database corruption, though I am more than open to
> other ideas.
> If it is database corruption (or anything else for that matter),
> suggestions for resolving would be appreciated.
>
> Using Emerald 2.5, Microsoft SQL 7.0 on an NT 4.0 box. Total of 165
> active accounts.
> Patched up to 6A for NT and 2 for SQL.

Use Enterprise Manager to look at the Current Activity of your SQL Server. It should tell you any locks or running queries on our SQL server that may be causing delays. Check for a calls consolidation that may be taking a lot of resources.



New Message Reply Date view Thread view Subject view Author view
This archive was generated on Mon Mar 15 2004 - 14:50:30 Pacific Standard Time