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

asked 04 Jan '11, 19:08

Emma's gravatar image

Emma
1111
accept rate: 0%

edited 15 Mar '13, 18:41

Mark%20Culp's gravatar image

Mark Culp
23.0k9130270


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.

permanent link

answered 04 Jan '11, 19:42

Mark%20Culp's gravatar image

Mark Culp
23.0k9130270
accept rate: 40%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×137
×12

question asked: 04 Jan '11, 19:08

question was seen: 2,172 times

last updated: 15 Mar '13, 18:41