Previous month:
February 2019
Next month:
April 2019

Do you know where your bottleneck is? Microsoft Dynamics 365 for CE

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.
  • Watching out or reviewing JavaScript (JavaScript is a language that allows developers to inadvertently and easily create application bottlenecks) Luckily OOB Dynamics 365 has been deeply tested for bottlenecks continuously over the years and has continued to pass with flying colors.
  • 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.

 

 

 

 


Microsoft Dynamics 365 for Customer Engagement - Search

The following table provides a brief comparison of the four available search options in Microsoft Dynamics 365 for CE. Microsoft often provides many options for achieving the same goal (just look at all you can do with Outlook!)

The link to this information and to read more https://docs.microsoft.com/en-us/dynamics365/customer-engagement/basics/search-and-find-header

Functionality

Relevance Search (Online Only, the power of Azure)

Full-text Quick Find (also called Categorized Search)

Quick Find

Advanced Find

Enabled by default?

No. An administrator must manually enable it under system settings.

No. An administrator must manually enable it under system settings.

Yes

Yes

Single-entity search scope

Not available in an entity grid. You can filter the search results by an entity on the results page.

Available in an entity grid.

Available in an entity grid.

Available in an entity grid.

Multi-entity search scope

There is no maximum limit on the number of entities you can search. Note: While there is no maximum limit on the number of entities you can search, the Record Type filter shows data for only 10 entities.

Searches up to 10 entities, grouped by an entity.

Searches up to 10 entities, grouped by an entity.

Multi-entity search not available.

Search behavior

Finds matches to any word in the search term in any field in the entity.

Finds matches to all words in the search term in one field in an entity; however, the words can be matched in any order in the field.

Finds matches as in a SQL query with “Like” clauses. You have to use the wildcard characters in the search term to search within a string. All matches must be an exact match to the search term.

Query builder where you can define search criteria for the selected record type. Can also be used to prepare data for export to Office Excel so that you analyze, summarize, or aggregate data, or create PivotTables to view your data from different perspectives.

Searchable fields

Text fields like Single Line of Text, Multiple Lines of Text, Lookups, and Option Sets. Doesn't support searching in fields of Numeric or Date data type.

All searchable fields.

All searchable fields.

All searchable fields.

Search results

Returns the search results in order of their relevance, in a single list.

For single-entity, returns the search results in an entity grid. For multi-entity, returns the search results grouped by categories, such as accounts, contacts, or leads.

For single-entity, returns the search results in an entity grid. For multi-entity, returns the search results grouped by categories, such as accounts, contacts, or leads.

Returns search results of the selected record type with the columns you have specified, in the sort order you have configured.

Wildcards (*)

Trailing wildcard supported for word completion.

Leading wildcard supported. Trailing wildcard added by default.

Leading wildcard supported. Trailing wildcard added by default.

Not supported.

 


Microsoft Dynamics 365 Portals with the awesome, unicorn loving, Colin and the incredible, Griffin loving, Robert Bailey

Tips and Thoughts

1) Is it the right technology for the need?

2) Have a solid design and a long term iteration and maintenance plan

3) Never forget about the customers, customer who might be using the portal.

4) Consider Identity and Authentication for the customers, customer, but also for portal versus Dynamics 365. 

5) Golden Keys: The right development team, the right methodology, the right relationships with the customers/users and their continued involving involvement. 

6) Graphics and Web Design are part of portal projects, pictures can communicate 1000 of the wrong words. 

7) Bring Joy

8) If Multilingual is a need, do it as part of PHASE I. It is harder to  add additional languages in later phases. 

 


Dynamics CRMUG FOCUS - Houston - Cracking open the brain with reminders and new tips shared.

The power of the user group is that listening to peers, experts, partners, consultants, business users, financial advisors and so many more, opens the mind to interesting ideas. 

CRM USER GROUP - FOCUS - in HOUSTON

9:49am and here are the first few tips 

1) Have you considered holding your sales team to task by using SLAs on LEADS, measuring when the lead was first contacted or when a lead reached a key milestone in the qualification stage? 

2) GOALS, so under appreciated and yet so powerful. Add goals in unique and creative ways to take full advantage of the complex hierarchy offered from this little feature. 

3) Task Flows : Originally for Mobile Only, but now embedded across the new UI. Take for instance OOB Follow-up to a meeting. A sexy dialog. 

4) DOCK your business process flow on the right side of your form so you can see the fields. Always learning, this is a cool one, although I thought a TAB approach might be useful as well. Some people like that old style form view. 

5) Did you know you can use an Out of the Box action to move a business process flow to the next stage automatically (so your user doesn't have to press next)? 

6) Has your partner added an APP or APPS to your configuration? If not, you are missing out.


Microsoft R&D guru's (The team you didn't know about that will change your experience with delivery)

Microsoft R&D guru's Grant Geiszler, Daren Turner, and Mike Huguet moved from guru/guru premier field engineers to an internal R&D team and have been working really hard for the last couple of years on a new toolset which provides automated UI testing, stability & performance checks on Microsoft Dynamics 365 solutions and instances. 

Catch the details at the Microsoft Dynamics 365 User Group Focus event in Houston March 11-12th at these sessions https://goo.gl/qYG8H8 & https://goo.gl/vFUuDV at hashtagUGFocus2019 .

To Register or to Learn More

https://www.ugfocus.com/focus/locations/houston