Now that we are running in larger data centers with the power of Microsoft Azure and with hardware technology such as solid state storage (moving away from the limitations of rotating platters) we all want to take a deep breath and make a sigh of performance joy.
Unfortunately when you eliminate one bottleneck the data moves to the next. Additionally bottlenecks are not just hardware.
Consider a rock wall layered in a stream of water, you remove the rocks blocking the water, and the water rushes to the next barrier. The same concept applies to data.
If you are working with millions or hundreds of thousands of data records you might want to consider:
- Performance Tune the Microsoft SQL Server Database (SQL Server gurus can appreciate this one!)
- Adding MS SQL Server Indexes to your largest Entities.
- Consider Latency (Microsoft now offers data center distributed processing for their Worldwide Dynamics Customers, reducing the trips across the oceans)
- Understand if you have a bottleneck and where it is (Dynamics actually ships with a Diagnostic tool to check latency and bandwidth: Use https://[your crm url]/tools/diagnostics/diag.aspx
- If you are hosting your own environment, you can also tap into the Microsoft Professional Field Engineering teams Performance Analysis and Tuning Services (the PFE Sustainability Engineers Rock) or
- you might consider a powerful tool such as ThousandEyes: https://blog.thousandeyes.com/monitor-dynamics-crm-performance/ and https://www.thousandeyes.com/solutions/dynamics-365-monitoring
What are your favorite tips and tricks for performance?
Oh and as a last note .. there are customers processing 100,000s of data records a DAY with the Microsoft Dynamics platform. The power is incredible with a little love.