Post reply

determine the total percentage log use for all the databases

  • January 5, 2006 at 4:46 pm

    #90427

    How can I determine the total percentage log use for all the databases

    DBCC SQLPREF(Logspace) give percentage of log for  individual databases on the server

    Is there is any sp or code to get the total.

  • January 6, 2006 at 3:11 am

    #613137

    Why do you want the total percentage ?

    It would be like the average of all the individual ones. And while this "total" could still be fine, individual database can run out of logspace.

    By the way if you'rereally interested in it, Performance monitor has a counter % logspace used and you can get the toal value for all databases.

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • January 6, 2006 at 3:42 am

    #613143

    USE

    master

    GO

    select

    'Select '''+name+''' ,name, size*8/1024

    from '

    +name+'..sysfiles where name like ''%Log%'' '

    from

    master..sysdatabases

    where

    dbid > 4

    order

    by name

    The above code generates one row statement for one database. Copy and execute all the statements. You will get DB Name, Log File Name and Log File Size in MB.

    Jagan

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

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