Question Status

Suggested Answer
OrdinaryGal asked a question on 31 Oct 2013 1:54 AM

Hi,

We use CRM 4.0 and and SQL Server 2005 for a many year. Recently memory  hight to 96% and  what should i do for resolve this problem. Please help and suggestion. Thank you in advance

Reply
Suggested Answer
Joshua Thompson - McGladrey responded on 31 Oct 2013 9:00 AM

Is this on the SQL box or the CRM front end server? For SQL, memory utilization will be high unless you specifically limit the max memory SQL can consume. Otherwise SQL is inclined to use it up as it needs it and will keep it. This is by design and is expected behavior.

That being said, I would suggest making sure you have maintenance plans in place for updating statistics, reorganizing/rebuilding indexes etc as these can all have negative impact on memory utilization. These would be more performance centric than a utilization percentage though. A high number doesn't = bad so if performance is good, I wouldn't really worry about it.

Are there any new jobs on that server? SSIS, maintenance or otherwise? Any new reports recently  built?

Now if you start to see CPU util staying up over 80% then you have some other issues you need to look at.

 Joshua Thompson
 Sr. Associate - Technology Services

  Follow me on Twitter My LinkedIn Profile

Reply
Suggested Answer
Rajesh Ravindran responded on 31 Oct 2013 4:03 PM

Hi,

Refer to these articles for more help:

www.microsoft.com/.../details.aspx

support.microsoft.com/.../968520

Regards,

Rajesh R.

Reply
Marco Di Lorenzo responded on 31 Oct 2013 2:01 AM

Hi Chuthamas,

there could be many causes for this problem... the first thought... have you installed the lastest update rollup?

Bye

Thank you, let me know please.


Marco - LinkedIn

Reply
OrdinaryGal responded on 31 Oct 2013 2:45 AM

Already rollup 21

Reply
Suggested Answer
Joshua Thompson - McGladrey responded on 31 Oct 2013 9:00 AM

Is this on the SQL box or the CRM front end server? For SQL, memory utilization will be high unless you specifically limit the max memory SQL can consume. Otherwise SQL is inclined to use it up as it needs it and will keep it. This is by design and is expected behavior.

That being said, I would suggest making sure you have maintenance plans in place for updating statistics, reorganizing/rebuilding indexes etc as these can all have negative impact on memory utilization. These would be more performance centric than a utilization percentage though. A high number doesn't = bad so if performance is good, I wouldn't really worry about it.

Are there any new jobs on that server? SSIS, maintenance or otherwise? Any new reports recently  built?

Now if you start to see CPU util staying up over 80% then you have some other issues you need to look at.

 Joshua Thompson
 Sr. Associate - Technology Services

  Follow me on Twitter My LinkedIn Profile

Reply
Marco Di Lorenzo responded on 31 Oct 2013 9:23 AM

Hi,

have you checked if there are some process "blocked" or "waiting" in Settings-->System Process? (Use the default view in the CRM filter).

Let me know.

Thanks

Bye

Thank you, let me know please.


Marco - LinkedIn

Reply
Suggested Answer
Rajesh Ravindran responded on 31 Oct 2013 4:03 PM

Hi,

Refer to these articles for more help:

www.microsoft.com/.../details.aspx

support.microsoft.com/.../968520

Regards,

Rajesh R.

Reply
OrdinaryGal responded on 31 Oct 2013 8:21 PM

Thanks for the info. I have run the script in the first of this year. Please let me how often to run this script ?

Reply
OrdinaryGal responded on 31 Oct 2013 8:23 PM

Hi Marco,

Some waiting for some reason. Less than succeed process. Thank you for the help

Reply
OrdinaryGal responded on 31 Oct 2013 8:33 PM

Hi Josh,

This is CRM front end server. We have made the VM for this server and allocation all resourses for matched requirement for CRM Application. Then, setting for the percent available memory below the waring limit 0f 4%.

For the SSIS report i have a lot of report on this and a lot of user to use it  from distance. It would be to tuning or upgrade to 2012 version of SQL?  Thank you in advance.

Reply
AFTAB HUSSAIN responded on 2 Nov 2013 6:13 PM

Hello,

There are few things that need to be taken care off.

Clear all the workflows that are not in use or required. If there any workflows that run multiple times, please avoid if not required.

Check if you have any system jobs in locked state.

Steps :

---------

a. Click Advanced Find.

b. Set the Look For to System Jobs.

c. Specify the following criteria:  Status > Equals > Locked

Please find below some key points.

- Have the latest update rollup installed for CRM 4.0 server

- If we have lot of completed system jobs that are not required then please get rid of them.

- Refer the link - support.microsoft.com/.../968520

Are you facing any performance issues too due this?

If yes then refer the links below

support.microsoft.com/.../968755

There can be lot of workflows that are running due to which this problem can occur. Refer the link below.

support.microsoft.com/.../957871

You can also  refer the links below for more help and information

support.microsoft.com/.../2489162

CRM 4.0 Performance White Papers  - www.microsoft.com/.../details.aspx

I hope these will help

Thank You !

Reply
Priyadarshi Purwar responded on 3 Nov 2013 1:43 AM

Which service is using maximum memory , identify it and troubleshoot.

Reply