more HQ servers?

Thank you for reply.

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)?

Thank you for help in advance

Adam

"Matt Hurst" wrote:

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

"Adam" wrote: