SQL Transaction Log Question

Real-time performance monitoring and troubleshooting

SQL Transaction Log Question

Veeam Logoby abradley » Tue Apr 19, 2011 5:41 pm

I am evaluating the Free edition of Veeam monitor and have it collecting data to a separate SQL 2005 server.
What we are seeing is a huge amount of Transaction Log traffic and it is consuming vast amounts of disk space.
The database is currently at 637MB but there are two LDF log files VeeamMonitor_log and VeeamMonitor_log2, we just ran a backup/truncate logs cause the transaction logs were at 20GB! Even now the _log file is 873MB and the _log2 file is 116MB (I believe these are the initial sizes after our truncate).

Is this normal for the database? I guess we are not sure why the log files would be growing at a large rate to where they would consume 20GB of space in about 4 weeks of running. Our setup has 4 vCenter Servers (50 guests) and another 4 ESXi servers (10 Guests).

Any thoughts on this?

Thanks,

Andy
abradley
Influencer
 
Posts: 12
Liked: never
Joined: Tue Apr 19, 2011 3:55 pm
Full Name: Andrew Bradley II

Re: SQL Transaction Log Question

Veeam Logoby Vitaliy S. » Tue Apr 19, 2011 9:04 pm

Hello Andy,

Yes, that's expected to have a growing transaction log due to current architecture. By default SQL transaction log is shrinked every 24 hours, however you can reduce this interval with the help of Veeam Monitor support utility.

Please contact our technical team to guide you through the steps required.

Thanks.
Vitaliy S.
Veeam Software
 
Posts: 19558
Liked: 1102 times
Joined: Mon Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov


Return to Monitoring



Who is online

Users browsing this forum: No registered users and 4 guests