Given the diverse roles and deep domain & technical expertise, Smartstatz provides the right blend of skills required to make client projects successful and investments relevant.



+ 91 9833458129

304, Punit Chambers, Sector 18, Vashi , Navi Mumbai – 400705

Case Studies

Microsoft Dynamics CRM on-premise Support and Enhancements for a Business Broadband service provider

Company Overview

The company operates as an Internet services provider that offers fiber optic broadband and cloud-based services for residential and business users. The Company provides cable and wireless broadband solutions, voice over Internet protocol, connectivity, datacenter, voice, collaboration and security solutions.

Client Requirement

The client is using D365 CE on-premise and was facing significant performance issues. The issues were primarily due to the database performance due to which key services such as automated emails and ticket creation were severely impacted

Solution Environment

Microsoft Dynamics 365 Customer Engagement on-premise

Team Size
  • 2
Project Summary

In order to enhance the performance, a highly competent consultant with over 18 years of experience was engaged to review the database performance and the resulting CRM performance issues. The following key steps were performed:

  • Database optimization
  • Creation of a secondary database for reporting purposes
  • Automatic synchronization between the primary and reporting database
  • Optimization of CRM forms and workflows
  • Users are able to create transactions which were failing earlier
  • Emails getting delivered as required
  • 60% improvement in response times due to the segregation of reporting database