Time out issues and performance issues when upgrading from 2008 R2 to 2012 SP3.


  • Hello All,

    My application is timing out frequently and application is running slow after upgrading from 2008 R2 to 2102 SP3.

    We did all the basic checks(Update Stats, rebuild indexes, checked the MXDOP settings).

    There is one SP the vendor wrote is using sysobjects table. This in the profiler is taking about a sec to get executed where this same SP is taking 0 secs in 2008. This 1 sec difference is bloating 15sec by the time the complete SP stmt is completed as this SP is making 15 calls to sysobjects in its entire code. While I am not sure why they are calling the sysobjects 15 time in SP.

    SQL 2008 is 8 core but is shared with other DB

    SQL 2012 is 4core stand alone.

    Please help.

    Thank you


    Monday, January 2, 2017 8:21 PM

All replies