Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Problem with understand difference between sp_spaceused and sp_helpdb

Status
Not open for further replies.

byron1778

Programmer
Jul 20, 2007
4
AT
(Solaris 10 and ASE 12.5 )

Hello Forum,

I have a problem with understanding the difference between sp_spaceused and sp_helpdb.

When I do a sp_helpdb, I get the following inforamtion:

1> sp_helpdb xxx
2> go
name db_size owner dbid
created
status
------------------------ ------------- ------------------------ ------
--------------
-----------------------------------------------------------------------
xxx 6096.0 MB xxx 4
Jul 22, 2006
select into/bulkcopy/pllsort, trunc log on chkpt

(1 row affected)
device_fragments size usage
created free kbytes
------------------------------ ------------- --------------------
------------------- ----------------
xxx_data1 2048.0 MB data only
Jul 22 2006 8:32AM 2044
xxx_log1 1024.0 MB log only
Jul 22 2006 8:32AM not applicable
xxx_data1 1000.0 MB data only
Mar 8 2007 9:26AM 610
xxx_data1 1000.0 MB data only
May 16 2007 9:32AM 137146
xxx_data1 1024.0 MB data only
Jun 27 2007 12:04PM 942414

--------------------------------------------------------------
log only free kbytes = 1044478

There I can see, that I have 1.03 GB on free space.

But if I do a sp_spaceused, I get the following:

1> sp_spaceused
2> go
database_name database_size
------------------------------ -------------
xxx 6096.0 MB
reserved data index_size unused
--------------- --------------- --------------- ---------------
4092628 KB 470126 KB 3595206 KB 27296 KB

And there I can see that I have 6096 MB (database size)minus 3996 MB (reserved) = 2100 MB free for data.

So my question is, why do I get two different solutions?
Or have I understood something wrong?

How much free space do I have right now?

Thx for helping me!

Bernd
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top