Post reply

Please help analyzing MS SQL Database Logfile(s)

  • September 2, 2011 at 8:41 am

    #1376473

    Thank you very much for everything I saw it

  • September 2, 2011 at 9:18 am

    #1376504

    you can use dmv

    sys.dm_db_log_space_usage will give the log file usgae.you will be getting similar information when you retrive the data using DBCC SQLPERF('logspace').However this dbcc command will give you output for all the databases where this DMV will give you output for the sprcific database

  • September 2, 2011 at 9:20 am

    #1376507

    Subjective Adapts (9/2/2011)

    sys.dm_db_log_space_usage will give the log file usgae.you will be getting similar information when you retrive the data using DBCC SQLPERF('logspace').However this dbcc command will give you output for all the databases where this DMV will give you output for the sprcific database

    What does that have to do with finding out who dropped a table?

    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

  • September 2, 2011 at 11:04 am

    #1376576

    GilaMonster (9/2/2011)

    Subjective Adapts (9/2/2011)

    sys.dm_db_log_space_usage will give the log file usgae.you will be getting similar information when you retrive the data using DBCC SQLPERF('logspace').However this dbcc command will give you output for all the databases where this DMV will give you output for the sprcific database

    What does that have to do with finding out who dropped a table?

    I was about to ask the same, I think he got confused! 😀



    My blog

Viewing 4 posts - 16 through 18 (of 18 total)

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