Thanks, Johan,

That was my preference. We need to implement processes but I don't think the effort is going to be worth splitting this one and we'll address the large partition...

Hi EdVassie,

Appreciate the response.

Configuration wise we were fine. The LB and the AG were correctly set up with individual unique IP. The problem we had was windows bound this IP...

Thanks @Jeffrey Williams

Working through with the team. This was our original plan just wondered if there was any magic we could do 🙂

Thanks @CC-597066 I played with this but to be honest it wasnt sufficient to have failures occuring

By way of update this was resolved. We identified an issue on the probe...

Thank you frederico_fonseca.

Yes, I was aware of the recommendation I'm just investigating all options to present accordingly with the pros and cons.

Thank you.

I had the Portal admin copy the DB manually and it was infinitely quicker. Will be creating a PowerShell script to automate now.

Hello folks,

Thank you for your responses. I believe I have found the issue and it was simply that the SP has a final insert which was using a subquery to...

I've also noticed that in sysprocesses we also have 5 rows with 4 showing CXPacket as the last wait time with huge amounts of waittime while the other shows SOS_SCHEDULER_YIELD...

Also I've seen suggestions to restart the server service. Will this take down my SQL instances?

Thanks

Hi Grant,

Thank you for the reply.

We've already confirmed that the network is not under pressure during the wait times. Really what I'm trying to understand is does a Bulk...

Thank you both for your response.

I've attempted the DBCC UPDATEUSAGE however I have not seen anything improvement.

Jeff,

We have carried out a large amount of deletes on the database only....

Could try Change Data Capture?

Just a quick update on the situation. After enabling error outputs on the powershell I am seeing the following during outages:

"No connection could be made because the target machine...

Thanks for the response.

The issue appears to occur before the connection reaches SQL so the logs show nothing. Changing the logging requires a restart which right now is not...

Fixed port.

Firewall is open. Have tested by turning it all and issue persists.

Would it be possible that an application is flooding, for the want of a better word, the...