Thanks a lot Perry

Nope...

Thanks Everyone.

Thanks for the reply.

Its a user created job is to update and delete some values from a table. Wait type was showing IO_COMPLETE

Whats the error in windows error log???

Thanks Gail.

The way i do is first install SP on Passive node(B) --> reboot it and then failover from active(A) to passive(B)

Now B is active and A is passive

Apply Service...

Hi Experts,

is it possible to have database timeout because of running profiler?

Thanks Everyone for the inputs.

Thanks a lot Grant

Yes Gail,

Thanks Again.

I have got around 130 trace files now.

In between the CPU came down to 13 at 7:54 and back to 95 again i have trace in between those times.

Can anyone...

Thanks Gail,

Yes its SQL Server using more than 95% now.

Thanks Gail,

Since we are still facing the issue i hope creating an Extended Event now also will give some insight.

Can you please help me on creatin one

Thanks Grant and Kevin,

CPU is still high .

What all events i need to select while create a profiler trace in this case?