About IBSurgeon

IBSurgeon was founded in 2002 with the idea to provide InterBase and Firebird developers and administrator with unique services and tools focused on databases safety, performance and availability.  Today, IBSurgeon serves more than 2000 companies worldwide with emergency, optimization and maintenance tools, recovery and optimization various services.  IBSurgeon is a Platinum sponsor of Firebird Foundation and, as a member of Technical Task Group, has strong relationship with Firebird Project, with direct representatives in Firebird-Admins and in Firebird Foundation Committee.

Tools: FBScanner (logging, profiling, audit) FBDataGuard (database protection, monitoring and recovery) FBFirstAID (recovery) IBAnalyst (performance optimization)

Firebird database recovery

IBSurgeon offers 2 types of recovery service: on-site and via remote desktop.

On-site recovery means that customer needs to transfer database (archived in zip/rar/7z/etc) to us and we will perform recovery in our office.

To perform remote desktop recovery our specialists connect to the computer on customer’s side and perform investigation and recovery remotely.

IBSurgeon recommends remote desktop service in the following cases:

• for big databases;
• for databases with sensitive information (we are also ready to sign NDA to provide legal protection);
• for urgent recoveries. Sometimes it’s too long to transfer database file for recovery - it’s faster to connect and repair at customer's computer;
• for recovery on production system. IBSurgeon's engineers can connect to production system and perform recovery during offline hours.

More details: Firebird database recovery.

Optimization service

IBSurgeon offers optimization service, which includes the following:

• Hardware and OS settings investigation
• Firebird performance measurement, including transaction performance investigation
  
• Tuning recommendations for hardware, OS and Firebird settings.
  
• Firebird database indices configuration investigation
  
• Maintenance recommendations (including sweep/garbage collection, backup and transaction management).
  
• Indices and SQLs recommendations
  
• Licenses for our performance tools (IBSurgeon Transaction Monitor, FBDataGuard, FBScanner, IBAnalyst) which are valid during investigation period
  

This basic package is enough to identify and fix performance problem for 90% cases.
More details: Firebird database performance optimization service.