Home / server / Questions / 163052
In Process
Graham Powell
Asked: 2010-07-23 06:09:49 +0800 CST

Citrix server running 3rd party app experiencing SQL timeouts

  • 772

We are running an app that was not developed in house on several Citrix servers. The users of this application are experiencing intermittent SQL timeouts. The error message:

"System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."

We're not seeing any errors on our SQL server, and we don't have the option to modify the code to resolve the problem. Is there a way to modify SQL connection properties for all connections made from the Citrix server?

Thanks,

Graham

sql-server citrix

1 Answers

  1. Have a check on SQL Server Maintenance Plan, it sounds like some database index needs rebuild. In the worst case some database index may be missing at all, so application databases need some performance tuning.

    • 0