How can I tell which Firebird architecture is installed (classic or super-server) for win32?

Posted on 2009-12-17
Last Modified: 2013-12-09
1. How can I tell if an existing Firebird installation is configured/installed/running in Classic Server / Super-Server mode?
2. How can I switch between the two?
3. Which versions of Firebird and which architectures support multi-threaded applications on multi-processor servers?
4. How to configure Firebird on multi-processor servers?
Question by:samenglish
    LVL 7

    Author Comment

    re Q1:

    Look for fbserver.exe (and potentially fbguardian.exe) in firebird_dir\bin fodler for Super-Server installations; and look for fb_inet_server for Classic Server installations.

    re Q2:

    doesn't look it's possible to "switch modes". Might have to uninstall/reinstall, or potentially install multiple instances (2nd install has to be done manually - not with the installer - refer to

    still working on Q3 and Q4.
    LVL 7

    Author Comment

    re Q3: Only Classic Server architecture supports multiple cpu's and there's a comparison chart here
    LVL 7

    Author Comment

    re Q2: You can switch between modes by effectively uninstalling the service and reinstalling it with different parameters as Andrei advised here
    LVL 7

    Accepted Solution

    Here's the answer... (thanks Andrei)

    Close all client connections. Got to Firebird\Bin directory. Execute specified sequence of commands:

    instsvc stop
    instsvc remove
    then either:

    instsvc install -s -a   -- for Super Server

    instsvc install -c -a   -- for Classic
    after that:

    instsvc start
    3 -- Super Server always runs on single processor or core and can not scale. Use Classic architecture in SMP environment. In latter case dont specify page buffers more than 800-1000.

    Be aware that performance of Classic Server depends on performance of disk subsystem. For big databases use RAID controllers with internal cache memory, battery and "write back" mode enabled.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    What do we know about Legacy Video Conferencing? - Full IT support needed! - Complicated systems at outrageous prices! - Intense training required! Highfive believes we need to embrace a new alternative.
    This paper addresses the security of Sennheiser DECT Contact Center and Office (CC&O) headsets. It describes the DECT security chain comprised of “Pairing”, “Per Call Authentication” and “Encryption”, which are all part of the standard DECT protocol.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    8 Experts available now in Live!

    Get 1:1 Help Now