Performance optimization questionnary

Required information for Firebird database performance optimization

(please answer as many questions as you can. If you don't know answer or unsure about it, just leave it blank)

Hardware

Virtualization

Operation System for Windows

Operation System for Linux

Firebird

Database

Application

Background of the problem

Logs and files

Please get all possible files and gather logs as described below.

Zip all files and results into the single file and upload here.

We need the following files and logs:
1. firebird.conf
2. firebird.log (zipped)

3. Please run 3 times from Firebird\Bin this command fb_lock_print –d path_to_database  > log111.txt

Run it during peak times (for example, 11-00, 14-00 and 16-00), and compress results.

4. Please save as file (or screenshot) output of gstat –h from the peak load (around noon), and no load – from early morning or late evening.

5. Please get output from peak time with this command gstat –a –r > stat.txt

Zip all files and results into the single file and upload here.
Subscribe