Post reply

logspace

  • August 26, 2009 at 10:46 am

    #135075

    how to find out the how much logspace used and how much free?

  • August 26, 2009 at 10:53 am

    #1045013

    is it logfile ?

  • August 26, 2009 at 11:41 am

    #1045037

    SQL 2005 still supports the following three ways to report data and log space usage for a database:

    DBCC SQLPERF ( LOGSPACE ) can tell you the log size and used size.

    sp_spaceused for space used/reserved in data files, not for log files.

    Perfmon.exe to view the database size and log size:

    SQL Server: Databases Object

    Data File(s) Size (KB)

    Log File(s) Size (KB)

    Log File(s) Used Size (KB)

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • August 26, 2009 at 11:50 am

    #1045045

    thanks a lot.............

  • August 28, 2009 at 12:18 am

    #1046059

    You can also use standard report "Disk Usage". Which will also give you requried info.

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

Viewing 5 posts - 1 through 4 (of 4 total)

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