I need some tips and tricks about how to troubleshoot the performance of SD(SP14) and hope you can help me out. I know about the /benchmark parameter and the java memory settings are also clear to me., but I know there should be a possibility of tracing the statements to the database. And if you’ve got any other tips and tricks please let me know!
We've always traced database statements through the database itself because I'm not aware of any way to cpature the SQL being sent to the database through the applicaiton server. That function would be helpful.
When you say troubleshoot, do you mean the client performance or the application performance?