28 กุมภาพันธ์ 2555 4:43
Hello MDS Guys,
We are experiencing performance issues while trying to access MDM web portal. The main activity is browing through derived Hierarchy and Entity data from Explorer tab.
I tried to trace logs and profile sql server but its seems SQl is pretty stable.
I have established baseline for MDM response as 60 sec in my project.But right now its overshooting this and we are getting response in 70-120 sec.
Any trick/tips how to increase MDM performance? or where is bottleneck?
I wanted to know if anybody else is facing the same issue?
Any idea on tools/approach which can help identify the issue ??
Appreciate all suggestions!
28 กุมภาพันธ์ 2555 17:05
The 2008 R2 version generally has a slow Web UI which is mainly due to the UI itself. The 2012 version is orders of magnitude better. If you experience a deteriation in performance it can be due to a lack of DB maintenance and cleanup. Here's our blog on the subject.