Thanks! I agree with the scenario you mentioned, If CPU is being caused by slow reads or writes to the disk subsystem. Adding memory to server increases the size of...

I agree with you, i have seen in the past adding indexes has resolved high CPU Usage. But never came across adding more memory to SQL Server would help high...

I could able to setup using the above link. However, my understanding SQL Server error logs entries for database time outs as well right caused by network glitch or any...

Thanks to everyone. So i found the problem and resolve the issue. However, i have another question and see what you'r thoughts on it? If ever there is a CPU...

Yes. I know. Thanks. Can anybody comment on other items as well?

Adding more details, just checking to see if you have came across with this.

Error: 1474, Severity: 16, State: 1.

Database mirroring connection error 4 'An error occurred while receiving data: '10060(A...

Above error was truncated so adding again....

Database mirroring connection error 4 'An error occurred while receiving data: '10060(A connection attempt failed because the connected party did not properly respond after...

After looking into the logs on DR server, it started with login failed for the application account. Next

Database mirroring is active with database 'DB Name' as the mirror copy

After approx...

It is mirroring not AG. But do you think these errors are because of Network issues right? The reason i am asking is,it cause application issues, so i am trying...

Thanks a lot!

On side note, just checking to see if you have came across with this any chance. I agree it has to be different thread but just checking to...

Got the same error as above.

Database mirroring connection error 4 .

Could be anything else other than server load or network issues?

Michael, this is really doesn't make sense to me, why does someone put something unrelated question to the subject in this thread instead of posting new thread? This is what...

Thanks Michael and Sue! I really appreciate for all your inputs.

So you are suggesting it's okay to be granted the following in DEV servers?

SQLAgentUserRole

SQLAgentOperatorRole

permissions to run traces, extended events and...

Thanks. Do you have any comments on other items?

Also another thought may be memory is probably covering up for other sins? Since the CPU usage is less than 5% could be the memory is more on the servers,...