PENDING sms_collection_evaluator component error

[syed sameer]

HI Prajwal

I am getting sms_collection_evaluator error as below

Severity Type Site code Date / Time System Component Message ID Description
Error Milestone JS5 10/12/2018 2:52:19 PM xxxxxxx.AD (servername hidden) SMS_COLLECTION_EVALUATOR 620 Microsoft SQL Server reported SQL message 6532, severity 16: [42000][6532][Microsoft][SQL Server Native Client 11.0][SQL Server].NET Framework execution was aborted by escalation policy because of out of memory. : fn_rbac_CM_RES_COLL_PH50003C Please refer to your Configuration Manager documentation, SQL Server documentation, or the Microsoft Knowledge Base for further troubleshooting information.

 

[syed sameer]

HI Prajwal

I am getting sms_collection_evaluator error as below

Severity Type Site code Date / Time System Component Message ID Description
Error Milestone JS5 10/12/2018 2:52:19 PM xxxxxxx.AD (servername hidden) SMS_COLLECTION_EVALUATOR 620 Microsoft SQL Server reported SQL message 6532, severity 16: [42000][6532][Microsoft][SQL Server Native Client 11.0][SQL Server].NET Framework execution was aborted by escalation policy because of out of memory. : fn_rbac_CM_RES_COLL_PH50003C Please refer to your Configuration Manager documentation, SQL Server documentation, or the Microsoft Knowledge Base for further troubleshooting information.

 

[syed sameer]

Hi Prajwal can u help me on this

 

[Garth]

The error message above say you are out of memory. This is not directly a CM issue it is a server issue.

 

[Prajwal Desai]

".NET Framework execution was aborted by escalation policy because of out of memory" Looks like most of the memory on your server is consumed by SQL server. How much memory do you have on site server and do you have SQL and SCCM running on same machine ?. Try adding more memory to the server and limit SQL RAM usage as we know SQL default uses lot of memory for its tasks.

 

[syed sameer]

We have 16 GB ram on the server and SQL and sccm running on the same server , do I need to set anything under sql studio mgmt memory option like minimum and maximum if yes how much I should set?

 

[Prajwal Desai]

That's correct.

 

[Garth]

We have 16 GB ram on the server and SQL and sccm running on the same server , do I need to set anything under sql studio mgmt memory option like minimum and maximum if yes how much I should set?

16 GB, is lite on RAM. I have 24 GB for my lab of 40 computers.

Yes you should set the max ram within SQL. Otherwise SQL will starve the OS of RAM.