Is Dynamics 365 Server-Side Sync filling up your database?

Our PFE colleague in Norway Ritesh Ranjan recently published the following article on his blog. We are cross-posting here for your reading pleasure! Well, if you are wondering, looking at the TraceLogBase table size, that there is a problem with the Dynamics CRM Server-Side Sync, then I would say ‘NO’. There is no problem with…


Dynamics CRM indexes (missing, redundant, and OOB)

It is a fact that Dynamics CRM is an OLTP application, and that it’s performance relies heavily on how well the back end database (SQL server) is performing.  A major component in the performance matrix is indexes.  They have to be well defragmented, you should have the needed indexes to optimize query performance (missing indexes),…

2

Memory management for Dynamics CRM in a virtual environment – Part 2

After publishing the blog Memory management for Dynamics CRM in a virtual environment we received a lot of questions basically asking for more details, we will provide more information in this blog. One of the primary reason for doing virtualization is consolidation. Every Virtualization deployment is different from Hypervisor version to hardware and currently existing…

0

Performance Tuning with Email Tagging

One of our customers is adding many new users to Dynamics CRM system almost every month. As the number of CRM users increased, they are starting to see more alerts from their load balancer F5 indicates that IIS is not responding.  After some investigation, it appears the issues are related to requests that have been…


Customers’ choices… The most popular "Dynamics CRM in the Field" technical blog posts from Premier Field Engineering!

The CRM Premier Field Engineering content team feel customers can benefit from knowing what technical content we have provided that has been most popular with customers; ranked by number of page views. We included the top 10 posts for each of the last three years to cover all of the Microsoft Dynamics CRM versions still…

1

PFE Dynamics @ Convergence 2015

For those attending Convergence 2015 in Atlanta, GA next week, I wanted to let you know that we will have members of the PFE Dynamics team there presenting some great content.  In addition, make sure to follow @PFEDynamics on Twitter to get updates on other PFE Dynamics activities at Convergence.  Below is a list of…

4

Memory management for Dynamics CRM in a virtual environment

We have been engaged with a customer to do a performance review, and they had no apparent issues of performance.  We set up performance counters on all machines and they were all within threshold. However the backend role machine showed interesting behavior. It had “Available memory” within threshold while “pages/ sec” far above threshold, other…

5

The Dangers of Guid.NewGuid();

Microsoft Dynamics CRM uses GUIDs as their primary key for the entity’s SQL table.  Using GUIDs as a primary key is usually not the best item due the random sequence of numbers and letters.  The Dynamics platform has an algorithm that generates GUIDs in sequential order.  This special GUID enables the SQL Server to index…


Static Content not cached properly in Dynamics CRM due to Vary:* header

Recently I have worked on a few different performance cases where the customer was either seeing slow form load performance or noticed high bandwidth usage. To see what was happening I gathered a fiddler trace and looked at the traffic. When gathering a fiddler trace I always open the form twice in a row to…

6

Table Bloat Due to Workflow Log Entries

One of the more common customer issues that has been coming up often lately is table bloat due to a large volume of completed or canceled workflow entries in the organization. There are three main tables that are impacted by this workflow history retention: AsyncOperationBase PrincipalObjectAccess (POA) WorkflowLogBase Let’s start with a quick background on…

5