How can we identify used space in log file?

Many times we face this question in the interview “How can we identify used space in log file”.

 Using following DBCC command you can identify the used space in the log file.


DBCC SQLPERF('LOGSPACE')



Result:















You can see in result first column display DB name and second columns display total log file size in MB while the third column contains used size in MB which is our answer.

No comments:

Post a Comment

PostgreSQL-Query: Sort result set by specific field values using ORDER BY Clause

Problem: Suppose we have a book_inventory table which has some columns such as id, isbn, title, author, publisher, publish_date, etc.. whe...