Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

db /object size ?

2 posts in Performance and Tuning Last posting was on 2012-10-26 17:28:40.0Z
Isabella Posted on 2012-10-26 16:12:13.0Z
From: Isabella <isabella.ghiurea@nrc-cnrc.gc.ca>
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:15.0) Gecko/20120911 Thunderbird/15.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.performance+tuning
Subject: db /object size ?
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <508ab65d$1@forums-1-dub>
Date: 26 Oct 2012 09:12:13 -0700
X-Trace: forums-1-dub 1351267933 172.20.134.152 (26 Oct 2012 09:12:13 -0700)
X-Original-Trace: 26 Oct 2012 09:12:13 -0700, vip152.sybase.com
Lines: 117
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:13279
Article PK: 91770

Hi ,
I'm running ASE 15.5 , have a db in size aprox 45GB with only 5 GB
unallocate/unused, are only 3 tables ; 2 tables in size < 1gb whit
indexes and data, other table has 12Gb with data and index as per most
recent sp_spaceused output, this table has 3 compute columns with
property virtual and one text column with 16 bytes lenght see DDL
bellow. I would like to know where is the rest of gb's from db's been
allocated/used for ?
sp_help table1
Column_name Type Length Prec Scale Nulls Default_name
Rule_name Access_Rule_name Computed_Column_object Identity
--------------- --------- ------ ---- ----- -----
---------------------- --------- ----------------
------------------------------- ----------
nodeID bigint 8 NULL NULL 0 NULL
NULL NULL NULL 1
parentID bigint 8 NULL NULL 1 NULL
NULL NULL NULL 0
name varchar 276 NULL NULL 0 NULL
NULL NULL NULL 0
type char 1 NULL NULL 0 NULL
NULL NULL NULL 0
busyState char 1 NULL NULL 0 NULL
NULL NULL NULL 0
groupRead varchar 256 NULL NULL 1 NULL
NULL NULL NULL 0
groupWrite varchar 256 NULL NULL 1 NULL
NULL NULL NULL 0
isPublic bit 1 NULL NULL 0 NULL
NULL NULL NULL 0
delta bigint 8 NULL NULL 1 NULL
NULL NULL NULL 0
contentType varchar 100 NULL NULL 1 NULL
NULL NULL NULL 0
contentEncoding varchar 50 NULL NULL 1 NULL
NULL NULL NULL 0
contentMD5_old binary 16 NULL NULL 1 NULL
NULL NULL NULL 0
createdOn datetime 8 NULL NULL 0
Node_create_1712006099 NULL NULL NULL
0
lastModified datetime 8 NULL NULL 0 NULL
NULL NULL NULL 0
ownerID int 4 NULL NULL 1 NULL
NULL NULL NULL 0
creatorID int 4 NULL NULL 1 NULL
NULL NULL NULL 0
contentLength bigint 8 NULL NULL 1 NULL
NULL NULL Node_conten_316525130 (virtual) 0
contentMD5 varbinary 16 NULL NULL 1 NULL
NULL NULL Node_conten_332525187 (virtual) 0
link text 16 NULL NULL 1 NULL
NULL NULL NULL 0
nodeSize bigint 8 NULL NULL 1 NULL
NULL NULL NULL 0

Object has the following computed columns


Column_Name Property
------------- -------------
contentLength virtual


Text


----------------------------------------------------------------------------------------------------------------
AS
case when type='D' then vospace.dbo.getContentLength('VOSpac',
convert(varchar,nodeID), NULL) else NULL end


Column_Name Property
------------- -------------
contentMD5 virtual


Text


--------------------------------------------------------------------------------------------------------------
AS
case when type='D' then vospace.dbo.getContentMD5('VOSpac',
convert(varchar,nodeID), NULL) else NULL end


Object has the following indexes


index_name index_keys index_description
index_max_rows_per_page index_fillfactor index_reservepagegap
index_created index_local
------------------------ --------------- --------------------
----------------------- ---------------- --------------------
------------------- ------------
Node_parentID_name_index parentID, name clustered, unique
0 0 0 Apr 25 2012
1:38PM Global Index
Node_pk nodeID nonclustered, unique
0 0 0 Apr 25 2012
1:38PM Global Index
Node_busyState_index busyState nonclustered
0 0 0 Apr 25 2012
1:38PM Global Index
Node_delta_index delta nonclustered
0 0 0 Sep 25 2012
11:02AM Global Index

(4 rows affected)
index_ptn_name index_ptn_seg
----------------------------------- -------------
Node_parentID_name_index_1696006042 default
Node_pk_1696006042 default
Node_busyState_index_1696006042 default
Node_delta_index_1696006042 default
No defined keys for this object.


Bret Halford Posted on 2012-10-26 17:28:40.0Z
From: Bret Halford <bret.halford@sap.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:16.0) Gecko/20121010 Thunderbird/16.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.performance+tuning
Subject: Re: db /object size ?
References: <508ab65d$1@forums-1-dub>
In-Reply-To: <508ab65d$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <508ac848$1@forums-1-dub>
Date: 26 Oct 2012 10:28:40 -0700
X-Trace: forums-1-dub 1351272520 172.20.134.152 (26 Oct 2012 10:28:40 -0700)
X-Original-Trace: 26 Oct 2012 10:28:40 -0700, vip152.sybase.com
Lines: 24
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.performance+tuning:13280
Article PK: 91771


On 10/26/2012 10:12 AM, Isabella wrote:
> Hi ,
> I'm running ASE 15.5 , have a db in size aprox 45GB with only 5 GB
> unallocate/unused, are only 3 tables ; 2 tables in size < 1gb whit
> indexes and data, other table has 12Gb with data and index as per most
> recent sp_spaceused output, this table has 3 compute columns with
> property virtual and one text column with 16 bytes lenght see DDL
> bellow. I would like to know where is the rest of gb's from db's been
> allocated/used for ?

Hi Isabella,

As a starting point, where are you getting the 45gb/5gb unused figures
from? Please post command and output.
It would also be good to see output of sp_spaceused <tablename>, 1 for
each of the 3 user tables.

Is the log getting truncated regularly? sp_spaceused syslogs

Does dbcc checkstorage report any allocation faults?

Cheers,
-bret