Surf 11 » SQL Server Transaction Log Space Usage

Finding the best waves on the web.

Need to find out the amount of free space in your transaction log file on Microsoft SQL Server? Run the following command:

DBCC SQLPERF ( LOGSPACE )

It will tell you the percentage of transaction log space used, and the size of the transaction log file, which you then use to calculate the amount of free space in the transaction log or the amount of space in use.

The Result of the DBCC SQLPERF (LOGSPACE) query is the following columns Database Name, Log Size (MB), Log Space Used, Status. If there is a lot of FREE space in the transaction log, and you the file is too big you can shrink the size of the transaction log by running:

DBCC SHRINKFILE ( DBFILENAME_Log )


Related Entries
Name:

Email: (optional, not displayed on site)
   Subscribe to this thread
Comments: (html will be escaped)



Subscribe to our RSS Feed: subscribe to this feed XML
Archives   Tags   Contact