Jon Smithson (@AskSQL) profile picture
New York
Joined March 2010
@SQLcycle @SQLife It uses UDP 3343 to do connectivity checks #SQLHELP
Replying to @tr_stringer
@SQLife Can confirm also that can telnet to 3343 both ways. #SQLHELP
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
Replying to @nocentino
@nocentino Thanks pal! Exactly what I need!
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
What is the best way to consume XML provided by REST service in #SSIS? Should entire XML file be downloaded first then parsed? #SQLHELP
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
Replying to @SQLHA
@SQLHA Deleting the role caused cluster to disappear from FCM GUI but still see it in PS. Going to be interesting trying to salvage this.
1
Replying to @SQLHA
@SQLHA Curiosity got to cat. Cat is baffled as we speak.
1
Replying to @SQLHA
@SQLHA Wasn't in PROD. More like a curiosity move in testing env. Can't even delete the Role because of Cluster Core Resource there #sqlhelp
1
Stuck trying to move out a Cluster Core Resource (Name/IP) from inside a Role. Accidentally Assigned it to a Role #SQLHELP
1
Replying to @jdanton
@jdanton Cluster works fine but the Name/IP shouldn't be assigned to a role, right? Should just be in Core Cluster Resource? #SQLHELP
1
Replying to @jdanton
@jdanton What I moved is the Cluster Name/IP, not SQL Name/IP so I am not sure if this breaks the cluster if I delete it #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
Replying to @SQLHA
@SQLHA Oh yeah, definitely lots of it depends :-)
1