Microsoft CRM Dynamics 4.0 response times very slow

We have a small Microsoft CRM Dynamics 4.0 setup that is working as defined below - we have been experiencing alot of slow response times when users login and click thru the Sales module. Either when they go from account to account or when they got from an account to a contact - the response times have been between 30 seconds and sometimes up to a minute. I was not the person that configured the application or the servers so please bare with me - as I dont have much info to that end.

This is our current setup:

- about 30 users on the system
- users located in 2 different states
- CRM server/database are hosted "on-premise"
- CRM SQL server exists on a SQL clustered shared with about a dozen other applications
- Client machines, SQL server, and CRM serrver meet/exceed MS minimum requirements
- Email router is located on CRM server

The network lines between the server(s) and the offices have been checked and are working ok - with no errors.

The amount of data Accounts/Contacts we have on file is very small and should not be affecting the response times.

If I run a ping -t on the server during the "slow" response times I don't see any slowness or packet loss.

Wondering if there is something that maybe we could look at that we might have missed.

Thanks in advance for your help
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Chinmay PatelChief Technology NinjaCommented:
Hi tnnyabadza,

Are these users connecting via VPN? They are from the same domain or they are from different domains?

If they are from different domains, when they are prompted for their credentials when they try to access Internet Explorer just ask them to provide their credentials with
domainname\username and then password.

tnnyabadzaAuthor Commented:
Hi Chinmay - all the users are logging in on the same domain - some are located here (same office as me) others are in another office but we are all on the same network. Basically the users log into the domain when they first boot up - and from their Outlook there are no other logins required - as you know the Outlook plugin does not require a login after the initial setup BUT I will go back and change their setup to be specified as you have stated.

In my original question I forgot to also mention that we recently deployed the Rollup 21 upgrade with no issues.

Thanks for your help.
Feridun KadirPrincipal ConsultantCommented:
There are a lot of places to check.
1) Browser to CRM Server. When users click in the CRM web application, they are asking the web application to render data. So if you can compare browsing to another web applicaiton on the same server or network that may help identify bottlenecks or at least eliminate the server as being the issue.
2) CRM Server to SQL Server. To show views of records or display a form, CRM has to get data from the SQL Server. This raises lots of potential for slowness.
- How busy is the SQL Server?
- You say CRM is sharing with another dozen apps. How intensive are those apps? Does SQL have any memory, is disk contention an issue?
- Are the CRM and SQL servers on the same LAN or are they separated by routers? This could have a bearing on response times.
- The E-mail router isn't relevant to displaying information

3) How good is the Internet connection to the physical site that has the CRM server?
4) Are you able to test access by someone who is one the same physical network as the CRM server?

This isn't really an answer but I hope it gives you some more places to look into.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
tnnyabadzaAuthor Commented:
Feridun - thank you - at this point I will cross check everything suggested. The SQL server cluster is definately an area "of interest" as it's fairly busy and some of the applications hitting that server are pretty intense.
tnnyabadzaAuthor Commented:
Thanks to you both - at this point we are going to be upgrading to the new 2011 platform so . . . will keep you posted. Thank you again.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Dynamics

From novice to tech pro — start learning today.