Replying to @tr_stringer
1
Replying to @tr_stringer
@SQLife Yeah, "Nx is not reachable from Nz". FW validation worked fine though so it can communicate with the Nx node. #SQLHELP
WSFC for SQL AG - one node in another subnet fails validation for network comm. but passes all FW validations. Ideas? #SQLHELP
1
In Profiler, I saw an SP suddenly take 30s to finish (normally 200ms range) but it also shows CPU, Reads and Writes as 0. Clue? #SQLHELP
1
@cjsommer Yes, D2 is DR site only. @nocentino's whitepaper link is exactly what I was looking for - force failovers, failback, etc. #SQLHELP
1
In SQL AG: Datacenter D1 has 2 nodes + 1 FSW. Datacenter D2 has 1 node on diff subnet. Would this setup work? Or D2 needs 2 nodes? #SQLHELP
1
Any reason the same SP would run a lot slower as an RPC called vs a SQL Batch (as it appears in Profiler)? #SQLHELP
3
Stuck trying to move out a Cluster Core Resource (Name/IP) from inside a Role. Accidentally Assigned it to a Role #SQLHELP
1
I accidentally moved the Cluster Name/IP from Cluster Core Resource to a particular role's. Can you move that back? #SQLHELP #Win2012R2
1
