Bad OM Performance because State Change Events are not groomed out

IMPORTANT: Always perform a FULL Backup of the database before doing anything to it !!! ALSO: It is advised that you open a case at Microsoft before doing this – directly editing the database is not supported and you may find yourself in an unsupported state if anything goes wrong.   So I have encountered…

0

Service Manager slow perfomance

PLEASE WATCH: https://channel9.msdn.com/Events/MMS/2013/SD-B312   A lot of Service Manager environments (2010 or 2012) suffer from bad performance because of to many entity changes. Let me explain how this works: To best explain, we will take an out of the box relationship: System.WorkItemAffectedUser <RelationshipType id=”System.WorkItemAffectedUser” accessibility=”Public” abstract=”false” base=”System!System.Reference”>   <Source id=”IsCreatedForUser” MinCardinality=”0″ MaxCardinality=”2147483647″ type=”System.WorkItem” />   <Target id=”RequestedWorkItem” MinCardinality=”0″ MaxCardinality=”1″ type=”System!System.User” /></RelationshipType>…

1