Performance degradation after Upgrading to SQL 2008

  • Hi,

    we have an application that was running fine on Win2k3 sp2 and SQL 2k5 SP2. But due to support reuirements we upgraded the server to win 2k8 64 bit and SQL 2k8. But now we are seeing many deadlocks in the database. After upgrading we did perform some maintenance activities like update usage, update statistics, defragment Indexes. That helped us a bit but still we are seeing multiple deadlocks and the site is rendering at twice the time that it use to. please advise if i need to perform any other maintenance activities or update any settings?

  • You need to find out when and where the deadlocks are occuring . Run a trace or use DMV's to get dead lock information.

    "Keep Trying"

Viewing 2 posts - 1 through 1 (of 1 total)

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