Albert Widjaja
asked on
SQL Transaction Performance Issue
Guys,
I am currently facing SQL transaction performance issue (on execution) and unable to trace what causing it.
In the SQL Profiler, I can see that one of the SQL Stored Proc take about 7-8 minutes to complete (which is not good).
Can someone please direct me on how I can/should dig deeper to find what causing the bottleneck? What metrics/parameters should i look at?
Cheers
I am currently facing SQL transaction performance issue (on execution) and unable to trace what causing it.
In the SQL Profiler, I can see that one of the SQL Stored Proc take about 7-8 minutes to complete (which is not good).
Can someone please direct me on how I can/should dig deeper to find what causing the bottleneck? What metrics/parameters should i look at?
Cheers
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER