|
Home > Archive > SQL Anywhere database > April 2005 > SQL Remote and TEMPDB
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Remote and TEMPDB
|
|
|
| ASA 8.0.3 Build 5191
Hi:
How do I increase the size of TEMPDB? I've looked everywhere, but
cannot find out how to do it.
We are using SQL Remote and in the documentation it states the following:
Ensuring TEMPDB is large enough
--------------------------------------------------------------------------------
SQL Remote uses the TEMPDB database for the following purposes:
a.. The database extraction utility used to create remote databases uses
TEMPDB to hold a temporary set of Adaptive Server Anywhere system tables.
b.. The Message Agent creates a temporary table called #remote when it
connects to the server.
For these reasons, you should make TEMPDB larger than the 2 Mb default size.
The size required depends on the number of tables and columns in your SQL
Remote installation, but a size of 10 Mb is generally sufficient.
--
Thanks,
Jeff
| |
| Nick Elson 2005-04-25, 8:24 pm |
| TEMPDB is a feature of ASE, as such you should post
on one of the Adaptive Server Enterprise newsgroups
or contact technical support.
"Jeff" <jsnow@propertyboss.com> wrote in message
news:426d4c44$1@foru
ms-1-dub...
> ASA 8.0.3 Build 5191
>
> Hi:
>
> How do I increase the size of TEMPDB? I've looked everywhere, but
> cannot find out how to do it.
>
> We are using SQL Remote and in the documentation it states the
> following:
>
>
> Ensuring TEMPDB is large enough
>
> --------------------------------------------------------------------------------
>
> SQL Remote uses the TEMPDB database for the following purposes:
>
> a.. The database extraction utility used to create remote databases uses
> TEMPDB to hold a temporary set of Adaptive Server Anywhere system tables.
>
> b.. The Message Agent creates a temporary table called #remote when it
> connects to the server.
>
> For these reasons, you should make TEMPDB larger than the 2 Mb default
> size. The size required depends on the number of tables and columns in
> your SQL Remote installation, but a size of 10 Mb is generally sufficient.
>
>
> --
> Thanks,
>
> Jeff
>
|
|
|
|
|