Asked by:
sql server 2008 r2 process monitor 100%

Question
-
I have a terrible problem with SQL server 2008 R2,need to help...
MS CRM2011 installed on HP SERVER x5550(16GB ram) and database(SQL SERVER 2008 R2) on HP SERVER x5660(28GB ram)
with over than 500 user ,today's sql server process time is upper than 95% and MS CRM is so slow and hang ,by theway sql server never use more
than 14GB of memory(ram) ,what can I do?
Wednesday, March 27, 2013 12:04 PM
All replies
-
try to find why SQL is so CPU-hungry using basic diagnostic :
http://msdn.microsoft.com/en-us/library/ms175518.aspx
Wednesday, March 27, 2013 2:18 PM -
One of the things you can try is setting the Max Degree of Parallelism on the SQL instance to be 1. By default it is set to 0 and generally CRM plays better with this setting.
Rojy Thomas
Wednesday, March 27, 2013 4:41 PM -
sql server memory tabel is below is there any thing wrong?
Column nameData type CRM DATABASE physical_memory_in_use_kb bigint 1000284 large_page_allocations_kb bigint 0 locked_page_allocations_kb bigint 0 total_virtual_address_space_kb bigint 8589934464 virtual_address_space_reserved_kb bigint 29891884 virtual_address_space_committed_kb bigint 1200644 page_fault_count bigint 264613 memory_utilization_percentage int 100 available_commit_limit_kb bigint 45412872 process_physical_memory_low bit 0 process_virtual_memory_low bit 0 Saturday, April 6, 2013 9:33 PM -
Usually expect SQL Server to use a lot of memory, as it's a very memory intensive DBMS.
You said CRM is hanging (With 500 users), do you only use one CRM box? (With all the services on the same box? E.g. sandbox, async) - This is likely to cause the issue if everything is in one place.
Recommendation would be to start splitting off services and adding new boxes then monitoring performance instead of going straight to SQL.
-
Tuesday, April 9, 2013 9:38 AM -
Hi K1,
Due to Microsoft documentations, if you have separate Database and application servers you have to assign 16GB to your DB and 8GB of memory to your application server. These recommendations are for 320 users. Hence, when your organization have about 500 users, it is obvious that your server lacks memory. On the other hand SQL is known as a memory using DB. I think you have to improve your server requirements.
If the answer helped you, remember to mark it as answer.
My Weblog -- My Website -- My FacebookSunday, April 14, 2013 1:23 PMModerator