Large sqla0001.tmp file

[Former Member]

We are running Sybase Anywhere 11 and the sqla0001.tmp grows to about 200 GB in less than a week. How do I determine what is causing it to grow?

Thanks, Emma

[MarkCulp]

You likely have one or more queries that are materializing a large amount of data during their execution and this is causing your temp file to grow. You will need to find the query (or queries) that is the cause.

There is no easy way of finding "run-away" queries.

One method to try is to limit the amount of temp space allowed for each connection and then run your application and wait to see what fails.

To limit the amount of temp space used by a connection, you need to turn on the temp_space_limit_check option and then set the max_temp_space option to the upper limit of the amount of space to be used by a connection.

Example:

set option public.temp_space_limit_check = on;
set option public.max_temp_space = '100m';

The above will limit each connection to use a maximum of 100 MB.

See the 11.0.1 documentation for more information.