|
Home > Archive > SQL Anywhere database replication > August 2005 > SQL Remote temp files size
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 temp files size
|
|
| BALMOKOUN 2005-08-01, 9:23 am |
| Hi,
ASA 9.0.2 Win 2000 SQL Remote The cust is interested in how much disk space
can SQL Remote take for it's temp files.
Thanks in advance for your help,
Antoine
| |
| Reg Domaratzki \(iAnywhere Solutions\) 2005-08-05, 9:24 am |
| Temp files are created by dbremote during the log scan phase. The amount of
temp space used will be highly variable and be based on the following
criteria :
1) The amount of the transaction log that needs to be scanned.
2) The number of remote users in the system.
In theory, I think the temp space could be as high as the total size of all
your offline transaction logs (plus active transaction log), but the odds of
it getting this high are roughly the same as being hit by lightning and
winning the lottery on the same day.
--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup
iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL
"BALMOKOUN" <abalmoko@sybase.com> wrote in message
news:42ee2019$1@foru
ms-2-dub...
> Hi,
>
> ASA 9.0.2 Win 2000 SQL Remote The cust is interested in how much disk
space
> can SQL Remote take for it's temp files.
>
> Thanks in advance for your help,
>
> Antoine
>
>
|
|
|
|
|