I am working on an application it is used for tracking the employees utilization,and during performance testing we have find out that DB utilization is more in some scenarios.
Eg: generate the reports for unsubmitted tasks.
When executing the set of stored procedures involved in this scenario,separately it's performance is good. But when it runs from application, showing the db utilization is high. Could someone please help me to locate the exact issues,which is causing the this problem.
Thanks, Subheesh Paul