. . "I think that any multi-cpu/core machine should do fine for such a test as long as there is no other significant activity.Note that the WITH keyword is required to specify locking hints with MERGE. For example: MERGE dbo.Foo WITH (UPDLOCK, HOLDLOCK)...WITH is optional in some other DML statements but I recommend specifying it even when optional for consistency." . .