We are having issues with our transaction being delayed, by 5-6 mins when its trying to post. After testing the network and adjusting settings based on most of the advice on this site. What we have discovered however using SQL profiler when a transaction is posting is the transaction trys to run the exact same query 5-6 times in a row with a 1 min wait in between trys. this is where the delay comes from. Once the query actually goes then the transaction finished very quickly. Below is the listed query, so hopefully someone can help advise why it is having to run it so many times, or how to reduce the retry time between them.
exec sp_executesql N'SET NOCOUNT OFF; INSERT INTO "storedatabase".."TransactionEntry" ("Commission","Cost","FullPrice","StoreID","TransactionNumber","ItemID","Price","PriceSource","Quantity","SalesRepID","Taxable","DetailID","Comment","DiscountReasonCodeID","ReturnReasonCodeID","TaxChangeReasonCodeID","SalesTax","QuantityDiscountID") VALUES (@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11,@P12,@P13,@P14,@P15,@P16,@P17,@P18); SELECT SCOPE_IDENTITY() AS SCOPE_ID_COLUMN',N'@P1 money,@P2 money,@P3 money,@P4 int,@P5 int,@P6 int,@P7 money,@P8 smallint,@P9 float,@P10 int,@P11 bit,@P12 int,@P13 nvarchar(1),@P14 int,@P15 int,@P16 int,@P17 money,@P18 int',$0.0000,$0.0000,$0.0000,20,526481,21299,$0.0000,1,1,0,1,0,N'',0,0,0,$0.0000,0
