April 11, 2016 at 11:52 am
Hello,
Last week we changed Compatibility Mode (100 to 110) in our SQL Server 2012. After changed compatibility mode , we have noticed that our backup speed is start deceasing (338 MBPS to 277 MBPS) and backup finish time is start increasing.
Is there any co-relation between backup and Compatibility mode?
Please advice...
Thanks for any suggestion/help.
April 11, 2016 at 12:40 pm
jalpaparikh (4/11/2016)
Hello,Last week we changed Compatibility Mode (100 to 110) in our SQL Server 2012. After changed compatibility mode , we have noticed that our backup speed is start deceasing (338 MBPS to 277 MBPS) and backup finish time is start increasing.
Is there any co-relation between backup and Compatibility mode?
Please advice...
Thanks for any suggestion/help.
Quick questions, are the sizes of the backups the same? Are the backups compressed? How long have you been observing this trend?
😎
April 12, 2016 at 4:48 am
I can't say this is anything I have ever noticed.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
April 12, 2016 at 5:11 am
Shouldn't be the case. Compat mode is an instruction to the query processor as to how to treat some T-SQL constructs. It doesn't change the format of the data file, nor the process of backups.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply