Upgrade from 2008 to 2008 R2, one of scripts leads to CPU 100%, why???


  • hi gurus, 

    I just upgraded one of production servers from SQL SERVER 2008 to 2008 R2. The server exhibited increasingly high CPU culminating in all 8 CPUs being 100% utilized when SQL SERVER executed one of scripts. These scripts ran everyday successfully before upgrade, and I could not figure out why it leads to CPU 100%, anyone can help me for this? 

    The server information is :

    OS: Win Server 2003 R2  x64, CPU:8, Memory: 64GB.




    Monday, February 18, 2013 12:48 PM


All replies