Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Monitoring, Transaction Logs Rss

   Items 1 to 2 of 2   
 

Stairway to Transaction Log Management in SQL Server, Level 9: Monitoring the Transaction Log

Our major goal in terms of log maintenance for all databases under our care is to optimize for write performance, in order to support all activities that require SQL Server to write to the log, including data modifications, data loads, index rebuilds, and so on. However, it's also important to keep an eye on possible log fragmentation, which, as described previously, can affect the performance of processes that need to read the log, such as log backups and the crash recovery process.  Read more...
By Tony Davis 2013/04/24 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,993 reads

Transcation Log space monitoring

This SP will monitor T-Log space and sends mail to DBA if log space usage is above threshold value  Read more...
By Vinayaka Gangadhar 2010/10/05 | Source: SQLServerCentral.com | Category: transaction logs
Rating: |  Discuss |   Briefcase | 3,323 reads
   Items 1 to 2 of 2   
 
Tags
space usage (1)    
stairway series (1)