Tag Info

Hot answers tagged

2

Partitioning will likely not help, unless the user query in the deadlock can be rewritten in order to let partition elimination kick in. I would focus on making both operations in the deadlock graph as fast as possible instead. This will involve ad-hoc indexing or rewriting the query in a different form. If the replication agent is often the deadlock ...


2

The data should be "the same" as on my machine, that I can dismiss my server and point to new machine in the end. Based on your comments, your best option would be Database Mirroring or Log shipping. You have to evaluate your RPO and RTO. Since you are using VPN to your actual machine - meaning it is point-to-point connection : If you go with ...


2

It sounds like you're trying to setup a disaster recovery environment, so that if your local machine blows-up you can switch over to the Azure machine. There are a number of options, each with their own pros and cons. These are well documented elsewhere (see this link for an overview from Brent Ozar: ...


2

#5: transactional replication. Why is this an option? Because the documentation explains exactly why it is possible there - once initialized, index changes are not replicated in either direction. Indexes can be added at the Publisher or Subscribers with no special considerations for replication (be aware that indexes can affect performance). CREATE ...


2

For querying secondary run the following command first. After running this, you can do all regular stuff on secondary. rs.slaveOk() To see the replication status, run the following command on primary. This will show you if the secondaries are up to date or lagging. db.printSlaveReplicationInfo() Hope this helps.


2

I believe your DBA is referring to Publishing Stored Procedure Execution in Transactional Replication. With Transactional Replication you have the option to published the definition of the stored procedure or the execution of the stored procedure. Publishing stored procedure execution can provide significantly better performance for large batch operations ...


1

Firstly, it is not recommended to have a replica set with even number of members. Hence, it will be better to add an arbiter or another data bearing node in the DC2 Coming to your question, the DR servers are not supposed to be used for ensuring availability they are meant to provide limited functionality during recovery from a disaster. Assuming the ...


1

1) If we can set up the transactional replication between server A of version 2014 and server B of version 2012. Tried to Google out but could not find the exact documents because may be am looking somewhere wrong. Please suggest if it can be set up? For your replication to work, the PUBLISHER and DISTRIBUTOR should be on same version. The subscriber ...


1

I ended up using a post-initialization script to grant this permission at the subscriber and it worked great.



Only top voted, non community-wiki answers of a minimum length are eligible