Post reply

ReportServerTempDB - simple mode, huge log file, open tran

  • February 8, 2012 at 11:08 am

    #251168

    dbcc sqlperf(logspace)

    Name , Log Size , Log Space Used , Status , Space on Disk

    ReportServerTempDB , 16 GB, 91 % , 0 , 20 GB

    sys.databases

    name , compatibility_level , recovery_model_desc , log_reuse_wait , log_reuse_wait_desc

    ReportServerTempDB , 100 , SIMPLE , 4 , ACTIVE_TRANSACTION

    dbcc opentran

    SPID , UID , Name , StartTime

    111 , -1 , user_transaction , Feb 6 2012 8 AM

    dbcc inputbuffer (111)

    EventType , Parameters , EventInfo

    RPC Event , 0 , ReportServer.dbo.WriteLockSession;1

    how to free up space in log file?

    - kill the open tran (but don't know what tran does)

    - manual checkpoint (but don't know how much space it'll free up)

    - shrink log (but there's not much free space)

    ?

  • February 8, 2012 at 11:09 am

    #1444682

    Kill the open transaction or wait for it to complete. Nothing else will have any impact on the log while there is an open transaction.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • February 8, 2012 at 1:34 pm

    #1444763

    killed the tran.

    that should have caused a checkpoint - log file space used dropped.

    then shrank it.

    all good.

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

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