Hi Sqlfrenzy, Its SQLServer which is consuming the CPU, I checked it on Resource Monitor.

Hi SQLSACT, There is no wait only the CPu utilization is 90-100%.

Hi Grasshopper, Please instruct me how to do this.

Yes, You are right but its happening since last 3-4 days only, everything before that was working absolutely fine. We have not changed the queries or anything. Its now utilizing...