meta user
network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year |
| seen | Mar 11 at 17:53 | |
| stats | profile views | 2 |
|
Feb 19 |
comment |
Are there problems with using SQL Server AlwaysOn Availability Groups with Windows 2008R2? Thanks for sharing your experience. This tallies with what we've seen, and is somewhat reassuring. |
|
Feb 19 |
asked | Are there problems with using SQL Server AlwaysOn Availability Groups with Windows 2008R2? |
|
Jan 29 |
revised |
when can AG primary replica be a different host to WFC primary? added 8 characters in body |
|
Jan 29 |
asked | when can AG primary replica be a different host to WFC primary? |
|
Nov 21 |
comment |
SQL Server connection with multiSubnetFailover fails, claims mirroring is enabled Yes, but mirroring was later removed. I'm interested in finding what remnants of that configuration there might be in places I haven't found yet. Yes the AG listener is configured for multi-subnet with a Windows failover cluster; it owns an IP address on both subnets. |
|
Nov 16 |
awarded | Editor |
|
Nov 16 |
revised |
SQL Server connection with multiSubnetFailover fails, claims mirroring is enabled added 105 characters in body |
|
Nov 16 |
comment |
SQL Server connection with multiSubnetFailover fails, claims mirroring is enabled Yes, I ran that on both sides, and both reported that they were already not configured for mirroring. |
|
Nov 16 |
asked | SQL Server connection with multiSubnetFailover fails, claims mirroring is enabled |
|
Apr 30 |
comment |
how does SQL Server know to lock view objects? One question: we agree that using the view should block concurrent attempts to change the view definition. Then why take IS rather than Sch-S lock on this? Only difference between the two is behaviour on bulk updates. I would expect it to take the weakest lock it could that gave the required protection. |
|
Apr 30 |
awarded | Scholar |
|
Apr 30 |
accepted | how does SQL Server know to lock view objects? |
|
Apr 25 |
awarded | Student |
|
Apr 25 |
asked | how does SQL Server know to lock view objects? |
