Use this section to configure

• debug features for the cluster.

Debug

This tab provides several debug options. 

1. On the ScaleArc dashboard, locate the Status column and click Cluster Settings.
   
   
   
   Click on the Debug tab. 
   
   
   
   
   Configure the fields as follows: 

   Field	Description	User input
   Unresponsive server timeout	The maximum time (in seconds) to wait for a response from a server before the server is deemed unresponsive and results in a error for the client. This setting limits query execution time. It can also serve as a troubleshooting tool to determine if ScaleArc has caused an application issue.	Default value is 600 seconds.
   All Connections Pass-through	For use in customer evaluations where ScaleArc does not support the protocol.	Turn ON to enable a complete passthrough.
   Maximum Query Packet Size (bytes)	Specifies the maximum size of the query beyond which the query goes into passthrough mode.	Default is 10240 bytes.
   Ignore Server response Time	When enabled, ScaleArc ignores the response time of DB server from the dynamic load balancing calculations.	Turn ON/OFF.
   Ignore Server Max Connections	When enabled, ScaleArc ignores the max server connection limit settings of DB server from the dynamic load balancing calculations.	Turn ON/OFF.
   Ignore Weight based load balancing	Used to enable/disable the feature which allows you to include user-specified database weights so as to bias dynamic load balancing's load calculations.	Turn ON/OFF.
   TCP Connection Linger	Specifies whether client connections are disconnected with a proper TCP Close Handshake or directly kills the connection. Direct reset /kill offers better performance, but some old, finicky undefined clients and connection pooling libraries might require TCP Linger set to ON.	Turn ON/OFF.
   Verbose Debug Mode	When enabled, initiates the troubleshooting mode in ScaleArc at the cluster level. This mode captures and downloads the raw logs (including tcpdump) for the cluster.   Enabling this option creates large log files and may slow down performance. Call ScaleArc customer support if you need assistance.	Turn ON to run the verbose debug mode.
   Download/Delete	Downloads the log files. Specify the duration that you wish to execute the verbose debug mode on a cluster. The verbose debug mode will generate an event for the log files. The downloaded log files are available in tar.gz format. Only the latest debug file is available for download.	Click Download. Specify duration. Click Delete if you wish to remove the downloaded files.
   Connection Pooling	Requires configuration of the the SQL Server packet size, which is the same size as that of the TDS packets. You may need to reconfigure this setting to a higher value if the traffic throughput through ScaleArc is reduced, especially in authentication offload ON mode.    Be sure to restart the cluster if you make changes to the TDS packet size.	Turn ON/OFF.
   AutoFetched User Status	When enabled, sets the status of all database users fetched automatically in the Users & DB’s section to Enabled.	Default setting is ON.

2. Click Apply All to submit changes or click Load Defaults to reset to factory settings.