topic SQL transaction log grows rapidly in Server Management - Systems Insight Manager

SQL transaction log grows rapidly

PhilC_1 — Tue, 16 Aug 2011 16:31:10 GMT

Hi - my DBA has reported that the transaction log file for my HP SIM v6.2 installation grows has grown rapidly on two occasions recently. Both times it was in the early hours of a Sunday morning. We're using SQL2008 R2. The database is on a seperate server to HP SIM - this runs on a Windows 2008 R2 server.

I suspect a scheduled task is causing the issue, but looking through them I can't see which one would have caused it. Has anyone else experienced anything similar?

I've attached some screenshots - thanks.

Re: SQL transaction log grows rapidly

jim goodman — Tue, 16 Aug 2011 18:29:14 GMT

Hey Phil - a lot of different things cause that to blow up, especially if you are noticing a particular schedule. Apart of Schedule Tasks, could be auto-discoveries, other agents, back up solution even can create a problem as well. Hard to tell without digging into your network activities and even CMS logs.

In anycase the best way to deal with growing transaction logs it is to simply set SQL Recovery Mode to Simple and then your back up solution should cut that log file down after the back up. For SIM you really don't need to worry about recovering transaction logs if you need to restore since the data in the database doesn't change all that much.

Re: SQL transaction log grows rapidly

PhilC_1 — Wed, 17 Aug 2011 08:50:24 GMT

Thanks - I've passed your comments over to my DBA team and I'll let you know what they say.

Phil

Re: SQL transaction log grows rapidly

jim goodman — Wed, 17 Aug 2011 19:35:42 GMT

Please do