Post reply

performance and compatable mode

  • November 7, 2007 at 1:20 am

    #200235

    Will compatable mode affect performance ?

    karthik

  • November 9, 2007 at 6:14 am

    #749805

    Any idea ?

    karthik

  • November 13, 2007 at 1:16 am

    #750508

    Do you mean compatability mode? (80,90,...)?

    I doubt it will. All the compat mode does is enable of disable the new features. It does not make the server behave like an earlier version

    eg, if SQL 2000 and SQL 2005 run a query in different ways, setting the compat mode to 80 on the 2005 server will not make it run like it did in 2000

    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 3 posts - 1 through 2 (of 2 total)

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