• nball

    How to find the duration of a snapshot in a replication

    • 0 Comments
    Suppose you have setup replication and would like to know how to find the time taken to create a snapshot. and time taken to deliver a snapshot. Run the script in the distribution database. Snapshot creation time select mh.agent_id,ma.name...
  • nball

    Lock Hints are ignored in Alwayson availability group

    • 0 Comments
    There are many instances when you run some query and realize that you need to use optimistic or pessimistic approach to effect the concurrency. When you use Always on Availability group, you should be aware that any lock hints such as updlock,xlock or...
Page 1 of 1 (2 items)