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.

Performance warning: Database File consist of disk fragment.

2 posts in General Discussion Last posting was on 2006-05-26 06:31:08.0Z
Fenix Posted on 2006-05-26 04:05:48.0Z
From: "Fenix" <sales@bbccable.com>
Newsgroups: ianywhere.public.general
Subject: Performance warning: Database File consist of disk fragment.
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: mail.bbccable.com
X-Original-NNTP-Posting-Host: mail.bbccable.com
Message-ID: <44767e9c@forums-1-dub>
Date: 25 May 2006 21:05:48 -0700
X-Trace: forums-1-dub 1148616348 210.177.103.253 (25 May 2006 21:05:48 -0700)
X-Original-Trace: 25 May 2006 21:05:48 -0700, mail.bbccable.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5393
Article PK: 1443

Hello, everybody.

I use 3 hard disk to create a RAID 5 Storage array, and install win 2000
server with sp 4 to create a new system. After I install sybase 9.0 in that,
I unload a database from sybase 5.5 and reload it into new 9.0 database. It
success the unload/reload action. And then I run dbeng90 and ISQL to take a
look in the database, also successfully open the ISQL.

But I am worry about a performance warning shows in dbeng90 :

Performance warning: Database file "C:\new_db\db9\bbc.db" consists of 1903
disk fragments.

So I want to know what it means and how to solve the performance problem?

Thank you.


Greg Fenton Posted on 2006-05-26 06:31:08.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Thunderbird 1.5.0.2 (Windows/20060308)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: Performance warning: Database File consist of disk fragment.
References: <44767e9c@forums-1-dub>
In-Reply-To: <44767e9c@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Message-ID: <4476a03e@forums-2-dub>
X-Original-Trace: 25 May 2006 23:29:18 -0700, cpe00096b10fe8a-cm000f212f9e50.cpe.net.cable.rogers.com
Lines: 29
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 25 May 2006 23:29:19 -0800, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 25 May 2006 23:31:08 -0700
X-Trace: forums-1-dub 1148625068 10.22.108.75 (25 May 2006 23:31:08 -0700)
X-Original-Trace: 25 May 2006 23:31:08 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:5394
Article PK: 1444


Fenix wrote:
>
> Performance warning: Database file "C:\new_db\db9\bbc.db" consists of 1903
> disk fragments.
>

This means that the database file is fragmented across the disk and the
engine is warning you that there may be a performance penalty because of
this.

A couple of points:
- the fact that you are using a RAID may mean this is a moot warning
- RAID 1+0 is typically the better choice for a database server from
a performance standpoint
- when you go to reload a database, it is recommended that you
pre-allocate the disk space for the .db file to a size close to what
you expect your .db file to grow to (see ALTER DBSPACE GROW ...)
- you might consider defragmenting your file system after the database
has grown considerably (DiskDefrag, Disk Keeper, a tool from
sysinternals.com, etc...)

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/