June 6, 2002 at 11:43 am
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
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