Symptoms

Smartforms, when loading list views regardless of data source, takes over 15 seconds to render the form and return data.
 

Diagnoses

In troubleshooting, we captured a fiddler trace and noticed an abnormally long call to AjaxCall.ashx, which is a web service that returns XML formatted smartobject data. We then tested the smartobject service tester on the same smartobject, and saw no delay in returning data.



 

Resolution 

Customers SQL admin team noticed a script that was running on the SQL server consuming an undue amount of resources. Once this script was stopped, the performance improved.