Subject | Re: Possible memory problem related to FB? |
---|---|
Author | tomsee7 |
Post date | 2010-11-23T19:10:43Z |
Update:
I looked at the server some time after two users had logged out and taskmgr shows 81% in use with FBserver dropping to:
Commit: 185kb
Working: 143kb
Private: 139kb
So it looks like there is a problem for me to find, although as the gstats output seems ok this is not going to be so easy...
Tom
I looked at the server some time after two users had logged out and taskmgr shows 81% in use with FBserver dropping to:
Commit: 185kb
Working: 143kb
Private: 139kb
So it looks like there is a problem for me to find, although as the gstats output seems ok this is not going to be so easy...
Tom
--- In firebird-support@yahoogroups.com, "tomsee7" <tomconlon7@...> wrote:
>
> 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).
>
> 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@...
> 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
>