Post reply

Compatibility Level

  • 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.

  • 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?

    😎

  • 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/

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply