Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Transactin Log Issue Expand / Collapse
Author
Message
Posted Monday, April 22, 2013 12:09 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:28 PM
Points: 182, Visits: 650
Thanks once again.
I have changed log backup frequency to every hour and

I was looking log backup size on my backup drive and it shows for each hour after changing:

8 AM 7013 KB
9 AM 24897 KB
10 AM 45385 KB
11 AM 43220 KB
12 PM 419318 KB

I have just checked - select name,log_reuse_wait_desc from sys.databases and log_reuse_wait_desc shows Log_backup and also checking to VLfs, total files around 490 and 33 files with status = 2.

Also ran, DBCC SQLPERF(LogSpace):

Log Size (MB) Log Space Used (%) Status
14198.8 0.1719995 0
Post #1445102
Posted Monday, April 22, 2013 12:18 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 21, 2014 3:28 PM
Points: 182, Visits: 650
Thanks George, I have changed the Log Backup Frequency to one hour.

I ran again DBCC SQLPERF(LogSpace) and it shows around 14 GB but I was looking Backup Log on my backup drive it also shows.


see the result:
Log Size (MB) Log Space Used (%) Status

14198.8 2.486978 0

I have just checked - select name,log_reuse_wait_desc from sys.databases and log_reuse_wait_desc shows Log_backup and also checking to VLfs, total files around 490 and 33 files with status = 2.
I have changed T-log backup frequency to every one hour, now backup log size is every hour is:
8 AM 7013 KB
9 AM 24897 KB
10 AM 45385 KB
11 AM 43220 KB
12 PM 419318 KB


Thanks





Post #1445106
Posted Monday, April 22, 2013 2:19 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 11:08 AM
Points: 5,975, Visits: 12,878
those are very small backups . Track it for at least a week and see if you get any huge log backups, these usually occur when re-indexing is done.

---------------------------------------------------------------------

Post #1445166
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse