From: "Dale E. Reed Jr." <email@example.com> Subject: RE: [Emerald] Emerald Database SLOW! Date: Mon, 15 Mar 2004 14:49:53 -0800 Message-ID: <HGEOIEGNKPHMIJCINCPBMEPLCAAA.firstname.lastname@example.org>
> 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.