Qual o tamanho da Transaction Log?

 

Podemos observar o tamanho do Transaction Log, em MB, e o quando, em percentual, está sendo utilizado do Transaction Log com o seguinte comando:

DBCC SQLPERF (LOGSPACE)

Exemplo do retorno:

Warnings: --->
  W (1): DBCC execution completed. If DBCC printed error messages, contact your system administrator.
         <---
Database Name                  Log Size (MB)     Log Space Used (%)     Status   
----------------------          ----------------      ---------------------      ---------
master                                    2,9921875         31,723237991333008     0        
tempdb                                1363,0546875      21,62744903564453      0        
msdb                                     42,9921875        16,172996520996094     0        
  

3 record(s) selected [Fetch MetaData: 15/ms] [Fetch Data: 47/ms]

[Executed: 13/08/12 10h32min44s BRT ] [Execution: 110/ms]

 

[]s