will crm be slow if I have lot of data

(0) Share

Report

Posted on by New Crm learner

Hello all,

I am about to use dynamic crm 2015 onpremise and wondering if CRM will be slow if we have a lot of data ( more than 8 GB in server).

will the lot of data slow up my CRM?

Thanks

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Tim Dutcher 2,100 on at

Like (1)

Report

RE: will crm be slow if I have lot of data

I've worked with on-prem CRM systems where the database was a lot larger than 8 GB and they ran fine.

The database size itself won't cause CRM to slow down. Your focus should be on making sure all custom code written for the system runs as efficiently as possible and that you or your DBA work on tuning the database, such as adding indexes where needed based on query analysis.

Was this reply helpful? Yes No
Suggested answer

razdynamics 17,308 User Group Leader on at

Like (2)

Report

RE: will crm be slow if I have lot of data

Hi your data wont slow down your crm however you need to be carefull how many objects you expose on your form such as fields, javascripts and operations at any given time. If you have a form overpopulated that is being generated by all users who are trying to make changes this could potentially slow down due to the number of blocking and locking transactions that are occurring. So you need to reduce this by designing your forms to only show what they need to show and have dedicated forms for different departments. Also ensure your custom code and plugins does not add bottlenecks to your processes, and reduce the number of webresources running on each form by consolidating them.

Best Wishes, Raz

Was this reply helpful? Yes No
Suggested answer

Nick.Doelman 1,947 Most Valuable Professional on at

Like (2)

Report

RE: will crm be slow if I have lot of data

We have customers with 100GB+ databases. Keeping customizations efficient is key. Also make sure your backend (SQL, CRM Server roles) are setup to accommodate your volume. (E.g. are you transacting a lot of data or just storing it?) There are various SQL tuning techniques to ensure your system runs smoothly.

Microsoft provides some good info here:

https://technet.microsoft.com/en-us/library/hh699750.aspx

Cheers
Nick

Was this reply helpful? Yes No
Suggested answer

Kishor Kumar 3,710 on at

Like (0)

Report

RE: will crm be slow if I have lot of data

Hi ,

Mostly CRM will not get slow due to data increase, Check this link

blog.craigharvey.me/.../dynamics-crm-performance-troubleshooting

Was this reply helpful? Yes No