0

Can you help me to understand what consumes the 149MB difference between the figures calculated on screenshot. The sizes are produced by SP sp_spaceused

result of sp_spaceused call

1 Answer 1

2

The first result of sp_spaceused gives you the total size of the data and log files. The second result is just the data used; Reserved is data+index+unused.

In your example, the total size of the data and transaction log files will be 300MB.

    SELECT name,
       type,
       ROUND((size * 8.0) / 1024, 2)
    FROM sys.database_files;
3
  • It matches with the figures I see in DB, thanks. Wondering why log file grows despite DB being in simple recovery mode.
    – Tomek
    Commented Nov 4, 2022 at 19:04
  • 2
    @Tomek, even in simple recover, the log needs to be big enough to accommodate the largest transaction.
    – Dan Guzman
    Commented Nov 4, 2022 at 20:35
  • 1
    To expand on Dan's comment, this is to account for an active transaction that may rollback. Simple Recovery Model just means the Transaction Log is immediately marked for re-use (without the need for backing it up) by other transactions.
    – J.D.
    Commented Nov 4, 2022 at 21:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.