Tag Info

New answers tagged

1

You need to setup a AG aware SSB route between x and y. See Service Broker with AlwaysOn Availability Groups. This route will deliver the messages over the network even when x and y are collocated on the same host. When failover occurs and x and y are on different hosts, the delivery continues uninterrupted. My personal guess is that SSB Always uses the ...


0

Is it possible that you create a configuration file and then you auto create the necessary registered servers in SSMS? Just as mentioned in this article: http://www.mssqltips.com/sqlservertip/3252/automate-registering-and-maintaining-servers-in-sql-server-management-studio-ssms/


1

Note that regardless of whether you trigger a table lock, a 1000+ record INSERT transaction will lock many pages in your indexes, and has a high risk of causing deadlocking or other problems. The good news is that your post does not seem to provide a business case for taking on a such a large transactional operation. The data source table is not going ...


1

The only correct answer here is "It Depends". There are so many factors that come into play that you will just have do many runs with different parameters try to find what are the optimal settings for your system, and you can also play with locking hints if your table has indexes that are optimal for the search condition. There are some rules of thumb.. if ...


4

This is documented here on BOL: Thread Usage By Availability Groups. For redundancy purposes, here is the breakdown: 3 to 10 shared threads (but can increase depending on primary replica workload) (primary replica) 1 log capture thread per primary database (primary replica) 1 log send thread per secondary database (secondary replica) 1 redo thread for ...


0

I had an Availability Group with the same symptoms. For maintenance reasons 1 node was down. Quorum remained from 2nd node and file share. After 7 hours the alive node has (probably) lost the connection to file share and as last man standing has stopped serving clients - has lost connectivity to major part of quorum. When the file share become available ...



Top 50 recent answers are included