[firebird-support] Re: Issue with Database Cache Size on FB 3.0

01.06.2016 04:16, Fabian Ernesto Chocron wrote: > > We are having trouble setting up the database cache size on FB 3.0 > running on Windows 2008 R2 64 bits with 32 GB ram. > > The problem we have is we cannot get the server to allocate the ram for > the cache as we intend. With FB 2.54 we had the

Re: [firebird-support] Issue with Database Cache Size on FB 3.0

Hi Fabian, Firebird caches only actually used pages. The small cache means that your application touches the small part of the database. -- Regards, Alexey Kovyazin IBSurgeon PS It is difficult and wrong to give you any direct advice without all details in hands - it can lead to worse

[firebird-support] Issue with Database Cache Size on FB 3.0

Hi All We are having trouble setting up the database cache size on FB 3.0 running on Windows 2008 R2 64 bits with 32 GB ram. The problem we have is we cannot get the server to allocate the ram for the cache as we intend. With FB 2.54 we had the DB cache set very high, close to 1 GB per

Re: [firebird-support] Stored Procedures Execution Plan

It was sent and received... but this is working for me out of the box in FB 2.5.4. I just write the select * from SP and ask for plan and it gives me the plan for the inside statements. Haven't tested on non-selectable SPs. Em qua, 25 de mai de 2016 às 08:20, João Paulo Carvalho

Re: [firebird-support] how to keep history of statements per transaction?

Hi, use Trace API - the basic variant with text output is included into Firebird. If you need GUI and retrospective analysis, you can try HQbird (trial version of Standard is 14 days), it contains PerfMon tool with TraceAPI support More details in HQbird Guide, page 66

[firebird-support] how to keep history of statements per transaction?

Hi, I'm looking for easy to use solution that can help me trace statements executed inside every transaction and keep them until transaction is active. Once it is closed(commit or rollback) statements are discarded. I need this to be able to run on a production system in order to track which

[firebird-support] Firebird 3 on Kubuntu 16.04

Hey All, Does anyone have the latest install guides for Firebird 3 on systemd based Ubuntu systems? I installed firebird, gave it the password but the install had output as follows Created default security3.fdb Failed to start firebird3.0-server.service: Unit firebird3.0-server.service not

[firebird-support] Risks - Experience and doubts regarding upgrading to FB 3.0 from 2.54?

Hi Again We are about to upgrade from Windows 2008 FB 2.54 64 bits into Windows 2012 R2 FB 3.0 64 bits, and would appreciate comments from experienced DB administrators. We use FB as the main DB, and we access it via 32 bit native ODBC (the latest version of Firebird ODBC). I would