this is not the smp the problem, but the missing index 'IDX_Item_Account_Id_Owner_Id_Auction_Id_Keeping_I d' that you should have been created using for example
Code:
CREATE NONCLUSTERED INDEX [IDX_Item_Account_Id_Owner_Id_Auction_Id_Keeping_Id] ON [dbo].[Item]
(
[account_id] ASC,
[owner_id] ASC,
[auction_id] ASC,
[keeping_id] ASC
)
as repacks already have indexes, and not you, other indexes can be missing too (but there are columns name in the name of the index so you can create them)