From: "Michael D. Bathrick" <bathrick@berkshire.net> Subject: RE: [Emerald] Emerald Database SLOW! Date: Tue, 16 Mar 2004 15:04:54 -0500 Message-ID: <1b1401c40b91$f3213620$50506f0c@ubu>
Thanks - figured it out (I hope). Looks like a not related problem that
just looked related at the time. We had an instance of VNC server
running on the server. When connected to the network, VNC would push
explorer up over 98% CPU - when disconnected from the network,
everything worked fine. Disabled VNC and all went back to normal.
Thanks for the help!
Michael D. Bathrick
President
BerkshireNet, Inc
126 Fenn Street
Pittsfield, MA 01201
(413) 442-7805
-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com] On Behalf Of Dale E. Reed Jr.
Sent: Monday, March 15, 2004 5:50 PM
To: emerald@iea-software.com
Subject: RE: [Emerald] Emerald Database SLOW!
> 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.