locked
sql server 2008 r2 process monitor 100% RRS feed

  • 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 name
    Data 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
    Note
    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 Facebook

    Sunday, April 14, 2013 1:23 PM
    Moderator