Microsoft CRM support and maintenance for a small business

Microsoft CRM support and maintenance for a small business

Does Microsoft Dynamics CRM require a lot of support and maintenance? We're a small company of about 20 people, without a dedicated person to manage our CRM system. How time-consuming is the maintenance of Microsoft CRM? Should this be the sales manager's responsibility?

    Requires Free Membership to View

    When you register, you'll begin receiving targeted emails from my team of award-winning editorial writers on the latest customer relationship management (CRM)and call center technology issues today. Our goal is to keep you informed on the hottest issues facing this fast-changing industry.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchCRM.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchCRM.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

This is a common question we hear, as many businesses cannot dedicate a resource to maintaining and supporting their CRM solution. There is not one answer to the question, however, because "maintenance" encompasses a multitude of tasks. These tasks can be broken down into three areas:
  • Server maintenance: There are ongoing tasks that should be performed on a regular, if not daily basis, like backing up the CRM databases and optimizing the database indexes. These tasks are typically performed by an internal or external (outsourced) IT specialist.
  • Ongoing business changes: The more common needs our users experience is the need to make changes to CRM to reflect changes in the business. This might include adding new values to a drop-down field, adding new fields to a form, making a field required, updating sales rep quotas and adding new reps and even creating a new Excel report. Microsoft provides the tools to make these types of changes quickly and easily within Dynamics CRM. While it may not be the best use of the sales manager's time, most of our clients have been able to identify a "super user" who is able to become comfortable with these tasks and who can manage them for the organization. The "super user" can also be a great go-to person for training and questions about using CRM.
  • Enhancements and upgrades: From time to time, your organization may wish to implement more sophisticated changes including an upgrade, new more complex reporting, integration with your enterprise resource planning (ERP) or financials system and the like. Most organizations opt to bring in a qualified Microsoft partner to help them with this type of work.
With this in mind, CRM support and maintenance -- for Microsoft CRM or any other CRM system -- does not have to be a time-consuming task and does not necessarily require a dedicated resource. As a good rule of thumb, you should estimate that your IT resource will need approximately half an hour to one hour each week to ensure that the SQL Server backup and maintenance jobs are executing properly and between one and two hours on average each week for an internal resource to make changes to the system, answer questions and train new users.

This was first published in August 2007