The DB creates .tmp file that grows and slows down the DB

[jaelee]

when starting the db, it creates atap0000.tmp file that
grows and slows down the db.
sybase central and the server has to be shut down and reset
in order to clear the file. after resetting, db works fine
again, but have to do it every once in a while.
is resetting the server only way to purge this file?

[Unknown]

I am assuming you meant the file name was

asat0000.tmp

And while I am questioning the initial report, ...

How big does it grow to?
and
What version are you running?

A large temp file is a result of not having enough cache
for your immediate (momentary) needs and so the temp
file is a side-effect of running with a slow configuration.

You will want to familiarize yourself with this section
in the documenation

ASA SQL User's Guide (V9.0.2)
Monitoring and Improving Performance
Top performance tips
Increase the cache size

The other half of this equation is finding out why is the
demand so heavy. Lots of connections and/or heavy
usage may contribute to this but ....

If you are using lots of temp or global temp tables, queries
that need to do unions or sorts, and an undersized cache
all have an impact on the temporary file size. To investigate
those resorting to tracing, profiling and performance monitoring
is the next thing to consider (if you find that increasing the
cache size a lot does not help as much as hoped for).

<Jae Lee> wrote in message news:48e62dcf.75b...@sybase.com...