AMS and SQL slowness

[zach]

Hello, I am new to my current employer and don't have much experience administering Avast which is licensed for the entire company of a little over 100 machines. I have been reading over all the white papers trying to find a solution to a problem that has developed over the last 2 weeks.

We run AMS on a dedicated application server and the DB on SQL 2000/Win2000 Server.

Suddenly about 2 weeks ago, our field production application started lagging as the clients navitaged from screen to screen within our business application which is all SQL DB driven.
After a very long process of elimination, the only thing that seems to have corrected the 30sec-2min lag time was stopping the Avast Management Server service.
I updated the application to the latest version of setup_adnm_no_msde.exe. We found that the avast DB on the SQL server recovery model was set to Simple instead of Full Control. We switched to Full Control and backed up the DB and the transaction logs. We manually shrunk the DB.

However when I restarted the AMS server service, the other SQL DB's continued to lock up again so I stopped the AMS service again. Production responces returned to normal.

I'm not sure where to go from here. I see the AMS Maintenance application has some DB features, but I am leary of deleting and recreating the DB as I am simply not familier with this product and the impact such a move might cause.

Thanks for your time,
Zach

[zach]

No nuggets of wisdom for a newbie?

[ingernet]

Zach and I work together at the same company, and we're still hitting this snag.  We've found more information via the SQL Profiler, which we ran after turning AMS back on.  We're both pretty new at this, and if anyone could throw us a bone, that'd be great.  No ideas too dumb or outlandish; we're about at the point of calling a voodoo doctor in to throw some chicken bones for us.

Here are the types of messages that we're getting (and we're getting a LOT of these):

RPC:Completed   50   2007-03-02 14:25:36.823   exec avsEvent 8040050, 'CATI17', 1107296346, 'Feb 23 2007  9:51:34:000PM', 'CClient::PopupThread - GetConnection failed!', ' '   avast! Antivirus       sa   0   0   1   173   6888   265   2007-03-02 14:25:36.650   
RPC:Completed   50   2007-03-02 14:25:36.823   exec avsEvent 6163979, 'CATI14', 1107296346, 'Feb 24 2007  4:06:53:000AM', 'CClient::PopupThread - GetConnection failed!', ' '   avast! Antivirus       sa   0   0   1   236   6888   264   2007-03-02 14:25:36.587   
RPC:Completed   50   2007-03-02 14:25:36.823   exec avsEvent 3223329, 'SCOTT', 1107296346, 'Feb 28 2007  5:05:43:000PM', 'CClient::PopupThread - GetConnection failed!', ' '   avast! Antivirus       sa   0   0   1   173   6888   220   2007-03-02 14:25:36.650   
RPC:Completed   50   2007-03-02 14:25:36.823   exec avsEvent 6163979, 'CATI14', 1107296346, 'Feb 24 2007 12:00:53:000AM', 'CClient::PopupThread - GetConnection failed!', ' '   avast! Antivirus       sa   0   0   1   173   6888   182   2007-03-02 14:25:36.650   
RPC:Completed   50   2007-03-02 14:25:36.823   exec avsEvent 15044701, 'PEACHTREE', 1107296346, 'Feb 27 2007 10:42:10:000PM', 'CClient::PopupThread - GetConnection failed!', ' '   avast! Antivirus       sa   0   0   1   173   6888   203   2007-03-02 14:25:36.650   


Please let us know if we can provide any other information that might illuminate the source of the problem.  Thanks!
Inger