CRM 2011 server sloooooooow?

Have you checked you SQL memory usage? Do you have several applications running against the same SQL server? Are you using SQL 2008? well, then you realy should check the following:

• What kind of settings are set for memory usage for each application instance in the SQL?

g.ex: you're using SharePoint and CRM on the same SQL server, and total have 8GB memory on the SQL server.(This does NOT inc the CRM server and SharePoint server).

What should I think of?
- Number of users at once on each application.
- The requirements and usage of each application
- +++ other factors

Good rules: (This is ONLY an example. It's almost imposseble to say what's good for your enviorment)

1. Always let the OS have some memory. (Let's say 1,5GB) - 6,5GB left
2. Calculate how much memory to give CRM and SharePoint (in this case)
• Rember to think of application usage and number of users online at same time.
• NOTE (Often the memory usage get's Multiplyed with ca 1,5 from the max if server gets stressed)
• God practis is operating with 1024MB, so if we want 2GB we give 2048MB memory
• Let's say we give the CRM server 3072MB and SharePoint 3072MB
• (Do not foreget the 1,5 factor!!)
3. Set the max and min Memory for each application instance in SQL:
1. Go to: SQL Manager > The SQL instance > Properties > memory
2. (Make sure services and no users are using system)

(How to find memory setings pr SQL application instance)

If your setings are setup like this: You should consider changing the SQL memory settings. Default "Next, next, next install setings"!

(How to "eat" all memory on SQL. hehe...)

Adjust the max and min memory usage as calculated

(How to adjust the memory)

This is what happend when the memory is adjusted:

(SQL response faster, and memory usage lower)

Again, this is an example you'll have to figure out the correct numbers and settings yourself based on enviorment and numbers of users! Tip: If you use virtual SQL server; check your networkcard setings for TCP/IP aswell! ;)

Hope this gives you some tips on how to get faster response from SQL to Your CRM 2011!