Have anyone of you used more HQ servers. As far as I know Microsoft does not support solution for two or more HQ servers. I will have to find solution for system with more than 50 POS and I consider implement up to 4 HQ servers. However it is hard to evaluate if it would work correctly.
I have additional questions. Perhaps you could answer on them as well.
I intend to start four headquarters on one machine based on processor with 4 cores(or two processors with two cores each). I wonder if any data inconsistency may appear (every headquarter work on database and I am not certain if it won't "damage" data). Have you noticed anything like that? Do you think it is possible to share RAM (let's say that I've got 4 GB of RAM and would like to share it among cores or processes)?
I have only tried it with 2 hq servers. I don't expect you will have data issues but you may have a bottleneck with the networking attaching to that many clients on the same machine. The only problem I had running more than 1 server on the same machine was that the 401 upload worksheets would fail often enough that it was a pain to reset them, so I created a trigger in the worksheet table to set them active again:
CREATE TRIGGER ResetFailedUpload ON dbo.Worksheet FOR UPDATE AS DECLARE @Rows INT SELECT @Rows = @@ROWCOUNT IF @Rows = 0 /* No rows UPDATED, exit trigger */ RETURN update s set s.status=0 from worksheet w join worksheetstore s on worksheetid=w.id where style@1 and w.status=5 update worksheet set status=2 where style@1 and status=5
BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here.
All logos and trade names are the property of their respective owners.