Experiencing poor syndication service performance in MDM SP06
I have installed MDM SP06 on our test server and have had to switch our syndications from using the syndication manager batch utility to using the syndication service.
These syndications all have the "suppress unchanged records" option selected (checked) so that we only send recently inserted/updated records.
I have found that when no records have been updated, the syndication service seems to be invoking SQL Server repeatedly nd frequently and between MDSS and MSSQL, they pretty much keep our CPU busy most of the time.
However, if I touch one or more rows, the perfromance, for the run immediately following seems to improve.
I notice similar behavior in Syndication Manager. If no rows have been updated, syndication manager just runs and runs when I execute the syndication. But if I touch one or more rows, then it executes the syndication in a reasonable time.
Does anyone have any ideas as to what I might be doing wrong, or may have missed when installing/configuring 5.6?
The repository in question is not particularyn bik -- there are about 67K vendor records on the main table.
Thank you for any assistance or ideas,
Edited by: Vince Moore on Oct 7, 2008 10:40 PM