Post reply

DBCC SQLPERF(LOGSPACE)

  • February 28, 2005 at 3:14 am

    #88135

    Hello,

    When I run DBCC SQLPERF(LOGSPACE) i get an overview of space used by the transactionlog. I got an output of 9% space used for a sms database. After I shrunk the transactionlog, the physical log does not getting smaller

  • February 28, 2005 at 5:15 am

    #544384

    Hi Edward,

    I am assuming you are using DBCC SHRINKFILE?  Have you backed up the log since running the command?  I have found that log space is not freed up immediately.

    Check out this link....Gives a pretty detailed description of how log files work...!

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_1uzr.asp

  • March 1, 2005 at 6:08 am

    #544581

    Truncate log will not reduce the physical log size... it will mark all transaction which are not required for recovery as incative log...Once you issue dbcc shrinkfile command your log size will get reduce physically


    subban

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply