Recently we encountered a case where in a sql server which was running and hosting Biztalk instances was showing 100% CPU. We started troubleshooting from the SQL end to identify who is major consumer of CPU and following were our observations and findings · We used the perfmon counter Process %Processor time… Continue reading HIGH CPU on Sql Server running Biztalk instances