Hi All
Does Microsoft Dynamic RMS Headquaters Server allow install on multi PC but same database?
Thank You
*This post is locked for comments
Yes
Do you have any idea why the headquater server will hang?
now my headquater server keep hang.
when i check sp_who2 i can see HQ Server A will lock HQ Server B. later i upload more Information.
Now i found the problem
problem is this trigger.
My ItemDynamic Table very Huge. if everytime update this ItemDynamic Table it trigger this will cause all system hang.
does anyone know can i disable it?
CREATE TRIGGER [dbo].[tr_ItemStoreQty]
ON [dbo].[ItemDynamic] FOR UPDATE, INSERT, DELETE AS
/* Updates Quantity and QuantityCommitted in Item table when changes are made to the ItemDynamic table */
DECLARE @Rows INT
SELECT @Rows = @@ROWCOUNT
IF @Rows = 0
/* No rows inserted or deleted, exit trigger */
RETURN
/* Update the Quantity and QuantityCommitted fields in ItemDynamic table */
SELECT ItemDynamic.ItemID,
SUM(ItemDynamic.Quantity) AS Quantity,
SUM(ItemDynamic.QuantityCommitted) AS QuantityCommitted
INTO #tr_Temp
FROM ItemDynamic
WHERE ItemDynamic.ItemID IN
(
SELECT ItemID
FROM INSERTED
UNION
FROM DELETED
)
GROUP BY ItemDynamic.ItemID
UPDATE Item
SET Quantity = #tr_Temp.Quantity,
QuantityCommitted = #Tr_temp.QuantityCommitted
FROM Item, #tr_Temp
WHERE Item.ID = #tr_Temp.ItemID
GO
What version of RMS? There were some new indexes created in Hotfix 2.0.1003 that you might look at/install. These will be included in SP5 that is to be released soon, we're told. Don't know too much about them as of right now.
mbs.microsoft.com/.../SQL_Scripts_for_HF_2791653.zip
Hi NG,
We are having 97172293 records in item dynamic table and we don't face such issues. You should never remove tigers in HQ tables unless MS advice to do so. As you can see in this tigger, it does update item table. As jef said, they added index in item dynamic in FP2 to increase the 401 data transfer performance . I'm not sure what version your client in. You may check the following to start troubleshooting the issue
> Network connectivity speed between store and HQ.
> Number of item getting upload to HQ daily
> Worksheet connection schedule
Possible Solutions
> Increase the number of HQ server applications . This can be done in same server if you have a high end one
> Change the schedule to connect to HQ server application not more than 2 shops at a time. If you have 6 HQ
server application, then make 2 shops connect to one HQ application at a time. Keep at least 20 min gap for
next connectivity. (Again this depend on the connectivity speed between HQ-Store
> If your client having slow connectivity, do recommend to update the the link speed.
Hope this will help
Regards
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
