> Hi All,
>
> I'm getting intermittment reports of a memory problem on a 4-user site.

This

> is the first FB 64bit app that I have deployed so if anyone has any useful
> insights as to whether you think the problem lies with the app or FB or
> a.n.other scenario then great. (BTW, the server is looking for a reboot
> following significant updates + symantec mail security for exchange has

10+

> instances running on the server).

I would do this:
- Set sweep to 0 and do this manually
- update to the latest 2.1.4 snapshot- I don't know what charset you are
using but there is a memory loss issue fixed in 2.1.4 with regard to blob
transliteration

Alan

>
> In taskmgr 97% of memory is shown as in use and FB in far and away the
> highest user of it. Resource monitor shows FB using:
> Commit: 1460kb
> Working: 1279kb
> Private: 1275kb
>
> The app has quite a lot of dynamically-created datasets but internal
> diagnostics doesn't reveal any memory leaks. The gstat output seems to
> confirm this.
>
> Lastly, the tasklist /all summary shows fbserver using ole32.dll which I

found

> surprising....
>
> Environment
> -----------
> DefaultDbCachePages = 8192
> Page Size 16384
> Forced Writes enabled
> Sweep Interval 20000
>
> Firebird-2.1.3.18185_0_x64
> Windows SBS server 64bit
> Intel Xeon@2.27Ghz
> 6gb ram
>
> gstat header output
> -------------------
> Database header page information:
> Flags 0
> Checksum 12345
> Generation 369685
> Page size 16384
> ODS version 11.1
> Oldest transaction 369564
> Oldest active 369565
> Oldest snapshot 369557
> Next transaction 369664
> Bumped transaction 1
> Sequence number 0
> Next attachment ID 1202
> Implementation ID 26
> Shadow count 0
> Page buffers 0
> Next header page 0
> Database dialect 3
> Creation date Jun 19, 2010 14:04:59
> Attributes force write
>
> Variable header data:
> Sweep interval: 20000
> *END*
>
>
> TASKLIST /ALL
> -------------
> fbserver.exe 16860 ntdll.dll, kernel32.dll, MSVCR80.dll,
> msvcrt.dll, WS2_32.dll, ADVAPI32.dll,
> RPCRT4.dll, NSI.dll, MPR.dll,

USER32.dll,

> GDI32.dll, icuuc30.dll, icudt30.dll,
> ole32.dll, COMCTL32.dll, SHELL32.dll,
> SHLWAPI.dll, IMM32.DLL, MSCTF.dll,

LPK.DLL,

> USP10.dll, comctl32.dll, NTMARTA.DLL,
> WLDAP32.dll, PSAPI.DLL, SAMLIB.dll,
> NLAapi.dll, IPHLPAPI.DLL, dhcpcsvc.DLL,
> DNSAPI.dll, Secur32.dll, WINNSI.DLL,
> dhcpcsvc6.DLL, napinsp.dll,

mswsock.dll,

> winrnr.dll, wshtcpip.dll, fbintl.dll,
> CRYPT32.dll, MSASN1.dll, USERENV.dll,
> credssp.dll, schannel.dll,

NETAPI32.dll,

> pwdssp.dll, msv1_0.dll, cryptdll.dll
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item on the main
> (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ++++++++
> Yahoo! Groups Links
>
>
>