Performance problem with Log Backups

Discussion forum about all things SqlBase.
Eric Dubreuil

Performance problem with Log Backups

Post by Eric Dubreuil » 03 Jun 2016, 13:09

Hi @all,

After upgrading SqlBase version from 11.5 to 11.7 We have a heavy performance problem with Log Backups on client side.

After doing many tests we can notice the following points.

- Both Database and log backups are ok and very fast on server
- Database (.bkp) backup is ok and fast on client
- Logs Backup (.LOG) is very slow on client - 30 minutes to write 27 files (1 Mo each)
- We experience the same problem using api functions in SQlWindows or SQLTalk commands

We are looking for ideas to solve or workaround this problem

Many thanks

Eric


*** The server Sql.ini ***

[dbntsrv]
dbname=ISLAND
dbname=SBTASK
ANSIJoinSyntax=1
centurydefaultmode=1
oracleouterjoin=1

readonly=0
NamedPipes=No
servername=PEX1,sqlws32
autolocktable=0
batchpriority=0
cache=256000
dbdir=C:\SQLBase117\Database
tempdir=C:\SQLBase117\Database


DBNAME=LG17ND45,SQLWS32
DBNAME=ELEC45,SQLWS32
DBNAME=LG17NF45

[dbntsrv.gui]

[dbntsrv.dll]
comdll=sqlws32

[dbntsrv.apipe]

[dbntsrv.ws32]
ListenPort=2155


[win32client]
clientname=Win32User

transports=tcp,npipe,apipe
clientruntimedir=C:\SQLBase117

[win32client.npipe]
serverpath=PEX1

[win32client.apipe]
autostartserverpath="C:\SQLBase117\dbntsrv.exe"
serverpath=PEX1

[win32client.ws32]
serverpath=PEX1,10.237.9.16,2155/*

*** The clientSql.ini ***

[dbnt1sv]
servername=Server1,sqlapipe
dbname=ISLAND,sqlapipe
centurydefaultmode=1
dbdir=D:\ProgramF\Gupta

[dbnt1sv.dll]
comdll=sqlws32

[dbnt1sv.apipe]

[win32client]
clientname=eric
secureapi=0
negotiateapi=0
transports=tcp,npipe,apipe

[win32client.dll]
comdll=sqlora32
comdll=sqlws32

[win32client.apipe]

[win32client.ora32]
log=d:\oracle.log

[oragtwy]
substitute=SYSSQL.,
substitute=",
remotedbname=DPOL,@DPOL
longbuffer=32767
fetchrow=20

[win32client.ws32]
serverpath=PEX1,10.237.9.16,2155/*

Mike Vandine

Re: Performance problem with Log Backups

Post by Mike Vandine » 09 Jun 2016, 02:16

Hi Eric,

What exact version of 11.7 are you using? Please make sure that you are on the latest and greatest 11.7 SP4.

If a backup database on client is speedy, there isn't any reason that I know of that should cause the backup of logs on the client to be slow.

How big is the .dbs file itself? How quickly does that get copied. With an 'on client' statement, the file is moved from the server to the client. Unless you have some major network issues, it shouldn't take 30 minutes to transfer 27MB of log files. Something else is going on...

Hmmmm. Are the .log files on the server locked by people working, i.e. is there a lot of activity going on?

Best regards,

Eric Dubreuil

Re: Performance problem with Log Backups

Post by Eric Dubreuil » 10 Jun 2016, 13:42

Hi,

Many thanks for your answer

- SqlBase version is 11.7 sp4 / SqlWindows version is 6.3 sp1
- Dbs size is roughly 78 Mo And .bkp done on client within 20 sec
- Test condition : 1 user only, no log files locked

We did some others tests with the following results :

SqlWindows 6.3 on client -> SqlBase 11.7.4 -> Backup Database OK / Logs slow
SqlWindows 5.2 on client -> SqlBase 11.7.4 -> Backup Database slow / Logs slow
SqlWindows 6.3 on client -> SqlBase 12.0.0 -> Backup Database OK / Logs OK

All these tests were made with the same network conditions.

It appears that backup speed will depend of the version associations of SqlWindows/SqlBase

It seems that upgrading SqlBase to 12.0.0 will solve the problem.

Best regards

Mike Vandine

Re: Performance problem with Log Backups

Post by Mike Vandine » 13 Jun 2016, 00:44

Hi Eric,

Yes, I think the best thing is to upgrade to SB12. I've checked the defects database and can't see any defects that were fixed relating to log backups, so the fix probably happened as a result of some other fix and not specifically to the backup logs.

Best regards,

Return to “General Discussion”

Who is online

Users browsing this forum: [Ccbot] and 0 guests