Thanks

jobs run overninght everyday.

I tried scheduling traces but impacted performace as its 24/7 server had a P1 raised for it.

well i could resolve this on my own.

Removing Y_OLD from the SQl server dependencies did the magic .

sorry for the delayed response was off sick for sometime.

Yes, job steps include SP's with droping and recreating indexes. But same job takes just under an hour

to complete sometime...

thanks!

Thanks!

Did anyone had any update on this I'm stuck with this issue right now tried every option described in the soultion with no luck

update stats is scheduled using Light speed .

I've attached the screenshot for you.

Thanks.

I think it's because we can't create multiple Endpoints i suppose

Thank you all for guiding me in the right direction

That's correct I want to know if the output I've attached is alright for the server or it's bad and some tweaking is needed?

CPU is 100% most of the time even when users are not using the server

Can you see the attachment now?

attached is the output from on of the server which has memory issues.

will this output give any picture about the issue?

That means once it becomes 8GB RAM I should remove 3GB switch isn't?

Yes, 32-bit Enterprise edition.