Machines are "intelligent" as well Microsoft CRM Dynamics and they manage the resources very well especially the last versions of Microsoft CRM Dynamics like 2016, however we need sometimes to give a boost on our CRM on-premise.
So one of the things is related to the CPU utilization by a certain Organization.
So we should look at some fragmented indexes and make sure we clean the house, therefore here follows a way to index that was used and drop the CPU rate for better values.
USE [Contoso_MSCRM] GO CREATE NONCLUSTERED INDEX [fndx_StateCode_OverwriteTime_ComponentState] ON [dbo].[SdkMessageProcessingStepBase]( [StateCode] ASC, [OverwriteTime] ASC, [ComponentState] ASC)INCLUDE ( [PluginTypeId], [SdkMessageId], [SdkMessageFilterId]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) GO