Real-time performance monitoring and troubleshooting
Post Reply
abradley
Influencer
Posts: 12
Liked: never
Joined: Apr 19, 2011 3:55 pm
Full Name: Andrew Bradley II
Contact:

SQL Transaction Log Question

Post by abradley »

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
Vitaliy S.
VP, Product Management
Posts: 27377
Liked: 2800 times
Joined: Mar 30, 2009 9:13 am
Full Name: Vitaliy Safarov
Contact:

Re: SQL Transaction Log Question

Post by Vitaliy S. »

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.
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests