I am relatively new to Sybase so I am trying to gather info
for a project to optimize performance for a ASA7 database. I
have
read ASA 7 database administration and sql user guide. But
the wizards I read have not been implemented in Version 7
like Index consultant and procedure profiling.
No one has any info as to why the server is so slow. Only
info that I have been provided with is that the server is
very slow.Crystal reports are being used to export data by
the user. Can something be done about that.

So, I tried using solutions mentioned in the guide as I
really don't have an idea as to where the problem is.
Regarding the cache size, all mincachesize,
maxcachesize, peakcachesize and currentcachesize are 1331200
KB and sysytem has 2 GB RAM.

No one can tell you what the problem is without looking at your
database... but we can take educated guesses...

The physical drive may be fragmented. Even more likely, the database
may be disorganized internally; the best solution method is to unload
the database, recreate and reload it. After that, defragment the drive
so the *.db file is contiguous.

Breck


On 7 Oct 2009 04:04:54 -0700, Deepali wrote:

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter (AT) risingroad (DOT) com

In article <4acc75d6.3ab7.1681692777 (AT) sybase (DOT) com>, Deepali says...
You don't mention if you're database-savvy and just not Sybase, or if
you're new to databases as well, so I'll assume the latter.

As general guidance, make sure the .db file is defragmented at the file
system level, and look at your queries to be sure you have indexes
available for the fields used in your ORDER BY and WHERE clauses.

If you can isolate exactly what it's slow at (inserting new data,
querying data out, etc), that will help a lot.

--
/~\ The ASCII
\ / Ribbon Campaign
X Against HTML
/ \ Email!

Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).

Thank You so much for replying..
How can I check if .db file is fragmented and how can I
defragment it.
Also, there are crystal reports running on the server and
crystal report software is not installed. Moreover there is
no support for Dolphin so no queries are available through
which I can check if they are slowing the performance of the
server.

Also, please tell me how I can unload and recreate the
database, and which precautionary steps should I follow to
achieve this.