1

Topic: Pair of questions on AllwaysOn

I try to check up operation AllwaysOn using the elementary label in which some records. There is a pair :
1. I stop SQL the server of the first (Primary) remarks. The remark on other server becomes Primary. Like all works, but at attempt to add record in my label the spin box starts to digitize already with 1000. And should be?
2. I launch earlier stopped remark. I stop the second. And here the principal problem - a remark on the first server does not become Primary, accordingly operation becomes impossible until then yet does not earn the second server. In what here there can be a business?

2

Re: Pair of questions on AllwaysOn

AndrF;
1) Means 999 records before have been interposed. Or  describe a problem.
2) 2 it was in time . What was its status? What with adjustment Maximum failures in the specified period?

3

Re: Pair of questions on AllwaysOn

aleksrov wrote:

1) Means 999 records before have been interposed. Or  describe a problem.

Is not present - the label fresh, was before some records are interposed all.
Order ShV-shek turns out about such:
1
2
3
4
1000
1001
1003

aleksrov wrote:

2) 2 it was in time . What was its status? What with adjustment Maximum failures in the specified period?

About, thanks! Understood in what business.

4

Re: Pair of questions on AllwaysOn

AndrF;
gap in identity it is normal. This behavior from a box.

5

Re: Pair of questions on AllwaysOn

AndrF, the server caches on 1000 records for idntity and produces to their new lines. When come to an end - caches the following.
At reboot (and at moving on another ) the cache is lost, undertakes at once in a cache following 1000.

6

Re: Pair of questions on AllwaysOn

aleksrov wrote:

2) 2 it was in time . What was its status? What with adjustment Maximum failures in the specified period?

And here who or whether can give what or recommendations about value Maximum failures? So to say proceeding from a private experience with a short substantiation...