Home Forums Article Discussions Article Discussions by Author Discuss content posted by Geoff Albin How to Monitor for High CPU utilization in SQL Server RE: How to Monitor for High CPU utilization in SQL Server

  • November 17, 2010 at 4:39 am

    #1251811

    yes, I know that query who leads high CPU utilisation.

    I had written that query in while loop. It simply deletes top 500 records with UPDlock,READPAST

    and insert them into linked SERVER B.

    Any suggestion?