Sunday 29 June 2014

Analyzing an expensive SQL statement

 Analyzing an expensive SQL statement

Statistical records → high database request time
SQL Trace → statements with long response times
Stored procedure name cache statistics → high execution times
 Process overview → report and table name
 Where used list → table

No comments:

Post a Comment