If you have installed Iguana 4.0 or any later version and your channel is interacting with an SQL database and you notice that the database is experiencing performance issues, you can use the Iguana logs to track the performance of your database.

To track your SQL database performance, set the logging level for your channel to Debug by following the instructions described in Changing the Logging Level. When the logging level is set to Debug, the SQL statements that are sent to the database will show up as Debug entries in the Iguana log files.

Because each entry in the Iguana log files has a time stamp, you can determine the amount of time needed to execute an SQL statement. To do this, examine the time stamp for the statement and then examine the time stamp for the next SQL statement in the log. The difference between the two time stamps will give you an estimate of the time required for this particular SQL statement to execute.

	For information on using and viewing logs in Iguana, see Working With the Logs.