Disk size

Hi all,

Using SQL Anywhere 11

How can i extract the disksize occupied for each table
please? Our database is growing extremely fast and we want
to find out which table is "responsable" for what amount of
disk size.

TIA

John
0
John
1/13/2011 12:37:03 PM
sybase.sqlanywhere.general 32637 articles. 4 followers. Follow

3 Replies
607 Views

Similar Articles

[PageSpeed] 8

You can use the sa_table_page_usage system procedure (or the dbinfo 
utility). Both require that you are connected as DBA and that there are 
no other current connections (so when you database is is continuous use, 
you may run these queries against a copy of the database). And both will 
take some time...

E.g., with
    select * from sy_table_page_usage() order by PctOfFile desc
you'll get a list of the tables ordered by the disk space they need 
starting with the hugest one.

Cf. 
http://dcx.sybase.com/index.html#1101en/dbreference_en11/sa-table-page-usage-sysproc.html.


I would also have a look at "table fragmentation", cf.
http://dcx.sybase.com/index.html#1101en/dbusage_en11/detecting-table-frag.html.

HTH
Volker





John wrote:
> Hi all,
>
> Using SQL Anywhere 11
>
> How can i extract the disksize occupied for each table
> please? Our database is growing extremely fast and we want
> to find out which table is "responsable" for what amount of
> disk size.
>
> TIA
>
> John
0
Volker
1/13/2011 1:01:25 PM
Another way is the "Table Page Usage" tab you see in Sybase Central 6.0 
when you click on the database symbol (same restriction as noted by Volker).

Cheers
Reimer

Volker Barth wrote:
> You can use the sa_table_page_usage system procedure (or the dbinfo
> utility). Both require that you are connected as DBA and that there are
> no other current connections (so when you database is is continuous use,
> you may run these queries against a copy of the database). And both will
> take some time...
>
> E.g., with
> select * from sy_table_page_usage() order by PctOfFile desc
> you'll get a list of the tables ordered by the disk space they need
> starting with the hugest one.
>
> Cf.
> http://dcx.sybase.com/index.html#1101en/dbreference_en11/sa-table-page-usage-sysproc.html.
>
>
>
> I would also have a look at "table fragmentation", cf.
> http://dcx.sybase.com/index.html#1101en/dbusage_en11/detecting-table-frag.html.
>
>
> HTH
> Volker
>
>
>
>
>
> John wrote:
>> Hi all,
>>
>> Using SQL Anywhere 11
>>
>> How can i extract the disksize occupied for each table
>> please? Our database is growing extremely fast and we want
>> to find out which table is "responsable" for what amount of
>> disk size.
>>
>> TIA
>>
>> John

0
R
1/13/2011 1:21:18 PM
Foxhound's "schema display" component displays all sorts of
table-related "curiosities" including a breakdown of disk usage for
table data, extension pages and indexes:
http://www.risingroad.com/foxhound/index.html

On 13 Jan 2011 04:37:03 -0800, John wrote:

>Hi all,
>
>Using SQL Anywhere 11
>
>How can i extract the disksize occupied for each table
>please? Our database is growing extremely fast and we want
>to find out which table is "responsable" for what amount of
>disk size.
>
>TIA
>
>John

--
Breck Carter

Visit SQLA! ...the new SQL Anywhere online community
   http://sqla.stackexchange.com

Blog: http://sqlanywhere.blogspot.com/

RisingRoad helps SQL Anywhere developers make better databases...
   http://www.risingroad.com/

Breck.Carter at gmail
0
Breck
1/15/2011 1:38:18 PM
Reply:

Similar Artilces:

Size on Disk
When you check the disk space in Windows explorer and you go to a specific folder, you see Size and also Size on Disk. What is the difference? VK, Size On Disk is a miscalculated number provided by Windows. Explorer is assuming a 64KB block size for the files, and doesn't understand sub-allocation at all. Its working on the assumption that a 1KB file for example, will take up 64KB on disk. Size is the total of the file sizes, also provided by Windows. The actual size on disk may be smaller as files can be compressed, and Explorer isn't taking sub block alloc...

What generals generally do
Reading a McChrystal thread elsewhere, I came across someone quoting a US general http://en.wikipedia.org/wiki/Smedley_Butler > I spent 33 years and four months in active military service and > during that period I spent most of my time as a high class thug for > Big Business, for Wall Street and the bankers. In short, I was a > racketeer, a gangster for capitalism. I helped make Mexico and > especially Tampico safe for American oil interests in 1914. I helped > make Haiti and Cuba a decent place for the National City Bank boys to > collect revenues in. I ...

external usb disk shows disk, disk-1, disk-2, disk-3, disk-4
Hello all, I am new to linux. I am running openSUSE 11.1 (i586) and I have a maxtor external usb drive attached. I used the backup utility in suse to create a backup job that would copy files to my external hard drive. The problem is that when I disconnect the usb drive or reboot the machine sometimes the drive shows up as a different name. e.g. It first showed up as disk, then disk-1, then disk-2, then disk-3, and now disk-4. This is a problem because the backup utility doesn't know that the drive name changed. I had to update the back-up software to say to write to dr...

superreview granted: [Bug 175600] Only 8192 objects can be stored in disk cache. : [Attachment 208963] One line patch to increase max. disk cache size (in number of entries)
Christian :Biesinger <cbiesinger@gmail.com> has granted Steve Chapel <steve.chapel@a2pg.com>'s request for superreview: Bug 175600: Only 8192 objects can be stored in disk cache. https://bugzilla.mozilla.org/show_bug.cgi?id=175600 Attachment 208963: One line patch to increase max. disk cache size (in number of entries) https://bugzilla.mozilla.org/attachment.cgi?id=208963&action=edit ...

superreview requested: [Bug 175600] Only 8192 objects can be stored in disk cache. : [Attachment 208963] One line patch to increase max. disk cache size (in number of entries)
Steve Chapel <steve.chapel@a2pg.com> has asked Christian :Biesinger <cbiesinger@gmail.com> for superreview: Bug 175600: Only 8192 objects can be stored in disk cache. https://bugzilla.mozilla.org/show_bug.cgi?id=175600 Attachment 208963: One line patch to increase max. disk cache size (in number of entries) https://bugzilla.mozilla.org/attachment.cgi?id=208963&action=edit ...

Expanding disk size
Can I expand my home partition size using Gparted or any other tool? My 10 GB partition for opensuse is almost full. I have another 10 GB ext3 partition which is not used. Can I merge this partition with my home partition? -- sarin_cv ------------------------------------------------------------------------ Yes. or maybe No But you better post Code: -------------------- fdisk -l -------------------- just so we can check your setup. It will depend on your partition layout. If it is possible, you will have to edit /etc/fstab too. Lets see what you have firs...

Physical disk size
A have a usb stick that a want to copy bit by bit. I dont ave problems with copy but I cant get size correct. I have tryed WMI, DeviceIO, TFileStream size, GetFileSize api, TPGHugeFile. Usb stick is 1gb, (985 mb) but i can only see 980. When I copy until it get read error it copies 985 mb correct. But I need to list the disk in a list with correct size. Thanks. BB wrote: > I have tryed WMI, DeviceIO What EXACTLY have you tried with them? Can you show that code? Haave you tried GetDiskFreeSpace/Ex()? -- Remy Lebeau (TeamB) In article <548265@forums.embarcadero.com&...

Raw Disk sizes
We are currently refreshing hardware on a Sun E10000 platform. The database is running at ASE11.9.2, is about 60 Gig in size, running on 30+ 2Gig raw partitions. As all the partitions are located physically on an external EMC disk array, is there any real benfit to keeping the raw partition at 2gig ? Are we better off keeping the Administration down to a minimum and setting up larger partition sizes ? Solaris level is currently 2.5.1 but is being upgraded to Solaris 8 (32 bit). Migration will be to the new platform. Thanks Owen Owen, If the devices are raw then y...

Size of Disk Devices
Hello all: We are currently using Sybase 11.03.3 on HPUX 10.20. Our current physical disks are 4Gig in size, but due to limitations with previous versions of Sybase, I was forced to define two 2 Gig sybase devices for each 4 Gig physical device. Now with 11.03.3 I could define these phyical devices as 4 Gig devices to Sybase. My question is, will I see any performance increase / decrease in doing this, or should I just leave things well enough alone? Thanks Brian Funston Lipper Analytical Brian Funston wrote: > > Hello all: > > We are c...

volume disk size
Hi Just taught I post and experience I recently had with my oes netware 6.5 sp8 servers - nss pool of 324 GB with one volume. - the volume had access to all the pool data, so 324 GB - doing the math of the folders in the volume it added up to 80 GB - netware reported 324 GB of space being used - where was the 244 GB being used? - volume would grow by 300MB daily by itself nss /poolrebuild with purge option, nothing change - finally a SR was place with Novell - they could not find a solution apart from telling me to delete my pool and start over, sort of drastic - anyway e...

Sqlanywhere.general missing?
I have not been able to get to the sqlanywhere.general news group in a couple of weeks now. Has something changed? The newsgroups have moved to a new server. You will need to reset your news. -- Joshua Savill , SYBASE iAnywhere Solutions - Technical Support "James L. Blackburn" <jamesb@round2consulting.com> wrote in message news:il739v4jhptn8f7knlko9h5bk2pcjm9l08@4ax.com... > I have not been able to get to the sqlanywhere.general news group in a > couple of weeks now. Has something changed? > > Same name, different IP address. It co...

SQLAnywhere Database Size
I am curious to know what the theoretical/functional limits for remote database sizes. Do these things break/corrupt....if so what's typically the cause...what are the symptoms? We have databases ranging in size from 90 MB to 450 Mb on local field machines. My experience with local databases (different tool) of this size is not a pleasant one. If you have any suggestions or thoughts I'd appreciate it. On Tue, 27 Jul 1999 14:38:39 -0500, "Tycho Ferrigni" <Tycho.R.Ferrigni@Monsanto.com> wrote: >I am curious to know what the theoretical/funct...

SQLAnywhere runtime size
What is the minimum size of the runtime engine that would have to be loaded to support a standalone desktop app and what is the zipped size? The minimum number of files need to delpoy can be found in the manual at ASA User's Guide PART 5. Database Administration and Advanced Use CHAPTER 28. Deploying Databases and Applications Deploying database servers So, the minumum files needed for the runtime engine are : rteng7.exe - 41 KB dbserv7.dll - 2,452 KB dblgen7.dll - 357 KB dbctrs7.dll - 33 KB This zips up to 1,288 KB. You will probably need another DLL ...