Search code examples
firebirdwindows-server-2016solid-state-drivefirebird-3.0

Backup/Restore of Firebird SQL Server 3.0.2 is slow on Windows Server 2016


I have installed Firebird 3.0.2 SQL database on my Windows Server 2016. No other software has been installed yet.

I'm using Superserver mode and an SSD drive.

When I just copy my database file of size 6 GB, it is done in 20-30 seconds (same disk).

But when I execute backup it takes 20-30 minutes. Restore is about the same amount of time. Together 40-60 minutes.

And there is strange thing: backup/restore process (gbak.exe) does not use full power of CPUs and HDD. It is using only ~20% . I don't understand why.

I think it should be something in configuration right? But I kept everything in default values.

Very important thing: I am new in Windows Server 2016 so I have no idea what I am doing.

Any ideas?


Solution

  • I found out that it is about configuration of Power Options.

    Windows Server 2016 is after installation set for Balanced Power Plan.

    I changed it to High performance and results are highly better. (backup drops from 30 minutes to 6 minutes)

    More details you can find here: https://serverfault.com/a/797473