Compatibility Level

• jalpaparikh

  Valued Member

  Points: 72

  More actions

  April 11, 2016 at 11:52 am

  #313165

  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.

• Eirikur Eiriksson

  SSC Guru

  Points: 182946

  More actions

  April 11, 2016 at 12:40 pm

  #1871227

  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?

  

• colin.Leversuch-Roberts

  SSC Guru

  Points: 52643

  More actions

  April 12, 2016 at 4:48 am

  #1871337

  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/

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  April 12, 2016 at 5:11 am

  #1871340

  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

  We walk in the dark places no others will enter
  We stand on the bridge and no one may pass