Skip to main content
IMADBA's user avatar
IMADBA's user avatar
IMADBA's user avatar
IMADBA
  • Member for 7 years, 1 month
  • Last seen more than 4 years ago
comment
Connectivity timeout between cluster nodes
If there is no impact to jobload then increase your timeout to 100-200. The errors are expected because your system is undergoing a high load. This was the solution provided by a Microsoft Premier Ticket.
comment
Should SQL Server Always-On Availability groups have storage deduplication enabled?
Yeah try saying that to the storage team:-) I don't know if I wouldn't use storage array for anything. The point is that if I am using AG - I should benefit by having two separate stoarage to avoid single point of failure.
awarded
revised
Connectivity timeout between cluster nodes
added 698 characters in body
Loading…
comment
Connectivity timeout between cluster nodes
Which version of SQL are you on? What is your timeout set at? What is SQLserver waiting on during those errors? DO you see healthy/unhealthy alerts in databases when you receive this error? Are there any job failures during the error? are there any high loads/ETL loads during the time of error? We had a similar problem in our environment during high ETL loads - the Dbs were available but reported unhealthy/ealthy alerts. We simply increased the timeouts to 100/200 since the alerts were acceptable during these high peak loads.
awarded
answered
Loading…
Loading…
1
2