Post reply

database usage

  • June 6, 2002 at 11:43 am

    #173013

    Hi there, I wonder if there are some neat commands/method to check the database's usage, since it's so important.

    I know 'sp_spaceused', you can get the total size of database and how much is free. but it adds data file and log file's size together.What if I want to know how much data file has been used and how much log file is aten up, respectively?

  • June 6, 2002 at 3:05 pm

    #430468

    Check out the scripts library here and at www.planetsourcecode.com. You might also want to look at DBSS SQLPERF(LOGSPACE) and take a look at the output from

    use master

    go

    sp_helptext sp_spaceused

    or just open the text of sp_spaceused in EM and look at the code. This will help you understand how MS does it and allow you to build something for your own custom needs. Sorry I am a little vague here. Nothing in front of me and test server here at home is down right now.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

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

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