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.

Okay, How Big Is It?

5 posts in Windows NT Last posting was on 2000-02-23 11:49:00.0Z
Kelly Rowe Posted on 2000-02-21 20:56:53.0Z
From: "Kelly Rowe" <krowe@globalcardservices.com>
Subject: Okay, How Big Is It?
Date: Mon, 21 Feb 2000 15:56:53 -0500
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <h4OOF4Kf$GA.215@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 208.30.1.69
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2526
Article PK: 1089981

sp_spaceused reports 12 megabytes of free space in my database. sp_helpdb
reports 1.7 gigabytes remaining on the last device. Shouldn't these guys
agree more closely?

Kelly Rowe
Senior Engineer - DBA
Global Card Services, Inc.


Andy Price Posted on 2000-02-22 11:56:41.0Z
From: "Andy Price" <andy.price@canada.com>
References: <h4OOF4Kf$GA.215@forums.sybase.com>
Subject: Re: Okay, How Big Is It?
Date: Tue, 22 Feb 2000 12:56:41 +0100
Lines: 25
Organization: MCL
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <WTRWFySf$GA.273@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 213.167.0.3
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2523
Article PK: 1089973

Kelly,

Can you paste the output of sp_spaceused and sp_helpdb here so that we can
have a look at them. Thanks.

--
Andy Price,
Sybase Certified Adaptive Server DBA v11.5
email: andy.price@canada.com

Kelly Rowe <krowe@globalcardservices.com> wrote in message
news:h4OOF4Kf$GA.215@forums.sybase.com...
> sp_spaceused reports 12 megabytes of free space in my database. sp_helpdb
> reports 1.7 gigabytes remaining on the last device. Shouldn't these guys
> agree more closely?
>
> Kelly Rowe
> Senior Engineer - DBA
> Global Card Services, Inc.
>
>


Kelly Rowe Posted on 2000-02-22 20:29:17.0Z
From: "Kelly Rowe" <krowe@globalcardservices.com>
References: <h4OOF4Kf$GA.215@forums.sybase.com> <WTRWFySf$GA.273@forums.sybase.com>
Subject: Re: Okay, How Big Is It?
Date: Tue, 22 Feb 2000 15:29:17 -0500
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <Ie80WNXf$GA.265@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 208.30.1.69
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2521
Article PK: 1089972

Output from sp_helpdb database1

device_fragments size usage free kbytes
database1_dat10 2045.0 MB data only 0
database1_dat11 2045.0 MB data only 0
database1_dat12 2045.0 MB data only 0
database1_dat14 2048.0 MB data only 0
database1_dat15 2045.0 MB data only 0
database1_dat16 2045.0 MB data only 0
database1_dat17 2048.0 MB data only 0
database1_dat18 2045.0 MB data only 0
database1_dat19 2045.0 MB data only 1296
database1_dat20 2045.0 MB data only 0
database1_dat21 2045.0 MB data only 0
database1_dat22 2048.0 MB data only 1766704
database1_dat3 2045.0 MB data only 0
database1_dat4 2045.0 MB data only 0
database1_dat5 1950.0 MB data only 0
database1_dat6 2045.0 MB data only 0
database1_dat7 2045.0 MB data only 0
database1_dat8 2048.0 MB data only 0
database1_dat9 2045.0 MB data only 0
database1_log1 2048.0 MB log only 2097152
database1_log2 2048.0 MB log only 2097120

Output from sp_spaceused

database1 44916.0 MB

reserved data index_size unused
37786534 KB 17630420 KB 20143930 KB 12216 KB



Andy Price <andy.price@canada.com> wrote in message
Kelly,

Can you paste the output of sp_spaceused and sp_helpdb here so that we can
have a look at them. Thanks.


Andy Price Posted on 2000-02-23 11:49:00.0Z
From: "Andy Price" <andy.price@canada.com>
References: <h4OOF4Kf$GA.215@forums.sybase.com> <WTRWFySf$GA.273@forums.sybase.com> <Ie80WNXf$GA.265@forums.sybase.com>
Subject: Re: Okay, How Big Is It?
Date: Wed, 23 Feb 2000 12:49:00 +0100
Lines: 75
Organization: Paris, France
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <P2F4gSff$GA.274@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 213.167.0.3
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2514
Article PK: 1089965

---- reposting as my original attempt did not happen!

Hi Kelly,

In your original mail you stated that sp_spaceused reported only 12mb free
and that the value didn't tally with the total from sp_helpdb. In
sp_spaceused that you've displayed here, the 'unused' value is not the
amount free in the database, but rather the amount in K of unused pages in
already allocated extents assigned to objects in the database. The
'reserved' value is the total of 'data', 'index_size' and 'unused'. So to
calculate the amount free you deduct 'reserved' from the database size it
returns. In your case, it is:

44916.0 MB - (37786534 KB / 1024) = 8015mb

The values returned by sp_spaceused are estimates and are dependent on
up-to-date statistics being available (ie, after update stats or a dbcc
commands), but provides a good fast method of guesstimating current sizes.
Use this for looking at your database space allocations.


--
Andy Price,
Sybase Certified Adaptive Server DBA v11.5
email: andy.price@canada.com

Kelly Rowe <krowe@globalcardservices.com> wrote in message
news:Ie80WNXf$GA.265@forums.sybase.com...
> Output from sp_helpdb database1
>
> device_fragments size usage free kbytes
> database1_dat10 2045.0 MB data only 0
> database1_dat11 2045.0 MB data only 0
> database1_dat12 2045.0 MB data only 0
> database1_dat14 2048.0 MB data only 0
> database1_dat15 2045.0 MB data only 0
> database1_dat16 2045.0 MB data only 0
> database1_dat17 2048.0 MB data only 0
> database1_dat18 2045.0 MB data only 0
> database1_dat19 2045.0 MB data only 1296
> database1_dat20 2045.0 MB data only 0
> database1_dat21 2045.0 MB data only 0
> database1_dat22 2048.0 MB data only 1766704
> database1_dat3 2045.0 MB data only 0
> database1_dat4 2045.0 MB data only 0
> database1_dat5 1950.0 MB data only 0
> database1_dat6 2045.0 MB data only 0
> database1_dat7 2045.0 MB data only 0
> database1_dat8 2048.0 MB data only 0
> database1_dat9 2045.0 MB data only 0
> database1_log1 2048.0 MB log only 2097152
> database1_log2 2048.0 MB log only 2097120
>
> Output from sp_spaceused
>
> database1 44916.0 MB
>
> reserved data index_size unused
> 37786534 KB 17630420 KB 20143930 KB 12216 KB
>
>
>
> Andy Price <andy.price@canada.com> wrote in message
> Kelly,
>
> Can you paste the output of sp_spaceused and sp_helpdb here so that we
can
> have a look at them. Thanks.
>
>
>


Andy Price Posted on 2000-02-23 10:18:40.0Z
From: "Andy Price" <andy.price@canada.com>
References: <h4OOF4Kf$GA.215@forums.sybase.com> <WTRWFySf$GA.273@forums.sybase.com> <Ie80WNXf$GA.265@forums.sybase.com>
Subject: Re: Okay, How Big Is It?
Date: Wed, 23 Feb 2000 11:18:40 +0100
Lines: 73
Organization: MCL
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <OJmTvgef$GA.251@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 213.167.0.3
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2515
Article PK: 1089968

Hi Kelly,

In your original mail you stated that sp_spaceused reported only 12mb free
and that the value didn't tally with the total from sp_helpdb. In
sp_spaceused that you've displayed here, the 'unused' value is not the
amount free in the database, but rather the amount in K of unused pages in
already allocated extents assigned to objects in the database. The
'reserved' value is the total of 'data', 'index_size' and 'unused'. So to
calculate the amount free you deduct 'reserved' from the database size it
returns. In your case, it is:

44916.0 MB - (37786534 KB / 1024) = 8015mb

The values returned by sp_spaceused are estimates and are dependent on
up-to-date statistics being available (ie, after update stats or a dbcc
commands), but provides a good fast method of guesstimating current sizes.
Use this for looking at your database space allocations.

--
Andy Price,
Sybase Certified Adaptive Server DBA v11.5
email: andy.price@canada.com

Kelly Rowe <krowe@globalcardservices.com> wrote in message
news:Ie80WNXf$GA.265@forums.sybase.com...
> Output from sp_helpdb database1
>
> device_fragments size usage free kbytes
> database1_dat10 2045.0 MB data only 0
> database1_dat11 2045.0 MB data only 0
> database1_dat12 2045.0 MB data only 0
> database1_dat14 2048.0 MB data only 0
> database1_dat15 2045.0 MB data only 0
> database1_dat16 2045.0 MB data only 0
> database1_dat17 2048.0 MB data only 0
> database1_dat18 2045.0 MB data only 0
> database1_dat19 2045.0 MB data only 1296
> database1_dat20 2045.0 MB data only 0
> database1_dat21 2045.0 MB data only 0
> database1_dat22 2048.0 MB data only 1766704
> database1_dat3 2045.0 MB data only 0
> database1_dat4 2045.0 MB data only 0
> database1_dat5 1950.0 MB data only 0
> database1_dat6 2045.0 MB data only 0
> database1_dat7 2045.0 MB data only 0
> database1_dat8 2048.0 MB data only 0
> database1_dat9 2045.0 MB data only 0
> database1_log1 2048.0 MB log only 2097152
> database1_log2 2048.0 MB log only 2097120
>
> Output from sp_spaceused
>
> database1 44916.0 MB
>
> reserved data index_size unused
> 37786534 KB 17630420 KB 20143930 KB 12216 KB
>
>
>
> Andy Price <andy.price@canada.com> wrote in message
> Kelly,
>
> Can you paste the output of sp_spaceused and sp_helpdb here so that we
can
> have a look at them. Thanks.
>
>
>