database usage

• crab7

  Mr or Mrs. 500

  Points: 548

  More actions

  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?

• Antares686

  SSC Guru

  Points: 125444

  More actions

  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)