AnsweredAssumed Answered

database server ram utilization is going very high 98% constantly

Question asked by dheeraj_k2 on Dec 19, 2016
Latest reply on Dec 19, 2016 by Paul_Coccimiglio

Hello guys,

We are using SDM r12.5 and database sql 2005 on database server.
Main Issue is that
1) My database server ram utilization is going very high 98% constantly so this make SDM is very slow during business hours and my database size more than 350 gb.
2) when we are uploading bulk assets data on ca_owned_resource table its taking so much time.
please provide any solution for these two things.
---------------------------------------------------------------------------------------------------------------------------
can purge and archive method in sdm help me for compressing 350 gb database size. how we shirk this database size.

Outcomes