Video Screencast Help
Symantec Appoints Michael A. Brown CEO. Learn more.

Will backup job slow when Enabling dbclient log on SQL ?

Created: 21 Feb 2013 • Updated: 25 Mar 2013 | 4 comments
inn_kam's picture
This issue has been solved. See solution.

NB 7.1.0.4

wIN 2008 R2

SQL Server 2008 r2

 

I have enabled the db client log on SQL server Client , by double clicking mklogdir.bat file,which creates too many logs 

Simple question is

Will it slows down the performance of SQL backup and Restoration?

Thanks

 

Operating Systems:

Comments 4 CommentsJump to latest comment

Marianne's picture

My experience has been that level 0 logging (default) does not influence performance.

I prefer to always have dbclient log on SQL clients.

Easy enough to test - do a backup without dbclient log, record throughput.
Enable log, do backup, compare throughput.

Supporting Storage Foundation and VCS on Unix and Windows as well as NetBackup on Unix and Windows
Handy NBU Links

SOLUTION
Yasuhisa Ishikawa's picture

I usually enable level 0 debug logging for troubleshooting unexpected failure.
I'm not sure it affects performance of SQL Server backups, but for files and Oracle backups, I could not find performance degration.

Authorized Symantec Consultant(ASC) Data Protection in Tokyo, Japan

Will Restore's picture

There is minimal overhead writing to the log files.  I can't imagine it would adversely affect backup/restore performance.

 

Will Restore -- where there is a Will there is a way

inn_kam's picture

Thanks a lot to 

Marianne van den Berg ,

Yasuhisa Ishikawa ,

wr

As mentioned by marrianne ,I have also tested with and without enabling the logs and find no adverse effect on Backups performance of SQL backups, by selecting the option Logging 0 minimum

actuallly working with customer ,and this question arises

 

Thanks again for your support on forum