About the only tip I can give you is this. Give yourself enough room for your transaction logs. They are growing for a reason...you could try turning on sql logging to see what your server is busy doing because the logs shouldn't be growing if your app isn't doing anything. Your DBA should be able to tell you who is connected to the db, and your sql logs should be able to tell you who is making modifications to what values.
_____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Brian Gillock Sent: Monday, June 23, 2008 5:23 PM To: [email protected] Subject: SQL Server huge translogs and very poor performance ** Hey Listers, Does anyone have any tips for maintaining transaction logs in SQL Server? Ours seem to growing at an insane rate and nothing our DBAs are doing is helping at all. And I'm continually getting time outs when trying to save workflow. And that is without any users. There is nothing special setup in development and I can do a backup, truncating the logs and that helps for a while. In production, however, we have log mirroring setup for DR purposes. It's killing me. The DB and AR box are both on their own dual quad core servers with 4GB RAM, so I don't think it's a resource issue. Any advice is appreciated. Thanks! Brian __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
