Reputation
300
Top tag
Next privilege 500 Rep.
Access review queues
Badges
2 8
Newest
 Editor
Impact
~8k people reached

  • 0 posts edited
  • 0 helpful flags
  • 13 votes cast
Feb
4
accepted SQL Server AG - Is there any case for un-clustering prior to certain operations?
Feb
4
comment SQL Server AG - Is there any case for un-clustering prior to certain operations?
This ended up being the real reason. Their script ended up having no determinable impact. It was their unfamiliarity with clusters that made them concerned.
Jan
18
comment SQL Server AG - Is there any case for un-clustering prior to certain operations?
No I don't. What I want to know is if I do an operation that takes 5 minutes on a non clustered database, will the same take 10 minutes in a cluster, or the same amount + some minimal overhead? I'm guessing it's not going to double or even get that close, but I was hoping for some experienced insight.
Jan
18
comment SQL Server AG - Is there any case for un-clustering prior to certain operations?
But it only waits for a write to the secondary node's log. If there's an alter on a large table, it shouldn't wait for the alter to complete on the secondary, correct?
Jan
18
awarded  Editor
Jan
18
revised SQL Server AG - Is there any case for un-clustering prior to certain operations?
more detail
Jan
18
comment SQL Server AG - Is there any case for un-clustering prior to certain operations?
this is synchronous
Jan
18
asked SQL Server AG - Is there any case for un-clustering prior to certain operations?
Dec
11
awarded  Tumbleweed
Dec
4
asked Availability Group failover stuck in Resolving State
Dec
1
awarded  Enlightened
Dec
1
awarded  Nice Answer
Sep
13
awarded  Autobiographer
Jul
25
awarded  Scholar
Jul
25
accepted Oracle out-of-place upgrade on same host: impdp issues
Jul
11
comment Oracle out-of-place upgrade on same host: impdp issues
REMAP_DATAFILE works, I found that solution but it took me a while to get the quoting/delimiting syntax correct. Can you expand on the session variables? I'm also having an issue with roles not importing, seemingly due to the fact that the object already exists.
Jul
11
asked Oracle out-of-place upgrade on same host: impdp issues
May
16
answered pt-table-checksum from remote server
May
11
comment MySQL Cluster Installation
can you provide your config files?
May
11
awarded  Yearling