(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
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